PHP - Timezone Help

Hi, I am trying to get the date and time that a particular table was last updated, which the code below does, but it doesn't seem to be putting it in the correct timezone, it is 5 hours behind, anyone know why this is? or how i can fix it? Thanks

Code: [Select]
<?php
date_default_timezone_set('Europe/London');
        $query = "SELECT UPDATE_TIME FROM information_schema.tables WHERE TABLE_SCHEMA = 'tffdb' AND TABLE_NAME = 'test_team_points'";
        $result = mysql_query($query) or die(mysql_error());
        
        $row = mysql_fetch_assoc($result);
echo $row['UPDATE_TIME'];

?>

instead of js alert displaying the timezone offset, i would like the content of get_time_zone_offset() to be used as a php variable.

<script type="text/javascript">
    function get_time_zone_offset( ) {
        var current_date = new Date();
        return -current_date.getTimezoneOffset() / 60;
    }

    alert("The local time zone is: GMT " + get_time_zone_offset());
</script>

Hi all

I've got an issue with time zones for displaying information.  I'm hoping someone might know of a guide that would cover the following.  I'm struggling to find one!  Basically I have many online events to list in many different timezones.  Users may wish to use their time zone to display information in.  What I would like to do is store a timestamp and timezone for each event, then will need (I think!) to convert all to a single timezone in order to list them chronologically.  From that I would then convert them into the user's desired timezone and display to the page.

The idea to is avoid changes in time throughout the year, so it does it all automatically.

Any links, tips, words of advice very gratefully received!

I have a Xampp Timezone Error

Error

Warning: strtotime() [function.strtotime]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for '-5.0/no DST' instead in C:\Users\cory j\Desktop\xampp\htdocs\NoXIp\Toplist\inc\vote.php on line 56
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' NOW())' at line 1

Line 56
              $diffrence = time() - strtotime($getDate['lastVoteDate']);


The Date Function in Php.ini
[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = "America/New_York"
date.timezone = "America/New_York"
; http://php.net/date.default-latitude
;date.default_latitude = 31.7667

; http://php.net/date.default-longitude
;date.default_longitude = 35.2333

; http://php.net/date.sunrise-zenith
;date.sunrise_zenith = 90.583333

; http://php.net/date.sunset-zenith
;date.sunset_zenith = 90.583333

I have an idea, which I'm trying to realise, im using the time() function to store the timestamp within my db...and within the db I have a timezone column (which contains the timezone selected by that user).

So I'd like to display $row['timestamp'] (the stored timestamp generated by time()) to the specified timezone, how would that work?

<?php
//$timestamp = timestamp generated by the time() function
//$timezone = the timezone to convert $timestamp too

function convert_time($timestamp, $timezone) {
//$new_timestamp = do something to adapt $timestamp to $timezone

//return the formatted/readable date...
return date('D M Y H:i', $new_timestamp);
}

?>

Hi,

I am writing a script for invoicing various contractor jobs.

I have fields for date assigned and date completed. Both are timestamp with timezone columns in a postgresql table

My goal is to have a cron job which selects the records from the table on the dates the invoices are due and includes the proper jobs-- i.e. the ones that are completed prior to the due date and time(5PM on the first and 15th of each month)

That is where I am running into confusion as to how to store the time/tz and then select it in the future so everything is correct

This is what I have right now:

Code: [Select]
$assignmenttype, "miles" => $miles, "notes" => $notes, "dateassigned" => "{$assignmenty1}-{$assignmentm1}-{$assignmentd1} $time1:00 America/Chicago", "datecompleted" => "{$completedassignmenty1}-{$completedassignmentm1}-{$completedd1} $time2:00 America/Chicago");
    $res = pg_insert($conn, 'assignments', $invoicearray);

Ok well i have a virtual world, my friendcoded the emulator. In PHP but he's on holiday for 2 weeks. I keep getting
Quote

