Index
» Projects
» phpMyEdit
» Forum
» setting time zone |
|
sundua
Joined: 03 Nov 2016
Posts: 3
Posted: 2016-11-04 09:10
Back to top
Reply with quote
|
I am in time zone at plus 5 and half hours . I have stored timestamp and it is showing minus 9 hours in display as server is at minus nine hours location . Please HELP to set time zone php code
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2016-11-06 20:00
Back to top
Reply with quote
|
http://php.net/manual/en/function.date-default-timezone-set.php
|
sundua
Joined: 03 Nov 2016
Posts: 3
Posted: 2016-11-07 00:22
Back to top
Reply with quote
|
I am able to get time zone SET/Modify in PHP server . But The timestamps STORED in MySql Server are displaying in phpmyedit as EDT time zone . But I want to change this timezone in SQL sever. I need to tweak settings in phpmyedit . in PHP code my sql settings are like this as shown below. and it works in my other areas of PHP code
$link = mysqli_connect($mysql_host,$mysql_user,$mysql_password,$mysql_database );
mysqli_query($link , "SET `time_zone` = '".date('+5:30')."'") ;
How to add this type of "set time zone " in phpmyedit. I am not conversant with OOP
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2016-11-07 18:05
Back to top
Reply with quote
|
Use your text editor to search in the class file for
function connect()
Near the end of function connect(), just before it returns true, insert this:
mysql_query($this->db, "SET `time_zone` = '+05:30'");
|
sundua
Joined: 03 Nov 2016
Posts: 3
Posted: 2016-11-08 00:20
Back to top
Reply with quote
|
I added this
mysql_query("SET `time_zone` = '+5:30'" );
and it works !!!!!!!!!!!!!!!!!!! Many thanks
|
sunotykiv
Joined: 26 Oct 2021
Posts: 1
Posted: 2021-10-26 08:44
Back to top
Reply with quote
|
There are software developments that are presenting the new ideas and its location is different. As far as this is concerned,
lock installation
is one of the essential component that is sharing with other.
|
Annonimuse
Joined: 06 Nov 2021
Posts: 4
Posted: 2021-11-06 06:57
Back to top
Reply with quote
|
Time is one of the precious things and we need to take care of it all the time. According to some new aspects,
mobile iv therapy near me
is there to share some parts that are proper for all.
|
Post new topic
Reply to topic
|
|
|
|