1- Created The Insert Query for member below.
2- run SELECT * FROM member to make sure the Insert Query took.
3- used the program supplied with the book to run the query in the memberDirectory database
4- run test04 to see if it works.


INSERT INTO member (loginName, password, createDate, lastName, firstName, street, city, state, zip, email, phone, fax)
   VALUES ("mmouse", "secret", "2008-07-04", "Mouse", "Mickey", "123 Main Street", "Disney Land", "CA", "90210", "mmouse@disney.com", "555-555-5551", "555-555-5552")

INSERT INTO member (loginName, password, createDate, lastName, firstName, street, city, state, zip, email, phone, fax)
   VALUES ("gsmith", "password", "2008-08-08", "Smith", "Graham", "220 Bloomfield Ave.", "Iselin", "NJ", "08830", "gsmith@smith.com", "123-123-1234", "201-634-8471")

Program from page 197 (plus additional lines to open and close the database connection.
This becomes test04.php

<?php
$host="localhost";
$user="root";
$password="";
$dbname="memberDirectory";
$cxn = mysqli_connect($host,$user,$password,$dbname)
    or die("Couldn't connect to the server");
echo "This program connected to the ".$dbname." database.<br>\n";
?>

<?php
$userEntry = "secret";   // password user entered from form
$query = "SELECT password FROM member WHERE loginName='mmouse'";
$result = mysqli_query($cxn,$query)
   or die ("Couldn't execute query.");
$row = mysqli_fetch_assoc($result);
if ( $userEntry == $row['password'] )
{
    echo "Login accepted";
}
else
{
    echo "Invalid password";
}

?>

<?php
mysqli_close($cxn);
echo "This program closed the ".$dbname." database successfully.<br>\n";
?>