RE: [PHP-DB] Re: Insert Newbie

Yeah, that too =) On Sun, 22 Sep 2002 22:02:31 +0000, John Holmes wrote: > From manual page on mysql_db_query(): > > Note: This function has been deprecated since PHP 4.0.6. Do not use this > function. Use mysql_select_db() and mysql_query() instead. > > ---John Holmes... > >> -----Original Message----- >> From: Jason Morehouse [mailto:jm@netconcepts.com] >> Sent: Sunday, September 22, 2002 8:59 PM >> To: php-db@lists.php.net; Brandon Boyce >> Subject: [PHP-DB] Re: Insert Newbie >> >> $result = mysql_db_query($db,"$SQL",$cid) or die (mysql_error()); >> >> ...should give you and idea. >> >> On Sun, 22 Sep 2002 12:05:19 +0000, Brandon Boyce wrote: >> >> > 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> >> >> -- >> Jason Morehouse (jm[@]netconcepts[.]com) >> Netconcepts - http://www.netconcepts.com >> Auckland, New Zealand >> Linux: Because rebooting is for adding hardware. >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php -- Jason Morehouse (jm[@]netconcepts[.]com) Netconcepts - http://www.netconcepts.com Auckland, New Zealand Linux: Because rebooting is for adding hardware.