PHP Form Creation

This page will provide an example form which is partially created from the SQL database. It mixes HTML and PHP to perform this function. A JavaScript routine which is shown on the next page is used to validate the form.

echo "<form name=\"addLink\" onSubmit=\"return checkForm(this);\" action=\"addurl.php\" method=\"POST\">";
<table align="center" border ="0" cellspacing="0" cellpadding="0">
<tr><td><b>URL: </b></td><td><input type="text" name="url" size="60"></td></tr>
<tr><td><b>Optional GIF URL: </b></td><td><input type="text" name="gifurl" size="60"></td></tr>
<tr><td><b>Title: </b></td><td><input type="text" name="title" size="60"></td></tr>
<tr><td><b>Description: </b></td><td rowspan = "2"><textarea wrap="virtual" name="description" value="" cols="50" rows="5"></textarea></td><tr> <tr><td>(Up to 255 chars)</td></tr>
<tr><td><b>Your Name: </b></td><td><input type="text" name="uname" size="60"></td></tr>
<tr><td><b>Your E-mail: </b></td><td><input type="text" name="email" size="60"></td></tr>
<tr><td><b>Site Type: </b>></td><td><SELECT NAME="stype" SIZE="1">
<OPTION VALUE="0">Commercial
<OPTION VALUE="1">Government
<OPTION VALUE="2">Educational
<OPTION VALUE="3">Personal
<OPTION VALUE="4">Organizational
<tr><td><b>Category: </b></td><td>
$chandle = mysql_connect("localhost", $dbuser, $dbpass)
or die("Connection Failure to Database");
mysql_select_db($dbname, $chandle) or die ("Database not found.");
$query1="select * from " . $mainsection . " order by"; //select all sections
$result = mysql_db_query($dbname, $query1) or die("Failed Query of " . $query1);
$sectid[$i1]=$thisrow[0]; //set section values at level 1.
<SELECT NAME="category" SIZE="1">
echo "<OPTION VALUE=\"\"> ";
for ($i2=1; $i2<=$i1; $i2++)
echo "<OPTION VALUE=\"" . $sectid[$i2] . "\">" . $sectdesc[$i2];
<table align="center" border ="0" cellspacing="5" cellpadding="5">
<tr><td><input type="submit" name="submit" value="Add/Change Link"></td><td><input type="reset" value="Clear Form"></td><tr>

The available categories are built from the PHP database by reading the available sections and setting their order to be alphabetical.

PHP Manual Contents Page