PHP Warning:  PHP Startup: It is not safe to rely on the system's timezone setti
ngs. You are *required* to use the date.timezone setting or the date_default_tim
ezone_set() function. In case you used any of those methods and you are still ge
tting this warning, you most likely misspelled the timezone identifier. We selec
ted 'Europe/London' for '0.0/no DST' instead in Unknown on line 0
PHP Warning:  eval(): It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone
_set() function. In case you used any of those methods and you are still getting
 this warning, you most likely misspelled the timezone identifier. We selected '
Europe/London' for '0.0/no DST' instead in C:\inetpub\wwwroot\main\server\chapat
iz.php(2) : eval()'d code on line 4


But there are only 4 lines in chapatiz.php and it has nothing to do with it i think
Quote

<?php
eval(file_get_contents('serv_original.ini'));
?>



Here's chapatiz.php
(Its attached since its big)
Quote


//config

$socketurl = "munizonline.co.uk;
$httpurl = "munizonine.co.uk;
$rootPath = "c:/inetpub/wwwroot/";

// SQL SETTINGS
$host = 'localhost';
$user = 'root';
$dbname = 'chapatiz';
$password = '---';




$sqli = new mysqli("p:". $host, $user, $password, $dbname); // create a persistant sql connexion (keepAlive)



$banned_ips = array();
///// ADD BAN BY IP FROM HTACCESS
$filename = $rootPath.".htaccess";
$handle = fopen($filename, "r");
$contents = fread($handle, filesize($filename));
fclose($handle);
$contents = utf8_decode($contents);
$ex = explode("\n", $contents);
$exf = array();
foreach ($ex AS $k => $str) {
if(preg_match('`deny from (.*?) \#`', $str, $sortie)) {
$return = $sortie[1]; array_push($exf, $return);
}
}
foreach ($exf AS $k => $str) {
array_push($banned_ips, $str);
}

// LOG ALL ACTIONS
function dolog($text)
{
$myFile = "c:/inetpub/wwwroot/main/log/chat.txt";
$fh = fopen($myFile, 'a');
fwrite($fh, $text. "\n");
fclose($fh);
}


function serve($r)
{
return file_get_contents('C:/inetpub/wwwroot/main/server/serve/'. $r. '.php');
}





function getitems($name)
{
return file_get_contents('http://munizonline.co.uk/main/items.php?u='. $name);
}


function haveitem($name, $item)
{
$c = file_get_contents('http://munizonline.co.uk/main/items.php?u='. $name);
$pattern = '/"'. $item .'"/'; $pattern2 = '/"0'. $item .'"/';
if ((preg_match($pattern, $c)) OR (preg_match($pattern2, $c)))
{
return true;
}
else
{
return false;
}
}



function dotag($tag)
{
$tag = explode('##', $tag);
$tags = array();
foreach ($tag AS $k => $v)
{
list($name, $value) = explode('=', $v);
$tags[$name] = $value;   
}
return $tags;
}


function updatetag($tags, $tochange, $value)
{
$tags[$tochange] = $value; $new = "##";
foreach ($tags AS $k => $v)
{
$new .= $k. "=". $v. '##';
}
return $new;
}



ini_set('display_errors', '1');

error_reporting(0);

$quete8 = $sqli->query('UPDATE phpbb_users SET online = 0');
function cmd()
{
return false;
}
$modee = false;
session_start();
$_SESSION['start'] = "yess";
$mainsock = socket_create(AF_INET, SOCK_STREAM, 0);
  //modifiez la prochaine ligne si besoin

$pport = rand(81, 8000);
while (!socket_bind($mainsock, $socketurl, $pport))
{
$pport = rand(81, 8000); echo "\n port modified to ". $pport. "\n";
}

$myFile = $rootPath."main/server/socket.php";
$fh = fopen($myFile, 'w+') or die("can't open file");
fwrite($fh, $socketurl. ":". $pport);
fclose($fh);


socket_set_nonblock($mainsock);
socket_listen($mainsock);

$clients=Array();
$compteur=0;
$write = NULL;
$except = NULL;
$lol = NULL;
$race = "0";
$flag = "0";
date_default_timezone_set('Europe/London');
$ok_marry = "0";
$ok_pv = "0";

