Inserting DATE TIMESTAMP Value to MySQL Using PHP

Question

Using php I am inserting or updating the mysql database with create date or modified date using the variables

$datestring = "%Y:%m:%d %h:%i:%s";
$time = time();
$createdate= mdate($datestring, $time);

In this $createdate will be the variable I use to insert or update the table. But it's updating the wrong value. It's not the server time or localtime. Mostly it's 30 mins delay with the server's time.

Answer 1

Use date() function of PHP

$createdate= date('Y-m-d H:i:s');

Answer 2

Edit: after some googling it looks like you're using CodeIgniter. You should have mentioned that in your question.

The format string you're using doesn't match MySQL's date format. You want to use:

$datestring = '%Y-%m-%d %H:%i:%s';