RE: [PHP-DB] whats wrong with my sql insert statement?
| From: | Michael Hazelden | Date: | Tue, 10 Sep 2002 00:10:30 +0000 |
| Subject: | RE: [PHP-DB] whats wrong with my sql insert statement? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21653@lists.php.net to get a copy of this message | ||
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>
#
#
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
_____________________________________________________________________
This message has been checked for all known viruses by the
MessageLabs Virus Control Centre.
This message has been checked for all known viruses by the MessageLabs Virus Control Centre.
*********************************************************************
Notice: This email is confidential and may contain copyright material of Ocado Limited (the
"Company"). Opinions and views expressed in this message may not necessarily reflect the
opinions and views of the Company.
If you are not the intended recipient, please notify us immediately and delete all copies of this
message. Please note that it is your responsibility to scan this message for viruses.
Company reg. no. 3875000. Swallowdale Lane, Hemel Hempstead HP2 7PY
*********************************************************************