function random($car) {
$string = "";
return $string;
}


function random3($car3) {
$string3 = "";
return $string3;
}

function random2($car2) {
$string2 = "";
return $string2;
}

function random1($car1) {
$string1 = "";
return $string1;
}

echo("Waiting for players!\n");

$file = file_get_contents($rootPath.'main/server/server_while.php');
$lasteval = time();
while(true){
if ($lasteval <= strtotime('-1 minute'))
{
if (file_exists($rootPath."main/server/server_while.php")) {
$file = file_get_contents($rootPath.'main/server/server_while.php');
}
$lasteval = time();
echo "\neval again\n\n";
}
eval($file);
}



I have no clue whats wrong it use to work.

Hello, I am trying to convert the  Date,Month,Year, Hour:Minutes:Seconds  to Timestamp  and Timestamp  to Date,Month,Year, Hour:Minutes:Seconds .   I ve setted the Timezone as Asia/Calcutta in the code .   The Code works well when I run in my localhost , But when I run the code in my server located in Dallas,TX,USA the data changes largely . For example : The Timestamp generated for 24-May-2014 00:00:00 is 1400889600 in my localhost (Chennai, India). The Timestamp generated for 24-May-2014 00:00:00 is 1400914800 in my server (Dallas, TX, USA).   why this changes occurs even though I ve setted the timezone ?   Code:

<?php
$date = new DateTime(null, new DateTimeZone('Asia/Calcutta'));
$ist = ($date->getTimestamp() + $date->getOffset());
echo "<h1>Current Timestamp and Date and Time for India</h1> <b>".$ist.'</b>';echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";echo '<b>'.date('D, d M Y H:i:s ',$ist).'+0530</b>';
echo "<br />";
?>
<h1>Timestamp to Date and Time Converter</h1>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="number" name="timestamp_to_dt_timestamp" id="timestamp_to_dt_timestamp" />
<input type="submit" id="submit" name="submit" value="Submit" />
</form>
<?php 
if (isset($_POST['timestamp_to_dt_timestamp'])) {
$timestamp_to_dt_timestamp = $_POST['timestamp_to_dt_timestamp'];
echo 'Date and Time for the Timestamp :'.$timestamp_to_dt_timestamp.' is : '.date('D, d M Y H:i:s ',$timestamp_to_dt_timestamp);
}
?>
<h1>Date and Time to TimeStamp Converter</h1>
<form method="post" action="<?php echo $_SERVER['PHP_SELF'];?>">
Date (no preceeding zeros):  <input type="text" name="dt_to_timestamp__date" id="dt_to_timestamp__date" value="<?php echo date('j',$ist) ?>" /><br />
Month (number): <input type="text" name="dt_to_timestamp__month" id="dt_to_timestamp__month" value="<?php echo date('n',$ist) ?>" /><br />
Year : <input type="text" name="dt_to_timestamp__year" id="dt_to_timestamp__year" value="<?php echo date('Y',$ist) ?>" /><br />
Hours : <input type="text" name="dt_to_timestamp__hours" id="dt_to_timestamp__hours" value="00" /><br />
Minutes : <input type="text" name="dt_to_timestamp__mins" id="dt_to_timestamp__mins" value="00" /><br />
Seconds : <input type="text" name="dt_to_timestamp__sec" id="dt_to_timestamp__sec" value="00" /><br />
<input type="submit" id="submit" name="submit" value="Submit" />
<p>Leave the time field(s) if you don't know the exact time.</p>
</form>
<?php


