require_once("/home/users/web/b1565/pow.daviddude/htdocs/functions.php"); do_header("Grades", "../Student_Tools/menu.txt"); ?> if($pin_login) { $conn = db_connect() or die("Error connecting to database. ".mysql_error()); $result = mysql_query("SELECT * FROM StudentInfo WHERE user_id = '$studentid' AND pin = '$pin'") or die("Error querying database. ".mysql_error()); if (mysql_num_rows($result)==1) $show_form = 0; else $show_form = 1; while($row = mysql_fetch_assoc($result)) { extract($row); } } elseif($pwd_login) { //echo "
Password login
"; $conn = db_connect() or die("Error connecting to database. ".mysql_error()); $result = mysql_query("SELECT StudentInfo.block as block, StudentInfo.user_id as user_id FROM StudentInfo, AlternateLogin WHERE AlternateLogin.username = '$username' AND AlternateLogin.password = '$password' AND StudentInfo.user_id = AlternateLogin.user_id") or die("Error querying database. ".mysql_error()); //echo "num_rows = ".mysql_num_rows($result)."
"; if (mysql_num_rows($result)>0) { //echo "0
"; $show_form = 0; } else { //echo "1
"; $show_form = 1; } //echo "Show form = $show_form
"; while($row = mysql_fetch_assoc($result)) { extract($row); } //echo "block = $block and user_id = $user_id
"; } else $show_form = 1; if($show_form) { //display login form ?>Grades last uploaded: