Im trying to follow the book's section on Access Logger but keep getting the error on line 16 which refers to
if(!mysql_num_rows($result)) return 0;
what am i doing wrong?
Warning: Supplied argument is not a valid MySQL result resource in /home/ajay/public_html/auth_user.php on line 16
Authorisation failed. Login
Membership
$register_script = "./register.php";
function auth_user($userid, $password1) {
global $ajay_db, $Customer;
$connection = db_connect();
$query = "SELECT username FROM $Customer WHERE userid = '$userid' AND password1 = password('$password1')";
$result = mysql_query($query);
if(!mysql_num_rows($result)) return 0;
else {
$query_data = mysql_fetch_row($result);
return $query_data[1];
}
}
function login_form() {
global $PHP_SELF;
?>
<HTML>
<HEAD>
</HEAD>
<BODY>
<FORM METHOD="POST" ACTION="<? echo $PHP_SELF ?>">
User ID:
<INPUT TYPE="TEXT" NAME="userid" SIZE="8">
<BR>
Password:
<INPUT TYPE="PASSWORD" NAME="password1" SIZE="8">
<BR>
<INPUT TYPE="SUBMIT" VALUE="LOGIN" NAME="Submit">
</BODY>
</HTML>
<?
}
session_start();
if(!isset($userid)) {
login_form();
exit;
}
else {
session_register("userid", "password1");
$username = auth_user($userid, $password1);
if(!$username) {
session_unregister("userid");
session_unregister("password1");
echo "Authorisation failed. ";
echo "<A HREF=\"$PHP_SELF\">Login</A><BR>";
echo "<A HREF=\"$register_script\">Membership</A>";
exit;
}
else echo "Welcome, $username";
}
?>
Sessions
