Get Current Time

I want to get the current time of the system in a format like:

2010-06-11 14:12:09

Thank you in advance

 

date("Y-m-d h:i:s");

 

http://php.net/manual/en/function.date.php

 

In the query statement itself instead of the value place this function CURDATE().

So, like: $dbConnection->query("INSERT INTO table (someDate, x, x, x) VALUES(CURDATE(), y, y, y)"); - I did not test this, but seems to be right, Xs and Ys are just other values.

 

If you need time in there as well, you would use NOW() instead of CURDATE(). Usually I use NOW for both as the overhead is negligible. If you use CURDATE on a timestamp or datetime column you end up with zero's in the time section of the column.

 

why not use NOW() on mysql?

 

Yep, NOW() is good.