if (isset($_POST['dt_to_timestamp__date'])) {
$dt_to_timestamp__date = $_POST['dt_to_timestamp__date'];
}
if (isset($_POST['dt_to_timestamp__month'])) {
$dt_to_timestamp__month = $_POST['dt_to_timestamp__month'];
}
if (isset($_POST['dt_to_timestamp__year'])) {
$dt_to_timestamp__year = $_POST['dt_to_timestamp__year'];
}
if (isset($_POST['dt_to_timestamp__hours'])) {
$dt_to_timestamp__hours = $_POST['dt_to_timestamp__hours'];
}
if (isset($_POST['dt_to_timestamp__mins'])) {
$dt_to_timestamp__mins = $_POST['dt_to_timestamp__mins'];
}
if (isset($_POST['dt_to_timestamp__sec'])) {
$dt_to_timestamp__sec = $_POST['dt_to_timestamp__sec'];
}


if (isset($_POST['dt_to_timestamp__date'])) {
if (isset($_POST['dt_to_timestamp__month'])) {
if (isset($_POST['dt_to_timestamp__year'])) {
if (isset($_POST['dt_to_timestamp__hours'])) {
if (isset($_POST['dt_to_timestamp__mins'])) {
if (isset($_POST['dt_to_timestamp__sec'])) {


echo date(mktime($dt_to_timestamp__hours, $dt_to_timestamp__mins, $dt_to_timestamp__sec, $dt_to_timestamp__month, $dt_to_timestamp__date, $dt_to_timestamp__year));
}
}
}
}
}
}
?>

What I am missing ?   -Thanks

Hi,   Please help to resolve this script.   Default time zone is not working properly it shows time only in AM (PM is not working) and in the INDIAN time 7:00pm  to 7:00am table never fetch any content.

