NOW() in php displaying server time

Question

$query = "INSERT INTO reviews (name, mail, review, date_timestamp, time_timestamp)" . "VALUES ('$reviewer_name', '$reviewer_mail', '$reviewer_review', NOW(), NOW())";

NOW() function is displaying time of different zone.How to change it to local time.

Hi Zeratops..SET is not working in my php code – Praneeth A Oct 11 '16 at 11:08 — Praneeth A, Oct 11 '16 at 11:08

Naresh Kumar P · Answer 1 · 2016-10-11T12:09:56.013

1

You need to set the time zone so that the Time will be displayed based on the timezone you set in the function.

Define server timezone and server date format according to your preferences

/* server timezone */
define('CONST_SERVER_TIMEZONE', 'UTC');

/* server dateformat */
define('CONST_SERVER_DATEFORMAT', 'YmdHis');

Function:

function now($str_user_timezone,
       $str_server_timezone = CONST_SERVER_TIMEZONE,
       $str_server_dateformat = CONST_SERVER_DATEFORMAT) {

  // set timezone to user timezone
  date_default_timezone_set($str_user_timezone);

  $date = new DateTime('now');
  $date->setTimezone(new DateTimeZone($str_server_timezone));
  $str_server_now = $date->format($str_server_dateformat);

  // return timezone to server default
  date_default_timezone_set($str_server_timezone);

  return $str_server_now;
}

Reference: http://www.pontikis.net/tip/?id=18

edited Oct 11 '16 at 12:09

answered Oct 11 '16 at 11:09

Naresh Kumar P

4,127
2
16
33

Hi Naresh Thanks for your help.. but since i am using NOW() function I cant use the above.. – Praneeth A Oct 11 '16 at 11:14
See Example One from my answer – Naresh Kumar P Oct 11 '16 at 11:15
@PraneethAlaghari. If so you face any error in this development let me know over here. We shall try to solve it. – Naresh Kumar P Oct 11 '16 at 11:21
Still facing same problem – Praneeth A Oct 11 '16 at 11:39
@PraneethAlaghari. What problem you face still – Naresh Kumar P Oct 11 '16 at 11:44
I pasted the Example 1 of yours exactly above the code and it is displaying error – Praneeth A Oct 11 '16 at 11:45
Try the example three. This May make the trick for you. – Naresh Kumar P Oct 11 '16 at 11:46
I tried but no difference – Praneeth A Oct 11 '16 at 11:51
@PraneethAlaghari. You need to change the MYSQL time format or what.. – Naresh Kumar P Oct 11 '16 at 12:01
@PraneethAlaghari. Check now i have updated the answer – Naresh Kumar P Oct 11 '16 at 12:10

NOW() in php displaying server time

1 Answers1