PHP and MySql have separate default timezone setting.

First set PHP timezone by edit php.ini.

1. Search php.ini.

In localhost search in php5 folder. For VPS search in /etc folder.

2. Add in [date] section as date.timezone = 'timezone'.

Example : date.timezone = Asia/Calcutta.

If you're running shared host, its not possible to edit php.ini, so you need use php function like: date_default_timezone_set('Asia/Calcutta');

Set timezone in MySql.

1. Get the timezone value by using date() function.

i.e. $tmz = date('P');

2. Run query: SET time_zone= $tmz;

Now PHP and MySql have same timezone value.