Forum Moderators: coopster
add.php
<?
# this is processed when the form is submitted
# back on to this page (POST METHOD)
if ($REQUEST_METHOD=="POST") { # setup SQL statement
$SQL = " INSERT INTO Recipes ";
$SQL = $SQL . " (name, publisher, category, summary, ingredients, method) VALUES ";
$SQL = $SQL . " ('$name', '$publisher','$category','$summary','$ingredients','$method') ";
#execute SQL statement
$result = mysql_db_query($db,"$SQL",$cid);
# check for error
if (!$result) { echo("ERROR: " . mysql_error() . "\n$SQL\n"); }
echo ("<P><B>Your Entry Has Been Added</B></P>\n");
}
?>
<FORM NAME="fa" ACTION="add.php" METHOD="POST">
<TABLE>
<TR><TD><B>Recipe Name: </B> </TD><TD><INPUT TYPE="text" NAME="name" SIZE=40></TD></TR>
<TR><TD><B>Publisher:</B> </TD><TD><INPUT TYPE="text" NAME="publisher" SIZE=40></TD></TR>
<TR><TD><B>Category:</B> </TD><TD><SELECT name="category" class="textbox">
<OPTION value="BBQ">BBQ</OPTION>
<OPTION value="Desserts">Desserts</OPTION>
<OPTION value="Salads">Salads</OPTION>
</SELECT></TD></TR>
<TR><TD VALIGN=TOP><B>Summary: </B> </TD><TD> <TEXTAREA NAME="summary" ROWS=3 COLS=40></TEXTAREA></TD></TR>
<TR><TD VALIGN=TOP><B>Ingredients: </B> </TD><TD> <TEXTAREA NAME="ingredients" ROWS=5 COLS=40></TEXTAREA></TD></TR>
<TR><TD VALIGN=TOP><B>Method: </B> </TD><TD> <TEXTAREA NAME="method" ROWS=5 COLS=40></TEXTAREA></TD></TR>
<TR><TH COLSPAN=2><P><INPUT TYPE="submit" VALUE="Add"></P></TH></TR>
</TABLE>
</FORM>
view.php
<?php echo "Recipe Name: ".$myrow["name"];
echo "<br>Publisher: ".$myrow["publisher"];
echo "<br>Category: ".$myrow["category"];
echo "<br>Summary: ".$myrow["summary"];
echo "<br><br>Ingredients: ".$myrow["ingredients"];
echo "<br><br>Method: ".$myrow["method"];
?>
Any help would be GREATLY appreciated ;)
[us2.php.net...]
PHP and HTML [php.net]
htmlentities() [php.net]
htmlspecialchars() [php.net]
HTTP Functions [php.net]
Features [php.net]