Re: whats wrong with my sql insert statement?
| From: | user at domain dot invalid | Date: | Tue, 10 Sep 2002 01:38:00 +0000 |
| Subject: | Re: whats wrong with my sql insert statement? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21654@lists.php.net to get a copy of this message | ||
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.
#
<?php
$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: user@domain.invalid [mailto:user@domain.invalid]
Sent: 10 September 2002 01:15
To: php-db@lists.php.net
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
<?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
#
<html>
<head>
<title>New Record</title>
</head>
<body>
<p>Please fill out the following information:</p>
<form method="post" action="input.php"" enctype="multipart/form-data">
<table width="100%" border="0" cellspacing="3" cellpadding="3">
<tr>
<td width="25%">first_name:</td>
<td width="75%"><input name="first_name" type="text" size=40 maxlength=255 value=""></td>
</tr>
<tr>
<td width="25%">location:</td>
<td width="75%"><input name="location" type="text" size=40 maxlength=255 value=""></td>
</tr>
<tr>
<td width="25%">phone:</td>
<td width="75%"><input name="phone" type="text" size=40 maxlength=255 value=""></td>
</tr>
<tr>
<td width="25%">messages:</td>
<td width="75%"><input name="messages" type="text" size=40 maxlength=255 value=""></td>
</tr>
<tr>
<td width="25%"> </td>
<td width="75%" align="left"><input type="submit" name="submit" value="Enter"> <input type="reset" name="reset"></td>
</tr>
</table>
</form>
</body>
</html>
#
#