<div class="cart">
                    <table width="100%" height="100%" cellspacing="0" cellpadding="10">
                        <tbody>
                            <tr style="margin: 5px; padding-bottom: 5px; background-color:#ececec; line-height:30px">
                                <td style="width: 10%;">
                                    <span>
                                        Sr. No.
                                    </span>
                                </td>
                                <td style="width: 15%;">
                                    <span>
                                        Order Id
                                    </span>
                                </td>
                                <td style="width: 35%;">
                                    <span>
                                        Order Date / Time
                                    </span>
                                </td>
                                <td style="width: 10%;">
                                    <span>
                                         Amount
                                    </span>
                                </td>
                                <td style="width: 35%;">
                                    <span>
                                         Coupon Name
                                    </span>
                                </td>
                                <td style="width: 10%;">
                                    <span>
                                        Action
                                    </span>
                                </td>                                  
                            </tr>
                            <tr>
                              <td colspan="5" height="10"></td>
                            </tr>
                            
                            <?php
                                date_default_timezone_set("Asia/Dili");
                                $session_user_id = $_SESSION['userId'];
                                $ordercount=1;
                                $current_date = date('Y-m-d');
                                $order_id = $_SESSION['new_order_id'];
                                $query = "select * from cs_order where order_id = '$order_id'";
                                if(!($result = mysql_query($query))) { echo $query.mysql_error(); exit; }
                                $order_items = mysql_fetch_array($result);
                                
                                $order_transaction_id = $order_items['order_transaction_id'];
                                $order_transaction_date = $order_items['order_transaction_date'];
                                $order_currency_id = explode(", ", $order_items['order_currency_id']);
                                $order_amount = $order_items['order_amount'];                                            
                                $order_coupon_id = explode(", ", $order_items['order_coupon_id']);                                        
                                                                
                                $new_order_currency_id = $order_currency_id[0];                                                                                        
                                
                                if(strtotime(date('Y-m-d', strtotime($order_transaction_date)))==strtotime($current_date)) {                             
                            ?>
                            <tr>
                                <td style="width: 10%;">
                                    <span>
                                        <?=$ordercount; ?>
                                    </span>
                                </td>
                                <td style="width: 10%;">
                                    <span>
                                        <?=$order_transaction_id; ?>
                                    </span>
                                </td>
                                <td style="width: 25%;">
                                    <span>
                                        <?=date('d M Y / h:i a', strtotime($order_transaction_date)); ?>
                                    </span>
                                </td>
                                <td style="width: 10%;">
                                    <span>
                                        <?=$new_order_currency_id; ?> <?=$order_amount; ?>
                                    </span>
                                </td>
                                <td style="width: 25%;">
                                    <span>
                                    <?php
                                        $user_id = $_SESSION['userId'];
                                        $current_date = date('Y-m-d');
                                        $order_id = $_SESSION['new_order_id'];
                                        $query = "select * from cs_order as ord left join cs_countries as country on ord.order_country = country.country_id left join cs_states as state on ord.order_state = state.    state_id left join cs_cities as city on ord.order_city = city.    city_id where ord.order_id = '$order_id' and  ord.order_user_id = '$user_id' and ord.order_transaction_date like '$current_date %:%:%'";
                                        if(!($result = mysql_query($query))) { echo $query.mysql_error(); exit; }
                                        $total_invoice_amount = 0;
                                        while($invoice = mysql_fetch_assoc($result)) {
                                            $invoice_record[] = $invoice;
                                        }                        
                                    ?>
                                        <?php echo $invoice_record[0]['order_coupon_name']; ?>
                                    </span>
                                </td>
                                
                                <td style="width: 15%;" align="center">
                                    <span>
                                        <form action="" method="post" name="formGetcode">                                            
                                            <?php
                                                foreach($order_coupon_id as $coup_id) {
                                                    $checkout_couponid = $coup_id['order_coupon_id'];
                                                    $checkoutquery = "select * from cs_coupons as coup left join cs_company as comp on coup.coupons_store = comp.retailer_id where coup.coupons_id = '$checkout_couponid'";
                                                    if(!($checkoutresult = mysql_query($checkoutquery))) { echo $checkoutquery.mysql_error(); exit; }
                                                    $coupon = mysql_fetch_array($checkoutresult);
                                                    $checkout_couponurl = $coupon['coupons_website'];
                                                    $coup_type = $coupon['coupons_type'];                                        
                                            ?>
                                            <?php if($coup_type=='R') { ?>                                                                                    
                                            <button class="submit button" type="button" onclick="getCodePopup(<?=$checkout_couponid; ?>, '<?=$checkout_couponurl; ?>');" style="font-size:11px;width:86px;">Get Code</button>
                                            <?php } else { ?>
                                                <button class="submit button" type="button" onclick="getPrintPopup(<?=$checkout_couponid; ?>);" style="font-size:11px;width:86px;">Print Coupon</button>
                                            <?php } } ?>
                                        </form>
                                    </span>
                                </td>
                               
                            </tr>
                            <?php $ordercount++; } ?>  
                             
                            <tr>
                              <td colspan="5" height="20"></td>
                            </tr>                                                     
                        </tbody>
                    </table>
                </div>
                </div><!--cart container close here-->


And

<script type="text/javascript">
    function getCodePopup(str1, str2) {
        var cid = str1;
        var curl = str2;                    
        window.open('getcouponcode.php?id=' +cid, 'open_window',  ' width=540, height=480, left=0, top=0');        
        window.open(curl,'_blank');
    }
    
    function getPrintPopup(str1) {
        var cid = str1;                                
        window.open('printCoupon.php?id=' +cid, 'open_window1',  ' width=640, height=320, left=0, top=0');                
    }
</script>

Pop Up code not fetching Coupon ID after number 9.   Please help me to solve this.   Thanks.   Paresh      
Edited by mac_gyver, 13 June 2014 - 03:09 AM.
code tags please

Hello Everyone, 

 

I have below datetime string 2021-05-06T13:48:19.2064951+05:30 i need to get the server timezone name by passing this string to date_default_timezone_set(). 

here is it valid?

can somebody please help me i need the timezone name with above datetime string 

Thanks,

Krish

Hey everyone. I was hoping to get some help on something that I am working on.
First, I hope this is the right place to post this. Please forgive me if this is the wrong forum.

I am new to PHP as I work mostly as a Sys Admin.
Recently, I have been working on a project running a number of applications on PHP.
I configured a box and a PHP application that has a web interface.

