PHP : how to insert (into an Sql table) a variable and concatenate it with the date function

Question

i've been trying to insert a row into an Sql database table , and that row's last column is supposed to contain a variable and i can't figure out how to concatenate that variable with a date function. The problem becomes the single quote marks

$SQL = "INSERT INTO news VALUES (NULL, '$user', '$text'.'date('Y-m-d H:i:s')')";

That $text is supposed to have a "date now" function called right after it so that i would have the date that it was inserted into the table...

Thanks

Nelson Benítez León · Accepted Answer · 2013-05-05 14:02:24Z

2

Try this:

$sql = "INSERT INTO news VALUES (NULL, '$user', '$text<br>".date('Y-m-d H:i:s')."')";

edited May 5, 2013 at 14:02

answered May 5, 2013 at 13:41

Nelson Benítez León

51.1k8 gold badges70 silver badges84 bronze badges

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

3 Comments

Nelson Benítez León Over a year ago

Someone edited my answer to erroneously change the code, why people do that? I've edited it back.

Sebas Over a year ago

No, that person proposed an edit. Then people approve. This is a far more complex social issue [...]. Just rollback

Nelson Benítez León Over a year ago

@user2227494 It's working perfectly fine in this demo codepad.org/MKk6juoM You probably have an error somewhere else.

Fabio · Accepted Answer · 2013-05-05 13:44:03Z

0

You can try this

$SQL = "INSERT INTO news VALUES (NULL, '$user', '".$text." now()')";

answered May 5, 2013 at 13:44

Fabio

23.5k12 gold badges57 silver badges66 bronze badges

Collectives™ on Stack Overflow

PHP : how to insert (into an Sql table) a variable and concatenate it with the date function

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related