query("SELECT * FROM user_account");
$username_existed = false;
if($result) {
while ( $row = $result->fetch_assoc() ){
// echo 'no code is found';
if ($row['username'] == $username){
$username_existed = true;
echo 1;
}
}
}
$conn->close();
}
function chk_email($email){
include($_SERVER['DOCUMENT_ROOT'] ."/_ps2020/config/connect.php");
$result = $conn->query("SELECT * FROM user_account");
$email_existed = false;
if($result) {
while ( $row = $result->fetch_assoc() ){
// echo 'no code is found';
if ($row['email'] == $email){
$email_existed = true;
echo 1;
}
}
}
$conn->close();
}
// $code=$_GET['code'];
// // echo "no code is found";
// $result = $conn->query("SELECT * FROM user_account");
// if($result) {
// while ( $row = $result->fetch_assoc() ){
// // echo 'no code is found';
// if ($row['specific_classCode'] == $code){
// echo "Student";
// echo "
";
// echo "class: ".$row['class_name']."";
// }
// else if ($row['specific_teacherCode'] == $code){
// echo "Teacher";
// }
// else if ($row['specific_staffCode'] == $code){
// echo "School-IT-Admin";
// }
// else{
// echo "the code is invalid";
// }
// }
// }
// $conn->close();
?>