Specifications

</tr>
</table>
</form>
<?
}
else
{
// connect to mysql
$mysql = mysql_connect( ‘localhost’, ‘webauth’, ‘webauth’ );
if(!$mysql)
{
echo ‘Cannot connect to database.’;
exit;
}
// select the appropriate database
$mysql = mysql_select_db( ‘auth’ );
if(!$mysql)
{
echo ‘Cannot select database.’;
exit;
}
// query the database to see if there is a record which matches
$query = “select count(*) from auth where
name = ‘$name’ and
pass = ‘$password’”;
$result = mysql_query( $query );
if(!$result)
{
echo ‘Cannot run query.’;
exit;
}
$count = mysql_result( $result, 0, 0 );
if ( $count > 0 )
{
// visitor’s name and password combination are correct
echo “<h1>Here it is!</h1>”;
echo “I bet you are glad you can see this secret page.”;
}
else
{
Implementing Authentication with PHP and MySQL
C
HAPTER 14
14
IMPLEMENTING
AUTHENTICATION
309
LISTING 14.2 Continued
18 7842 CH14 3/6/01 3:35 PM Page 309