Everything looks good except for when I log into the web interface. I am greeted with this message:
Code: [Select]
Warning: date() [function.date]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /usr/local/www/base/base_main.php on line 138n
I have done a lot of research trying to figure out what is causing this.
A lot of websites and posts on other sites suggested that the fix would be to make a change in the php.ini file in the : date.timezone section.

I did make that change, however the issue still persists.

I decided to make a quick test.php file to read the configuration file and see if I can get additional information.

I opened up the test.php web page and made sure I was reading the correct configuration file. Which, according to the test page, I am.

Moving forward, under the DATE section of the test.php file, I see this:
Code: [Select]
Warning: phpinfo() [function.phpinfo]: It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/Los_Angeles' for 'PDT/-7.0/DST' instead in /usr/local/www/apache22/data/test.php on line 2
Which is what I see as well when I log into the application's interface.

Under that date section, it says the following:

Code: [Select]
Default timezone -- America/Los_Angeles
Which is my timezone.
For a test, I changed the "date.timezone" section in my php.ini file to "America/New York", restarted apache and loaded the config file backup.
Looking at the  date section again, the error is still there and the DEFAULT TIMEZONE is still pointing to "America/Los_Angeles".

So it appears that its not reading my config file or I am completely missing something.

Here is the full section of the DATE part of the test.php file:
Code: [Select]
date/time support enabled
"Olson" Timezone Database Version 2011.4
Timezone Database internal
Default timezone America/Los_Angeles

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone no value no value
I have been trying to figure this out for the past few day with no luck.
I was hoping someone might be able to help me out here.
Thanks for the help.


TCG

I'm working on a project that has a lot of different timezone options, and all I have from the users is their UTC offset.

After weeks of doing tweaks, I come to new issues every time I add something, one would think it would be a lot easier to just get the correct time and day :)

The latest issue is that when I try to rewrite a date to a better fomat, it disregards the GMT offset. Like this:

4/14/19, 12:00 PM GMT+2 (=$date) becomes ... 14-04-2019 10:00 when using this code:

$bp_date_to_format = date_create_from_format('Y-m-d\TH:i:sP', $date);
echo date_format($bp_date_to_format, 'd-m-Y H:i');

I figured it would just rewrite the format, keeping the exact time. It isn't.

We do have all these sorts of localization functions as well, but because there doesn't seem to be one single standard (each 3rd party API connection we have uses its own default datetime format so it seems).

        // Remove UTC Text
        $UTC_offset = str_replace('UTC', '', $timezone);

        // Get Offset in Minutes
        if (stripos($UTC_offset, ':') !== false) {
            // Calculate seconds from offset
            list($hours, $minutes) = explode(':', $offset);
            $seconds = $hours * 60 * 60 + $minutes * 60;
        } else {
            $seconds = $UTC_offset * 60 * 60;
        }

        // Get User timezone name from seconds
        $timezone = timezone_name_from_abbr('', $seconds, 1);
        if ($timezone === false) {
            $timezone = timezone_name_from_abbr('', $seconds, 0);
        }
        // Set new TZ
        return date_default_timezone_set($timezone);

 

Isn't there any "one way"solution that can be used? It's confusing to say the least.

 

Cheers.

Hello Everyone,

I am on windows server and In my ini file server time zone declared as below

[server_settings]
date.timezone = "Europe/London"

but my application installed on another timezone eg: 'America/Los_Angeles' time zone.

using date_default_timezone_get() i am always getting Europe/London timezone as it's declared in ini file. How to get local timezone(wherever application is installed) here?

Thanks Krish

Nonsense question, but still... Is there any method to detect gmail client timezone setting? Like mobile app and web gmail client? Not browser or IP or similar, but gmail. Thank you for your answers.

Hi Guys..

How can I change a date on the fly ?
Everything is UTC on my server.

How can I change a date to something else on the fly?

Ie:

$timezone = "cet";
$datetime = "2011-09-04 19:53:00";

echo $datetime($timezone);

So I can give it a datetime and have it echo the datetime as if it were in the other timezone?

Thanks
Graham