_limit = $limit;
}
// Methods for properties
// Getters and Setters
// Methods
public function Login($name, $pwd, $mysqli)
{
$records = $mysqli->query("SELECT * FROM Students WHERE username LIKE '{$name}' AND password LIKE '{$pwd}'");
if($records == false)
{
die("Query contains error" . mysqli_error());
echo "";
return ;
}
$record = mysqli_fetch_array($records);
if($record==NULL)
{
$this->Notify($mysqli, "login failed");
echo "";
return ;
}
else
{
setcookie("name",$record["username"],time()+3600);
setcookie("pwd",$record["password"],time()+3600);
setcookie("info",$record["information"],time()+3600);
$this->Notify($mysqli, "login");
if($record["id"]=="administrator")
{
echo "";
}
else
{
echo "";
}
}
}
public function Sign($name, $pwd, $info, $mysqli)
{
$this->Create($name, $pwd, $info, "user", "sign up", 0, $mysqli);
}
public function Search($id, $name, $mysqli)
{
$this->Notify($mysqli, "search for {$name}");
$keys = $mysqli->query("SELECT * FROM Students WHERE username LIKE '{$id}'");
if($keys == false)
{
die("Query contains error" . mysqli_error());
echo "";
return ;
}
$key = mysqli_fetch_array($keys);
if($key["id"]=="administrator")
{
$flag=1;
}
else{
$flag=0;
}
if($name=="")
{
if($flag==1){echo "";}
else{echo "";}
}
// Execute SQL query, for SELECT returns resource
// on true or false if error
$records = $mysqli->query("SELECT * FROM Students WHERE username LIKE '%{$name}%'");
if($records == false)
{
die("Query contains error" . mysqli_error());
if($flag==1){echo "";}
else{echo "";}
}
$record = mysqli_fetch_array($records);
if($record==NULL)
{
if($flag==1){echo "";}
else{echo "";}
}
else if($flag==1)
{
echo "Student Search Result
";
echo "----------------------------------------------------------------------------------------------------------------------------------
";
echo "| ID
";
echo "| Username
";
echo "| Password
";
echo "| Information
|";
//echo "|";$this->Space("id",20);$this->Space("user",20);$this->Space("password",20);$this->Space("information",30);
echo "
";
echo "----------------------------------------------------------------------------------------------------------------------------------
";
$id = $record['id'];$name = $record['username'];$pwd = $record['password'];$info = $record['information'];
echo "| $id
";
echo "| $name
";
echo "| $pwd
";
echo "| $info
|";
//echo "|";$this->Space($record['id'],20);$this->Space($record['username'],20);$this->Space($record['password'],20);$this->Space($record['information'],30);
echo "
";
echo "----------------------------------------------------------------------------------------------------------------------------------
";
}else
{
echo "Student Search Result
";
echo "-----------------------------------------------------------------------------------------------------
";
echo "| ID
";
echo "| Username
";
echo "| Information
|";
//echo "|";$this->Space("id",20);$this->Space("user",20);$this->Space("information",30);
echo "
";
echo "-----------------------------------------------------------------------------------------------------
";
$id = $record['id'];$name = $record['username'];$info = $record['information'];
echo "| $id
";
echo "| $name
";
echo "| $info
|";
//echo "|";$this->Space($record['id'],20);$this->Space($record['username'],20);$this->Space($record['information'],30);
echo "
";
echo "-----------------------------------------------------------------------------------------------------
";
}
while($record = mysqli_fetch_array($records))
{
if($flag==1)
{
$id = $record['id'];$name = $record['username'];$pwd = $record['password'];$info = $record['information'];
echo "| $id
";
echo "| $name
";
echo "| $pwd
";
echo "| $info
|";
//echo "|";$this->Space($record['id'],20);$this->Space($record['username'],20);$this->Space($record['password'],20);$this->Space($record['information'],30);
echo "
";
echo "----------------------------------------------------------------------------------------------------------------------------------
";
}else
{
$id = $record['id'];$name = $record['username'];$info = $record['information'];
echo "| $id
";
echo "| $name
";
echo "| $info
|";
//echo "|";$this->Space($record['id'],20);$this->Space($record['username'],20);$this->Space($record['information'],30);
echo "
";
echo "-----------------------------------------------------------------------------------------------------
";
}
}
}
public function SearchID($id, $name, $mysqli)
{
$this->Notify($mysqli, "search for id: {$name}");
$keys = $mysqli->query("SELECT * FROM Students WHERE username LIKE '{$id}'");
if($keys == false)
{
die("Query contains error" . mysqli_error());
echo "";
return ;
}
$key = mysqli_fetch_array($keys);
if($key["id"]=="administrator")
{
$flag=1;
}
else{
$flag=0;
}
if($name=="")
{
if($flag==1){echo "";}
else{echo "";}
}
// Execute SQL query, for SELECT returns resource
// on true or false if error
$records = $mysqli->query("SELECT * FROM Students WHERE id LIKE '%{$name}%'");
if($records == false)
{
die("Query contains error" . mysqli_error());
if($flag==1){echo "";}
else{echo "";}
}
$record = mysqli_fetch_array($records);
if($record==NULL)
{
if($flag==1){echo "";}
else{echo "";}
}
else if($flag==1)
{
echo "Student Search Result
";
echo "----------------------------------------------------------------------------------------------------------------------------------
";
echo "| ID
";
echo "| Username
";
echo "| Password
";
echo "| Information
|";
//echo "|";$this->Space("id",20);$this->Space("user",20);$this->Space("password",20);$this->Space("information",30);
echo "
";
echo "----------------------------------------------------------------------------------------------------------------------------------
";
$id = $record['id'];$name = $record['username'];$pwd = $record['password'];$info = $record['information'];
echo "| $id
";
echo "| $name
";
echo "| $pwd
";
echo "| $info
|";
//echo "|";$this->Space($record['id'],20);$this->Space($record['username'],20);$this->Space($record['password'],20);$this->Space($record['information'],30);
echo "
";
echo "----------------------------------------------------------------------------------------------------------------------------------
";
}else
{
echo "Student Search Result
";
echo "-----------------------------------------------------------------------------------------------------
";
echo "| ID
";
echo "| Username
";
echo "| Information
|";
//echo "|";$this->Space("id",20);$this->Space("user",20);$this->Space("information",30);
echo "
";
echo "-----------------------------------------------------------------------------------------------------
";
$id = $record['id'];$name = $record['username'];$info = $record['information'];
echo "| $id
";
echo "| $name
";
echo "| $info
|";
//echo "|";$this->Space($record['id'],20);$this->Space($record['username'],20);$this->Space($record['information'],30);
echo "
";
echo "-----------------------------------------------------------------------------------------------------
";
}
while($record = mysqli_fetch_array($records))
{
if($flag==1)
{
$id = $record['id'];$name = $record['username'];$pwd = $record['password'];$info = $record['information'];
echo "| $id
";
echo "| $name
";
echo "| $pwd
";
echo "| $info
|";
//echo "|";$this->Space($record['id'],20);$this->Space($record['username'],20);$this->Space($record['password'],20);$this->Space($record['information'],30);
echo "
";
echo "----------------------------------------------------------------------------------------------------------------------------------
";
}else
{
$id = $record['id'];$name = $record['username'];$info = $record['information'];
echo "| $id
";
echo "| $name
";
echo "| $info
|";
//echo "|";$this->Space($record['id'],20);$this->Space($record['username'],20);$this->Space($record['information'],30);
echo "
";
echo "-----------------------------------------------------------------------------------------------------
";
}
}
}
public function Create($enteredName, $enteredPwd, $enteredInfo, $enteredId, $log, $flag, $mysqli)
{
$records = $mysqli->query("SELECT * FROM Students WHERE username LIKE '{$enteredName}'");
if($records == false)
{
die("Query contains error" . mysqli_error());
echo "";
return ;
}
$record = mysqli_fetch_array($records);
if($record!=NULL)
{
$this->Notify($mysqli, "create failed");
echo "";
return ;
}
$result = $mysqli->query("INSERT INTO Students(username, password, information, id)
VALUES('{$enteredName}','{$enteredPwd}','{$enteredInfo}','{$enteredId}')");
if($result == false)
{
die("Query contains error");
}
else
{
$this->Notify($mysqli, $log);
if($flag==1)echo "";
else echo "";
}
}
public function Delete($key, $mysqli)
{
$records = $mysqli->query("SELECT * FROM Students WHERE username LIKE '{$key}'");
if($records == false)
{
die("Query contains error" . mysqli_error());
echo "";
return ;
}
$record = mysqli_fetch_array($records);
if($record == NULL)
{
$this->Notify($mysqli, "delete failed");
echo "";
return ;
}
$result = $mysqli->query("DELETE FROM Students WHERE username = '{$key}'");
if($result == false)
{
die("Query contains error");
}
else
{
$this->Notify($mysqli, "delete a user: {$key}");
echo "";
}
}
public function Update($id, $enteredName, $enteredPwd, $enteredInfo, $enteredId, $enteredNew, $mysqli)
{
if($enteredName!=$enteredNew)
{
$records = $mysqli->query("SELECT * FROM Students WHERE username LIKE '{$enteredNew}'");
if($records == false)
{
die("Query contains error" . mysqli_error());
echo "";
return ;
}
$record = mysqli_fetch_array($records);
if($record!=NULL)
{
$this->Notify($mysqli, "update failed");
echo "";
return ;
}
}
$result = $mysqli->query("UPDATE Students SET username = '{$enteredNew}', password = '{$enteredPwd}',
information = '{$enteredInfo}', id = '{$enteredId}' WHERE username = '{$enteredName}'");
if($result == false)
{
die("Query contains error");
}
else
{
if($enteredName==$id)setcookie("name",$enteredNew,time()+3600);
$this->Notify($mysqli, "update a user: {$enteredName}");
echo "";
}
}
public function Profile($id, $enteredPwd, $enteredInfo, $mysqli)
{
$result = $mysqli->query("UPDATE Students SET password = '{$enteredPwd}',
information = '{$enteredInfo}' WHERE username = '{$id}'");
if($result == false)
{
die("Query contains error");
}
else
{
$this->Notify($mysqli, "update profile");
echo "";
}
}
public function Logout($mysqli)
{
$this->Notify($mysqli, "logout");
echo "";
}
public function SearchG($name, $mysqli)
{
$this->Notify($mysqli, "search grades for {$name}");
if($name=="") echo "";
// Execute SQL query, for SELECT returns resource
// on true or false if error
$records = $mysqli->query("SELECT * FROM Grades WHERE name LIKE '%{$name}%'");
if($records == false)
{
die("Query contains error" . mysqli_error());
echo "";
}
$record = mysqli_fetch_array($records);
if($record==NULL)
{
echo "";
}else
{
echo "Grades Search Result
";
echo "----------------------------------------------------------------------------------------------------------------------------------------------------
";
echo "| Name
";
echo "| Math
";
echo "| Art
";
echo "| Science
";
echo "| Feedback
|";
/*echo "|";
$this->Space("name",20);
$this->Space("math",20);
$this->Space("art",20);
$this->Space("science",20);
$this->Space("feedback",30);*/
echo "
";
echo "----------------------------------------------------------------------------------------------------------------------------------------------------
";
$name = $record['name'];$math = $record['math'];$art = $record['art'];$science = $record['science'];$feedback = $record['feedback'];
echo "| $name
";
echo "| $math
";
echo "| $art
";
echo "| $science
";
echo "| $feedback
|";
/*echo "|";
$this->Space($record['name'],20);
$this->Space($record['math'],20);
$this->Space($record['art'],20);
$this->Space($record['science'],20);
$this->Space($record['feedback'],30);*/
echo "
";
echo "----------------------------------------------------------------------------------------------------------------------------------------------------
";
}
while($record = mysqli_fetch_array($records))
{
$name = $record['name'];$math = $record['math'];$art = $record['art'];$science = $record['science'];$feedback = $record['feedback'];
echo "| $name
";
echo "| $math
";
echo "| $art
";
echo "| $science
";
echo "| $feedback
|";
/*echo "|";
$this->Space($record['name'],20);
$this->Space($record['math'],20);
$this->Space($record['art'],20);
$this->Space($record['science'],20);
$this->Space($record['feedback'],30);*/
echo "
";
echo "----------------------------------------------------------------------------------------------------------------------------------------------------
";
}
}
public function SearchS($id, $name, $mysqli)
{
$this->Notify($mysqli, "search for {$name} grade");
if($name=="") echo "";
// Execute SQL query, for SELECT returns resource
// on true or false if error
$records = $mysqli->query("SELECT {$name} FROM Grades WHERE name LIKE '{$id}'");
if($records == false)
{
die("Query contains error" . mysqli_error());
echo "";
}
$record = mysqli_fetch_array($records);
if($record==NULL)
{
echo "";
}else
{
if($name=="*")
{
echo "Grades Search Result
";
echo "----------------------------------------------------------------------------------------------------------------------------------------------------
";
echo "| Name
";
echo "| Math
";
echo "| Art
";
echo "| Science
";
echo "| Feedback
|";
/*echo "|";$this->Space("name",20);
$this->Space("math",20);
$this->Space("art",20);
$this->Space("science",20);
$this->Space("feedback",30);*/
echo "
";
echo "----------------------------------------------------------------------------------------------------------------------------------------------------
";
$name = $record['name'];$math = $record['math'];$art = $record['art'];$science = $record['science'];$feedback = $record['feedback'];
echo "| $name
";
echo "| $math
";
echo "| $art
";
echo "| $science
";
echo "| $feedback
|";
/*echo "|";
$this->Space($record['name'],20);
$this->Space($record['math'],20);
$this->Space($record['art'],20);
$this->Space($record['science'],20);
$this->Space($record['feedback'],30);*/
echo "
";
echo "----------------------------------------------------------------------------------------------------------------------------------------------------
";
}else
{
echo "Grades Search Result
";
echo "
{$name} : {$record[$name]} ";
}
}
}
public function CreateG($name, $math, $art, $science, $feedback, $log, $mysqli)
{
$keys = $mysqli->query("SELECT * FROM Students WHERE username LIKE '{$name}'");
if($keys == false)
{
die("Query contains error" . mysqli_error());
echo "";
return ;
}
$key = mysqli_fetch_array($keys);
if($key == NULL)
{
$this->Notify($mysqli, "submit wrong user");
echo "";
return ;
}
$records = $mysqli->query("SELECT * FROM Grades WHERE name LIKE '{$name}'");
if($records == false)
{
die("Query contains error" . mysqli_error());
echo "";
return ;
}
$record = mysqli_fetch_array($records);
if($record != NULL)
{
$this->Notify($mysqli, "submit grades failed");
echo "";
return ;
}
$result = $mysqli->query("INSERT INTO Grades(name, math, art, science,feedback)
VALUES('{$name}','{$math}','{$art}','{$science}','{$feedback}')");
if($result == false)
{
die("Query contains error");
}
else
{
$this->Notify($mysqli, $log);
echo "";
}
}
public function DeleteG($key, $mysqli)
{
$records = $mysqli->query("SELECT * FROM Grades WHERE name LIKE '{$key}'");
if($records == false)
{
die("Query contains error" . mysqli_error());
echo "";
return ;
}
$record = mysqli_fetch_array($records);
if($record == NULL)
{
$this->Notify($mysqli, "delete failed");
echo "";
return ;
}
$result = $mysqli->query("DELETE FROM Grades WHERE name = '{$key}'");
if($result == false)
{
die("Query contains error");
}
else
{
$this->Notify($mysqli, "delete a grade for {$key}");
echo "";
}
}
public function UpdateG($name, $math, $art, $science, $feedback, $mysqli)
{
$records = $mysqli->query("SELECT * FROM Grades WHERE name LIKE '{$name}'");
if($records == false)
{
die("Query contains error" . mysqli_error());
echo "";
return ;
}
$record = mysqli_fetch_array($records);
if($record == NULL)
{
$this->Notify($mysqli, "update grades failed");
echo "";
return ;
}
$result = $mysqli->query("UPDATE Grades SET math = '{$math}', art = '{$art}',
science = '{$science}' , feedback = '{$feedback}' WHERE name = '{$name}'");
if($result == false)
{
die("Query contains error");
}
else
{
$this->Notify($mysqli, "update a grade for {$name}");
echo "";
}
}
public function Attach(IObserver $observer)
{
$this->_observers[] = $observer;
}
public function Detach(IObserver $observer)
{
$index = array_search($observer, $this->_observers, true);
if($index !== false)
{
array_splice($this->_observers, $index, 1);
}
}
public function Notify($mysqli, $log)
{
foreach($this->_observers as $observer)
{
$observer->Update($this, $mysqli, $log);
}
}
public function Space($str, $lens)
{
$str = strtolower($str);
$txt = str_replace("m","-m",$str);
$txt = str_replace("w","-w",$txt);
$txt = str_pad($txt,$lens,"*",STR_PAD_LEFT);
$txt = str_replace("-m","m",$txt);
$txt = str_replace("-w","w",$txt);
$txt = str_replace("i","+i",$txt);
$txt = str_replace("t","+t",$txt);
$txt = str_replace("j","+j",$txt);
$txt = str_replace(".","+.",$txt);
$txt = str_replace(",","+,",$txt);
$txt = str_replace("'","+'",$txt);
$len = strlen($txt);
$txt = str_replace("+i","i",$txt);
$txt = str_replace("+t","t",$txt);
$txt = str_replace("+j","j",$txt);
$txt = str_replace("+.",".",$txt);
$txt = str_replace("+,",",",$txt);
$txt = str_replace("+'","'",$txt);
$txt = str_pad($txt,$len,"+",STR_PAD_LEFT);
$txt = str_replace("+",' ',$txt);
$txt = str_replace(" ",' ',$txt);
echo str_replace("*",' ',$txt);echo " |";
}
}
?>