Below is the code I used to try to insert info into a mysql database, the
form posts to itself. After I hit the submit button it isn't echoing the
indication that information has been added, and when I check the database
there isn't anything there. help please!
<?
$usr = "username";
$pwd = "password";
$db = "dbname";
$host = "localhost";
# connect to database
$cid = mysql_connect($host,$usr,$pwd);
if (!$cid) { echo("ERROR: " . mysql_error() . "\n"); }
?>
<HTML>
<HEAD>
<TITLE>Insert Link</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<P><FONT SIZE=5><B> Add Link </B> </FONT></P>
<?
if ($REQUEST_METHOD=="POST") {
$description = str_replace("'","''",$description);
$sitename = str_replace("'","''",$sitename);
$SQL = " INSERT INTO links ";
$SQL = $SQL . " (category, sitename, siteurl, description) VALUES ";
$SQL = $SQL . " ('$category', '$sitename','$siteurl','$description')
";
$result = mysql_db_query($db,"$SQL",$cid);
if (!$result) { echo("ERROR: " . mysql_error() .
$SQL\n"); }
echo ("<P><B>New Link Added</B></P>\n");
}
?>
<FORM NAME="fa" ACTION="insert.php" METHOD="POST">
<TABLE>
<TR><TD><B>Category: </B> </TD><TD><INPUT TYPE="text" NAME="category"
SIZE=40></TD></TR>
<TR><TD><B>Site Name:</B> </TD><TD><INPUT TYPE="text" NAME="sitename"
SIZE=40></TD></TR>
<TR><TD><B>Site URL: </B> </TD><TD><INPUT TYPE="text" NAME="siteurl"
VALUE="http://"; SIZE=40></TD></TR>
<TR><TD VALIGN=TOP><B>Description: </B> </TD><TD> <TEXTAREA
NAME="description" ROWS=5 COLS=40></TEXTAREA></TD></TR>
<TR><TH COLSPAN=2><P><INPUT TYPE="submit" VALUE="Add Link"></P></TH></TR>
</TABLE>
</FORM>
<? mysql_close($cid); ?>
</BODY>
</HTML>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
