[RESOLVED] Timezone and shared hosting

saidbakr

Hi,

Is there any way to keep my scripts code without any change when it is being hosted on shared hosting, since there is using of date() in PHP and NOW in MySQL.

For instance, I'd like the shared hosting to deal with the timezone as +2 GMT and this should be applied for the PHP and MySQL.

The NOW() is used during the the SQL query some thing like SELECT NOW() FROM tbl_name and I want it to return NOW() value in +2 GMT.

I think, but I don't know exactly how, .htaccess may have a solution for this to PHP but what really I think it is hard, the section regarding MySQL.

If there any suggest or advice, I will be very much appreciated. Please, keep in mind that I don't want changing the code of my scripts. However, my script have global configuration file that maintain the MySQL connection data such as happened in Dreamweaver sites.

sneakyimp

You might set the timezone on the server (in the operating system) to be the same on all machines running your code?

Otherwise, it can be pretty complicated. You might have to create a configuration file for any given server which indicates what the local timezone is to convert to your time zone.

Another possibility is to convert all times to greenwich mean time.

You may also find this function useful
http://us2.php.net/manual/en/function.date-default-timezone-set.php

saidbakr

The issue what I thought it is more difficult to solve is solved first!
For MySQL timezone and after some reading of MySQL documentation I found the solve for MySQL Timezone part of my problem.

As I regarded in the post, there is a global configuration file that store database connection setting. What I need is to add line of set timezone as follows and after mysql_pconnect()
mysql_query("SET time_zone = '+02:00'") hence the configuration file becomes as follows:

$hostname_dataKont = "localhost";
$database_dataKont = "xxxx";
$username_dataKont = "xxxx";
$password_dataKont = "xxXxx";
$dataKont = mysql_pconnect($hostname_dataKont, $username_dataKont, $password_dataKont) or trigger_error(mysql_error(),E_USER_ERROR); 
mysql_query("SET time_zone = '+02:00'")

After that every NOW() in any MySQL query will return plus two hours than GMT.

However, I still don't know how to manage .htaccess to enforce PHP returning date() value as this value. So I'm waiting any suggestion.

sneakyimp

You didn't read my post:

http://us2.php.net/manual/en/function.date-default-timezone-set.php