Re: Fw: [PHP-DB] whats wrong with my sql insert statement?
my input.html has errors in it. wrong correct strange thing is it used to work. anyhow thanks for the help. Nikos wrote: >>Try remove (;) at the end of the expresion, before quote ("): VALUES >>('$first_name','$location','$phone', '$blabla')...(;)..." >> >>- Original Message - >>From: <[EMAIL PROTECTED]> >>To: <[EMAIL PROTECTED]> >>Sent: Tuesday, September 10, 2002 4:38 AM >>Subject: Re: [PHP-DB] whats wrong with my sql insert statement? >> >> >> >>>Thanks for your suggestions. >>>first my /etc/php.ini >>>register_globals = on >>>second i made the change as you suggested and i added a >>>[$blabla = "truly random";] >>>when the input.php is excuated, 'blabla' value is inserted into the >>>table. '$first_name' is still left blank. >>>this leads me to believe that '$first_name' is blank to start with! >>>somehow the input.html gives input.php blank $first_name , $location . >>>care to look at my input.html ? thanks alot. >>> >>># > >>>$db_name ="cheese_catalog"; >>>$table_name = "user"; >>>$blabla = " bla bla"; >>>$connection = @mysql_connect("localhost","test","new0pass") or >>>die("Couldn't Connect."); >>>$db = @mysql_select_db($db_name, $connection) or die("Couldn't select >>>database."); >>>if ("none_required"=="none_required") { >>> >>>$sql = "INSERT INTO $table_name (first_name,location,phone,messages) >>>VALUES ('$first_name','$location','$phone', '$blabla');"; >>>$result = @mysql_query($sql, $connection) or die("Error #". >>>mysql_errno() . ": " . mysql_error()); >>> >>>include("input_added.html"); >>> >>>} >>> >>>?> >>># >>> >>> >>>Michael Hazelden wrote: >>> Hi there, Two things: (a) in my experience - you should use single quotes in your query to surround the values and so you don't need to escape them either (e.g. '$first_name') and (b) Make sure register_globals is on - otherwise you need to use $_POST[first_name] Cheers, Michael. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 10 September 2002 01:15 To: [EMAIL PROTECTED] Subject: [PHP-DB] whats wrong with my sql insert statement? Hi I am using redhat 7.3 with mysql-3.23.49-3 php-4.1.2-7.3.4 apache-1.3.23-11. I want to insert few values into a mysql table. This input.php sort works. it will add a new entray to the table but with blank values. >>> > What > did I do wrong? # # # file name input.php >>> $db_name ="cheese_catalog"; $table_name = "user"; $connection = @mysql_connect("localhost","test","test") or >>> > die("Couldn't > Connect."); $db = @mysql_select_db($db_name, $connection) or die("Couldn't select database."); if ("none_required"=="none_required") { $sql = "INSERT INTO $table_name (first_name,location,phone,messages) VALUES (\"$first_name\",\"$location\",\"$phone\", \"$messages\");"; $result = @mysql_query($sql, $connection) or die("Error #". mysql_errno() . ": " . mysql_error()); include("input_added.html"); } ?> # # file name input.html # New Record Please fill out the following information: first_name: >> > size=40 > maxlength=255 value=""> location: >>>maxlength=255 value=""> phone: >>>maxlength=255 value=""> messages: >>>maxlength=255 value=""> >>>name="submit" value="Enter"> >> > name="reset"> > # # >>> >>> >>> >>>-- >>>PHP Database Mailing List (http://www.php.net/) >>>To unsubscribe, visit: http://www.php.net/unsub.php >>> >> > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Fw: [PHP-DB] whats wrong with my sql insert statement?
> Try remove (;) at the end of the expresion, before quote ("): VALUES > ('$first_name','$location','$phone', '$blabla')...(;)..." > > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, September 10, 2002 4:38 AM > Subject: Re: [PHP-DB] whats wrong with my sql insert statement? > > > > Thanks for your suggestions. > > first my /etc/php.ini > > register_globals = on > > second i made the change as you suggested and i added a > > [$blabla = "truly random";] > > when the input.php is excuated, 'blabla' value is inserted into the > > table. '$first_name' is still left blank. > > this leads me to believe that '$first_name' is blank to start with! > > somehow the input.html gives input.php blank $first_name , $location . > > care to look at my input.html ? thanks alot. > > > > # > > > > > $db_name ="cheese_catalog"; > > $table_name = "user"; > > $blabla = " bla bla"; > > $connection = @mysql_connect("localhost","test","new0pass") or > > die("Couldn't Connect."); > > $db = @mysql_select_db($db_name, $connection) or die("Couldn't select > > database."); > > if ("none_required"=="none_required") { > > > > $sql = "INSERT INTO $table_name (first_name,location,phone,messages) > > VALUES ('$first_name','$location','$phone', '$blabla');"; > > $result = @mysql_query($sql, $connection) or die("Error #". > > mysql_errno() . ": " . mysql_error()); > > > > include("input_added.html"); > > > > } > > > > ?> > > # > > > > > > Michael Hazelden wrote: > > > Hi there, > > > > > > Two things: > > > > > > (a) in my experience - you should use single quotes in your query to > > > surround the values and so you don't need to escape them either (e.g. > > > '$first_name') > > > > > > and (b) Make sure register_globals is on - otherwise you need to use > > > $_POST[first_name] > > > > > > Cheers, > > > > > > Michael. > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > Sent: 10 September 2002 01:15 > > > To: [EMAIL PROTECTED] > > > Subject: [PHP-DB] whats wrong with my sql insert statement? > > > > > > > > > Hi > > > I am using redhat 7.3 with mysql-3.23.49-3 php-4.1.2-7.3.4 > > > apache-1.3.23-11. > > > I want to insert few values into a mysql table. This input.php sort > > > works. it will add a new entray to the table but with blank values. What > > > did I do wrong? > > > # > > > # > > > # file name input.php > > > > > > > > $db_name ="cheese_catalog"; > > > $table_name = "user"; > > > $connection = @mysql_connect("localhost","test","test") or die("Couldn't > > > Connect."); > > > $db = @mysql_select_db($db_name, $connection) or die("Couldn't select > > > database."); > > > if ("none_required"=="none_required") { > > > > > > $sql = "INSERT INTO $table_name (first_name,location,phone,messages) > > > VALUES (\"$first_name\",\"$location\",\"$phone\", \"$messages\");"; > > > $result = @mysql_query($sql, $connection) or die("Error #". > > > mysql_errno() . ": " . mysql_error()); > > > > > > include("input_added.html"); > > > > > > } > > > > > > ?> > > > # > > > > > > # file name input.html > > > # > > > > > > > > > New Record > > > > > > > > > Please fill out the following information: > > > > > > > > > > > >first_name: > > > > > maxlength=255 value=""> > > > > > > > > >location: > > > > > maxlength=255 value=""> > > > > > > > > >phone: > > > > > maxlength=255 value=""> > > > > > > > > > messages: > > > > > maxlength=255 value=""> > > > > > > > > > > > > > > name="submit" value="Enter"> > > > > > > > > > > > > > > > > > > # > > > # > > > > > > > > > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php