Apache time stamp incorrect

Question

I am using WAMP server running PHP. At a particular step I am trying to capture system time and add it to the database with the following query

$strSQLInsert = "UPDATE  track SET  State = 'Repeat' , DateTime = '" . date("m/d/Y h:i:s a") .  "',  where AccID like '". $values['SampleID'] ;

but the time stamp is way off than my system time. The date is okay. I googled and found out that I can update my .htaccess with this line

SetEnv TZ America/Los_Angles

But I couldn't find where htaccess is. How do I get the correct time stamp.

Answer 1

Try to change the timezone in the php.ini configuration file, and then restart the apache service. You should have php.ini somewhere inside your WAMP installation folder.

EDIT: You might have the php.ini file inside the folder:

/wamp/bin/php/phpX.X.X

where phpX.X.X is your php version.

Look for the "date.timezone" line and change it to something like this:

date.timezone = "America/Los_Angeles"

You can find the supported timezones here: http://www.php.net/manual/en/timezones.php

More technical information is available here: http://php.net/manual/en/datetime.configuration.php

The .htaccess file has a local range, normally to the folder and sub-folders where the file is created. Changing the php.ini file makes the changes global to your PHP installation.