[RESOLVED] Simple Insert is causing me trouble

jcarswell72

Yes, I am a newbie with PHP so any help is greatly appreciated. I am trying to do an insert from a webform. Here is my code:

$sql="INSERT INTO Mailing (Email, DateAdded)
VALUES('$_POST[Email]',NULL)";

2 issues:

1--it is not being inserted. I have tried all kind of syntax variations and hope that someone out there can help. (If my syntax is correct, then I can rule this line of code out as the issue.)

2--I would like to replace the NULL with the current date. I tried curdate(), Now(), and others with no luck. I also tried setting the default through PHPAdmin for this field so that I wouldn't have to pass a variable from the webpage, but couldn't find a function that would work.

Again, any help is greatly appreciated.

Thx, Joanne

laserlight

jcarswell72 wrote:
1--it is not being inserted. I have tried all kind of syntax variations and hope that someone out there can help. (If my syntax is correct, then I can rule this line of code out as the issue.)

You only created a PHP string whose value is an SQL statement. You need to actually run that SQL statement and how to do that depends on what database system and database extension you are using.

By the way, you should properly escape incoming variables like $_POST[email] before using it in an SQL statement. If your database extension supports it, you could consider the use of prepared statements for this.

jcarswell72 wrote:
2--I would like to replace the NULL with the current date. I tried curdate(), Now(), and others with no luck.

What is the type of the corresponding column?

jcarswell72

Thanks for your help; I do appreciate it so much. Here is my other code:

$db = mysql_connect("localhost", $dbuser, $dbpass);

mysql_select_db($dbname, $db);

$sql="INSERT INTO MailingList'.'Mailing'('Email', 'DateAdded')
VALUES('$_POST[Email]',CURDATE())";

mysql_close($db);

1) I understand what you are saying, but unsure how to fix it. I changed the main statement some last night after posting. Hopefully I did not make it worse.

2) As you can see I am passing Curdate() in for DateAdded now and that seems to be working although since the data base is not updating, I am not sure yet. The DateAdded field is a date type that I set in phpadmin.

Thanks again for your help,
Joanne

jcarswell72

UPDATE:

I figured out how to setup the statement to execute the insert statement. The Curdate() is working fine also.

Thanks again for your help.