|
|
Posted by Jerry Stuckle on 02/02/08 01:51
KB wrote:
> I think I just figured it out. Somehow it worked when I put single quotation
> marks around it. It doesn't make much sense to me, because one would think
> that then it became a literal string instead of a variable. Kind of puzzled,
> but it worked that way???
>
> Kees
>
>
> "KB" <nospam@nospam.com> wrote in message
> news:n2Ooj.23932$E01.11905@newsfe22.lga...
>> Hi, I'm trying to use a PHP script to add a record. It's a very simple
>> table with three fields: Last Name, First Name and Email Address.
>>
>> I ran this script and for some reason, the record doesn't get added, but
>> all the fields do come accross fine. That's why I have the thing at the
>> end where I displayed the fields. When I look at the table, the fields
>> aren't there. I don't get an error either.
>>
>> The connect information has been changed for obvious security reasons. The
>> connect information does work fine with other programs, where it reads the
>> database. I think the problem likes in my SQL string.
>>
>> The variable $result returns a blank.
>>
>> Here is the code:
>>
>> <?php
>>
>> $phpform_lastname = $_POST['form_lastname'];
>> $phpform_firstname = $_POST['form_firstname'];
>> $phpform_email = $_POST['form_email'];
>>
>> //Connect To Database
>> $hostname="hw329d32s7.securecomputer.com";
>> $username="joeuser";
>> $password="Deleb56";
>> $dbname="joeuser";
>> $usertable="addresses";
>>
>> mysql_connect($hostname,$username, $password) OR DIE ("Unable to load the
>> Test Database! Please try again later.");
>> mysql_select_db($dbname);
>>
>> //Make and execute SQL String
>>
>> $query = "INSERT INTO `addresses` (`last_name`, `first_name`,
>> `emailaddress`) VALUES ($phpform_lastname, $phpform_firstname,
>> $phpform_email)";
>> $result = mysql_query($query);
>>
>> ?>
>>
>> <html>
>> <head>
>> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
>> </head>
>>
>> <?php
>>
>> echo "The Result is: ".$result;
>>
>> echo "<BR>I just added the record with the following parameters.<BR>";
>> echo "<BR>";
>> echo "The Last name is: ".$phpform_lastname."<BR>";
>> echo "The First name is: ".$phpform_firstname."<BR>";
>> echo "The Email is: ".$phpform_email."<BR>";
>>
>> ?>
>>
>> </body>
>> </html>
>>
>>
>
>
>
Read the SQL standard. Strings require single quotes around them.
Numeric values do not allow them.
But if you would have checked the result of your mysql_query call and
found you had an error, you could have found it much easier.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
[Back to original message]
|