Error running insert with NOW()

Question

kwedsd Apr '18

Created Apr '18	Last Reply Apr '18	Replies 2	Views 272	Votes 0

kwedsd 6.6k

I have been trying to run the following query:

$user = new Users(); $user->save( [ "name" => $name, "created_at" => NOW(), ] );

When executed I get the following error: Call to undefined function NOW() please can anyone advise.

Thanks

corentin-begne · Answer 1 · 2018-04-05T11:46:17-07:00

corentin-begne
12.8k

Nikolay Mihaylov · Answer 2 · 2018-04-05T11:48:42-07:00

NOW() is a MySQL function, that's why you are getting the PHP error. Use time() or follow @corentin-begne link :)

$user->save( [ "name" => $name, "created_at" => time() ] );