Storing Information in a Database : mysql_query « MySQL Database « PHP

1. PHP
2. MySQL Database
3. mysql_query

Storing Information in a Database

 
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;
?>
  
  

Related examples in the same category