Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Thursday, March 28, 2024
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  setting time zone

phpMyEdit Features     setting time zone
Post new topic   Reply to topic    
 
sundua     Joined: 03 Nov 2016   Posts: 3  
Post 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)
Post 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  
Post 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)
Post 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  
Post 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  
Post 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  
Post 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    

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy