Inserting current date into sql using php

Question

I have tried to insert the current date using the now() syntax but it's not working. The column in MySQL is under datetime called date_added but when I check the command prompt all I get is 0000-00-00 00:00:00.

INSERT INTO FOOD (food_name, food_type, total, available, date_added)
VALUES
('$_POST[food_name]','$_POST[food_type]','$_POST[total]','$_POST[available]','NOW()')";

You should be using prepared statements to prevent against SQL injection. Otherwise, you will end up like Bobby. — Kermit
– Kermit, Commented Jan 5, 2014 at 22:04

Kermit · Accepted Answer · 2014-01-05 22:04:54Z

6

You need to remove the single quotes from NOW():

...
VALUES (
$_POST[food_name],
$_POST[food_type],
$_POST[total],
$_POST[available],
NOW())";

edited Jan 5, 2014 at 22:04

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

answered Jan 5, 2014 at 22:03

Donny van V

9811 gold badge11 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Bram Over a year ago

I was a bit confused too, but the whole thing is a string in double quotes. The quotes around the $_POST should stay because those are SQL quotes. Not very beautiful though.

Donny van V Over a year ago

Dont forget to set the quotes in the post value: $_POST['name_from_input_field']

user3142622 Over a year ago

Thank you, it's always the minor issues that have me stumped! will change the quotes too thanks user3158490

Bram · Accepted Answer · 2014-01-05 22:03:52Z

5

Remove the quotes around NOW(), in that way NOW() is treated as a SQL function instead of a string.

VALUES ('$_POST[food_name]','$_POST[food_type]','$_POST[total]','$_POST[available]',NOW())";

answered Jan 5, 2014 at 22:03

Bram

4,55225 silver badges25 bronze badges

Comments

Jeroen Ketelaar · Accepted Answer · 2014-01-05 22:04:54Z

0

Try if the following option works:

GETDATE()

answered Jan 5, 2014 at 22:04

Jeroen Ketelaar

1021 silver badge7 bronze badges

1 Comment

Donny van V Over a year ago

Why a GETDATE()? Removing the quotes is more then enough right?

Donny van V · Accepted Answer · 2014-01-05 22:15:14Z

-1

offtopic:

Is this possible with the array? Never gave it a shot:

$food= array('apple', 'Banana', 'Pineapple');

INSERT INTO food ('fruit_arrays') VALUES ($food)

answered Jan 5, 2014 at 22:15

Donny van V

9811 gold badge11 silver badges24 bronze badges

Collectives™ on Stack Overflow

Inserting current date into sql using php

4 Answers 4

3 Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related