Why does the PHP date () function give inconsistent times? Off For 2 hours

Question

I have a page where I get the date / time to insert into the MySQL database.

The time zone on which the server is two hours ahead.

In my php.ini I have date.timezone = America/Los_Angeles

I noticed that the time was two hours.

The MySQL field is a datetime type, not a null (and I just noticed that I did not set a default value)

I use Codeigniter if that matters.

This is how I get the time to insert into the database:

$newData['time'] = $time = date("Ymd G:i:s");

After that, I inserted a line of code to write the time to the error log.

log_message('error', "Date time is $time");

Why is time changing so much? This part of the magazine is from 14:00 to 14:30 local time.

All this happens from one page on my site within 29 minutes.

 110 ERROR - 2011-12-20 14:00:57 --> Date time is 2011-12-20 14:00:57 111 ERROR - 2011-12-20 14:01:38 --> Date time is 2011-12-20 14:01:38 112 ERROR - 2011-12-20 14:01:57 --> Date time is 2011-12-20 14:01:57 113 ERROR - 2011-12-20 16:02:19 --> Date time is 2011-12-20 16:02:19 114 ERROR - 2011-12-20 16:02:28 --> Date time is 2011-12-20 16:02:28 115 ERROR - 2011-12-20 14:03:26 --> Date time is 2011-12-20 14:03:26 116 ERROR - 2011-12-20 14:03:32 --> Date time is 2011-12-20 14:03:32 117 ERROR - 2011-12-20 14:03:46 --> Date time is 2011-12-20 14:03:46 118 ERROR - 2011-12-20 14:04:43 --> Date time is 2011-12-20 14:04:43 119 ERROR - 2011-12-20 14:04:53 --> Date time is 2011-12-20 14:04:53 120 ERROR - 2011-12-20 14:04:58 --> Date time is 2011-12-20 14:04:58 121 ERROR - 2011-12-20 14:05:03 --> Date time is 2011-12-20 14:05:03 122 ERROR - 2011-12-20 16:07:05 --> Date time is 2011-12-20 16:07:05 123 ERROR - 2011-12-20 16:07:25 --> Date time is 2011-12-20 16:07:25 124 ERROR - 2011-12-20 16:07:54 --> Date time is 2011-12-20 16:07:54 125 ERROR - 2011-12-20 16:08:05 --> Date time is 2011-12-20 16:08:05 126 ERROR - 2011-12-20 16:08:15 --> Date time is 2011-12-20 16:08:15 127 ERROR - 2011-12-20 16:09:04 --> Date time is 2011-12-20 16:09:04 128 ERROR - 2011-12-20 16:09:14 --> Date time is 2011-12-20 16:09:14 129 ERROR - 2011-12-20 16:09:44 --> Date time is 2011-12-20 16:09:44 130 ERROR - 2011-12-20 16:10:08 --> Date time is 2011-12-20 16:10:08 131 ERROR - 2011-12-20 16:10:27 --> Date time is 2011-12-20 16:10:27 132 ERROR - 2011-12-20 14:12:16 --> Date time is 2011-12-20 14:12:16 133 ERROR - 2011-12-20 14:15:30 --> Date time is 2011-12-20 14:15:30 134 ERROR - 2011-12-20 14:16:20 --> Date time is 2011-12-20 14:16:20 135 ERROR - 2011-12-20 14:17:55 --> Date time is 2011-12-20 14:17:55 136 ERROR - 2011-12-20 14:18:51 --> Date time is 2011-12-20 14:18:51 137 ERROR - 2011-12-20 14:19:16 --> Date time is 2011-12-20 14:19:16 138 ERROR - 2011-12-20 14:20:08 --> Date time is 2011-12-20 14:20:08 139 ERROR - 2011-12-20 14:27:29 --> Date time is 2011-12-20 14:27:29 140 ERROR - 2011-12-20 14:29:31 --> Date time is 2011-12-20 14:29:31 141 ERROR - 2011-12-20 14:29:55 --> Date time is 2011-12-20 14:29:55 

Can anyone shed some light on this for me?

Thanks,

Mark

Answer 1

My guess would be a problem with your system time, such as meouw, or, as John B said, the PHP time zone might be overwritten somewhere in your CI configuration.

Assuming you are using the linux / gnu window, you should change your error logging to something like this:

log_message('error', "PHP time is $time, System time is ".exec('date'));

What should at least tell you if the problem is with your system time or PHP time

(Note: You are looking for time spent on system time, for example, the time of your PHP time, the time in the system, or a second time other than your PHP time is normal)