OK
The form input...
Student Enrollment Number:<br>
<input type=text name="student_number" size=30><p>
Password:<br>
<input type=text name="unique_pass" size=30><p>
<input type=submit name=submit value="View Records">
The reviewrecords.php page...
php
include("dbinfo.inc.php");//connection string
$student_number = $_POST['student_number'];
$unique_pass = $_POST['unique_pass'];
If ($student_number=="student_number" && $unique_pass=="unique_pass") {
echo 'Access Confirmed<br>'; //not necessary to display
}
Else
{
echo 'Access Denied<br>';
echo 'Your Student Number or Password is incorrect.<br>';
echo 'Please try again. Login Page';
}
$dbh=mysql_connect ("localhost", "$username", "$password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("$database");
$query=("SELECT * FROM studentinfo WHERE student_number='$student_number' AND unique_pass='$unique_pass'");
$result = mysql_query($query);
$num=mysql_num_rows($result);
$i = 0;
echo "<table width=500 border=1 cellpadding=5 cellspacing=0><tr>";
while ($i < $num):
$id=mysql_result($result,$i,"id");
$fname=mysql_result($result,$i,"fname");
$lname=mysql_result($result,$i,"lname");
$student_number=mysql_result($result,$i,"student_n umber");
$unique_pass=mysql_result($result,$i,"unique_pass" );
$grade_level=mysql_result($result,$i,"grade_level" );
$total_days=mysql_result($result,$i,"total_days");
$total_attend=mysql_result($result,$i,"total_atten d");
$total_absent=mysql_result($result,$i,"total_absen t");
echo "<td>$fname $lname<br>
$student_number<br>
$grade_level<br>
$unique_pass<br>
$total_days<br>
$total_attend<br>
$total_absent
echo "</td></tr>";
$i++;
endwhile;
/php