session_start(); include 'connect.php'; $enteredusername = $_POST['username']; $enteredpassword = md5($_POST['password']); if ($_SESSION['approved'] == "yes") { ?> exit(); } if ($_SESSION['student'] == "yes") { ?> exit(); } if ($_SESSION['username'] == ""); { $_SESSION['username'] = $enteredusername; } $teachersql = mysql_query("select * from Quiz_users where username = '$enteredusername' AND password = '$enteredpassword' AND position = 'teacher'"); $teachernum = mysql_num_rows($teachersql); $studentsql = mysql_query("select * from Quiz_users where username = '$enteredusername' AND password = '$enteredpassword' AND position = 'student'"); $studentnum = mysql_num_rows($studentsql); if ($teachernum > 0) { $row = mysql_fetch_row($teachersql); $id = $row[0]; $_SESSION['approved'] = "yes"; $_SESSION['id'] = $id; ?> exit(); } else if ($studentnum > 0) { $_SESSION['student'] = "yes"; ?> exit(); } else { ?>
