Many thanks for your help. Below are my verification codes.
<?PHP
$usrName = $HTTP_COOKIE_VARS["AdminUsrName"];
$password = $HTTP_COOKIE_VARS["AdminPassword"];
if($usrName =="" || $password ==""){
echo "You do not have permission to access this page without login properly.<br>";
exit;
}
@ $db = mysql_connect("localhost", "localuser", "localpassword");
if (!$db) {
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("alumni");
//*****************Test if user have permission*******************************************
$query = 'SELECT FROM fndUser WHERE usrName LIKE "%'.$usrName.'%" AND usrPassword = "'.$password.'"';
//echo "Query: ".$query."<br>";
$result = mysql_query($query);
//echo "Result: ".$result."<br>";
$num_results = mysql_num_rows($result);
//echo "Num Results: ".$num_results."<br>";
if ($num_results == ""){
echo 'Incorrect password or username. Please <a href="adminLogin.shtml">login</a> again.<br>';
echo "Thank you!<br>";
exit;
}
?>
How do I incorporate your suggestion into something like the above codes?