This tutorial is an introductory guide to get you started in the world of server-side-scripting and web databases. It covers installation and configuration of MySQL, Apache, and PHP. An example script is also included as a guide for making your own server-side-scripts.
We've created the database, now let's make the PHP scripts that form the guts of our web database example.
Creating the PHP Scripts
To keep things really simple, we will just create two scripts: one that lists all the entries in the database, and one that allows us to add new entries.
index.php3
Create a new directory called example in your web directory:
# cd /home/httpd/htdocs
# mkdir example
Next, create a file called index.php3 in this directory. It should contain:
<html>
<head><title>Web Database Sample Index</title>
</head>
<body bgcolor=#ffffff>
<h1>Data from mytable</h1>
<?
mysql_connect("localhost", "webuser", "");
$query = "SELECT name, phone FROM mytable";
$result = mysql_db_query("example", $query);
if ($result) {
echo "Found these entries in the database:<ul>";
while ($r = mysql_fetch_array($result)) {
$name = $r["name"];
$phone = $r["phone"];
echo "<li>$name, $phone";
}
echo "</ul>";
} else {
echo "No data.";
}
mysql_free_result($result);
?>
<p><a href="add.php3">Add new entry</a>
</body>
</html>
add.php3
Next, we create add.php3 in the same directory. This script does two things, first it will prompt the user for information to add to the database. Second, it will add this information to the database. This second function is normally put in a separate file, but it is so easy to do that we cram them both into one PHP script:
<html>
<head><title>Web Database Sample Inserting</title>
</head>
<body bgcolor=#ffffff>
<?
if (isset($name) && isset($phone)) {
mysql_connect("localhost", "webuser", "");
$query = "INSERT INTO mytable VALUES ('$name', '$phone')";
$result = mysql_db_query("example", $query);
if ($result) {
echo "<p>$name was added to the database</p>";
}
}
?>
<h1>Add an entry</h1>
<form>
Name: <input type=text name='name'><br>
Phone: <input type=text name='phone'><br>
<input type=submit>
</form>
<p><a href="index.php3">Back to index</a>
</body>
</html>
Site Administration 
/ 17 
