Debugging problems
| From: | Taline Makssabo | Date: | Tue, 22 May 2001 19:15:19 +0000 |
| Subject: | Debugging problems | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-53901@lists.php.net to get a copy of this message | ||
I'm using this as a log on but it gives me this warning message:
Warning: Supplied argument is not a valid MySQL resource
/httpd/html/php2/login.php on line 27
<? ob_start() ?>
<?php
function access_denied()
Header("WWW-Authenticate: Basic realm=\"$title\"");
Header("HTTP/1.0 401 Unauthorized");
}
function auth_headers($title)
Header("WWW-Authenticate: Basic realm=\"$title\"");
Header("HTTP/1.0 401 Unauthorized");
}
if(!isset($PHP_AUTH_USER))
auth_headers("Members Area");
access_denied();
exit;
}
else {
$db_hostname = "localhost"; // database host, usually "localhost"
$db_username = "contact"; // username for the database (make sure it has
proper privledges)
$db_password = "cdi986"; // password that cooresponds to DB USERNAME
$db_database = "contact_informations"; // what database is your member info
stored in?
$query = "SELECT username,password FROM contact_informations WHERE
username='$PHP_AUTH_USER' AND password='$PHP_AUTH_PW'";
$link = mysql_connect($db_hostname, $db_username, $db_password) or
die("Unable to connect to database server");
if (mysql_num_rows(mysql_db_query($db_database, $query)) == 0)
auth_headers("Members Area");
access_denied();
exit;
}
mysql_close($link);
}
?>