MySQL + PHP时区问题

Question

I currently use $curdate=date('Y-m-d H:i:s'); to enter a timestamp to my blog's MySQL.

The problem is that the timezone of my MySQL is 2 hours ahead. At least in the timesaving period (I don't know if it is going to be any different when the timesaving period is over).

How should I redefine $curdate so that it records correct time based on PST time?

Answer 1

You can set the timezone the PHP uses for the duration of the execution of your script with date_default_timezone_set().

If you need to do something in your own timezone later in the execution of you script, you can call it again to set it back.

Alternatively (better?), if you use the MySQL NOW() function in your query, the time entered into the database will be calculated by MySQL, according to it's own timezone.