Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to setup timezone xampp mysql and apache?

I am using XAMPP - PHP and MYSQL servers. When I tried to use following -

getRates(date('Y-m-d'));



function getRates($cDate)
{
$query = "SELECT * FROM randa WHERE date like '$cDate'" //it only worked at times.  
}

?>

Then I realized the date('Y-m-d') does not return the correct date. Went to php.ini and changed time zone. And is still returning the wrong date.

How can I fix this ? Thank you

like image 563
AirForce Avatar asked Oct 09 '14 02:10

AirForce


Video Answer


2 Answers

Try this

1) In httpd.conf (\xampp\apache\conf\httpd.conf) , add the following line:

SetEnv TZ Europe/Moscow

2) Edit php.ini (\xampp\php\php.ini) date.timezone value in [Date] section:

date.timezone = "Europe/Moscow"

3) In my.ini (\xampp\mysql\bin\my.ini) add or replace

default-time-zone = "Europe/Moscow"

Restart Apache and MySQL

like image 165
Rulisp Avatar answered Nov 06 '22 22:11

Rulisp


Please add this code on your top page.

date_default_timezone_set('America/Los_Angeles');

Search your country here http://php.net/manual/en/timezones.php

like image 28
Putra L Zendrato Avatar answered Nov 06 '22 22:11

Putra L Zendrato