Databases Reference
In-Depth Information
Figure 15-2. The wedding registry login page
TO fred@localhost
IDENTIFIED by 'shhh';
You can enter this statement in the MySQL monitor, or download the
grant_privi
leges.sql
from the topic's home page and run it:
$
mysql --user=root --password=
the_mysql_root_password
< grant_privileges.sql
The Login Form
As the start page for our application, we will show a login form asking users for their
username and password. The HTML source for the login form is show below, and
Figure 15-2 shows the page rendered in a web browser:
<html>
<head>
<title>Jack and Jill's Wedding Gift Registry</title>
</head>
<body bgcolor='LIGHTBLUE'>
<h2>Jack and Jill's Wedding Gift Registry</h2>
(if you've not logged in before, make up a username and password)
<form action="process.php" method="POST">
<br />Please enter a username: <input type="text" name="username" />
<br />Please enter a password: <input type="password" name="password" />
<br /><input type="submit" value="Log in" />
</form>
</body>
</html>
