Mega Code Archive
Storing Information in a Database
<![CDATA[
A sample user authentication table (user_authenticate)
USER ID USERNAME PASSWORD
ur1234 brian 111
ur1145 tom 222
<?
if (!isset($PHP_AUTH_USER)):
header('WWW-Authenticate: Basic realm="Secret"');
header('HTTP/1.0 401 Unauthorized');
exit;
else :
mysql_connect ("localhost", "root", "") or die ("Can't connect to database!");
mysql_select_db ("user_info") or die ("Can't select database!");
$query = "select userid from user_authenticate where
username = '$PHP_AUTH_USER' and
password = '$PHP_AUTH_PW'";
$result = mysql_query ($query);
if (mysql_numrows($result) != 1) :
header('WWW-Authenticate: Basic realm="Secret Family"');
header('HTTP/1.0 401 Unauthorized');
exit;
else :
$userid = mysql_result (user_authenticate, 0, $result);
endif;
endif;
?>
]]>