PHP - Time Differences

What are the differences and implications of UTC time and Zulu time?
  

<?php
function getArr(string $time):array
{
    $dateTime = new \DateTime($time);
    return [
        'time'=>$time,
        'timestamp'=> $dateTime->getTimestamp(),
        'dateTime' => $dateTime
    ];
}
$arr = getArr('2020-08-05');  
$arr_z = getArr('2020-08-05T00:00:00Z');  

print_r($arr);
print_r($arr_z);

echo('equal timestamps: '.($arr['timestamp'] === $arr['timestamp']?'true':'false'));

 

Array
(
    [time] => 2020-08-05
    [timestamp] => 1596585600
    [dateTime] => DateTime Object
        (
            [date] => 2020-08-05 00:00:00.000000
            [timezone_type] => 3
            [timezone] => UTC
        )

)
Array
(
    [time] => 2020-08-05T00:00:00Z
    [timestamp] => 1596585600
    [dateTime] => DateTime Object
        (
            [date] => 2020-08-05 00:00:00.000000
            [timezone_type] => 2
            [timezone] => Z
        )

)
equal timestamps: true

 

With a prior version of Php, this code was acceptable.

$query = sqlsrv_query($conn, $sql);if ($query === false){  exit("<pre>".print_r(sqlsrv_errors(), true));}while ($row = sqlsrv_fetch_array($query)){  	$sumUsageKWH += $row[totalUsage];}sqlsrv_free_stmt($query);?> 

Now, with php 5.6.3, I have to add  a couple of things. 

$query = sqlsrv_query($conn, $sql);if ($query === false){  exit("<pre>".print_r(sqlsrv_errors(), true));}while ($row = sqlsrv_fetch_array($query)){  	$sumUsageKWH += $row['totalUsage'];}sqlsrv_free_stmt($query);?> 

due to an error prompt.  Once I make the corrections, I have a new errors all over the place.  Is there a difference in defining a variable with 5.6.3? 
Edited by Butterbean, 10 January 2015 - 01:49 PM.

Hi All,

I created a website which runs perfectly on one server but now I transferred the website to another server I get all kinds of errors like,
Undefined variables and so on. How is this possible. I thought it was all in the code.

Marco

Hi,

I have 2 db fields with timestamp datatype (ClockingInDate and ClockingOutDate) and i am trying to get the difference between them then update the new db called duration with float datatype field.

PHP:

if (isset($_POST["clockout"])){
		
		$result3=mysqli_query($con, "select * from attendance_records where OracleID='$session_id'")or die('Error In Session');
		$row3=mysqli_fetch_array($result3);
		
		$end_date =  $row3['ClockingOutDate'];
		$startdate = $row3['ClockingInDate'];
		$diff = strtotime($end_date) - strtotime($startdate);
		$fullDays    = floor($diff/(60*60*24));
		$fullHours   = floor(($diff-($fullDays*60*60*24))/(60*60));   
		$fullMinutes = floor(($diff-($fullDays*60*60*24)-($fullHours*60*60))/60);  

		$duration = $fullMinutes;
		$query3=mysqli_query($con, "update attendance_records set Duration = '$duration' where OracleID='$session_id' and isdone='$isdone'")or die('Error In Session');
		header('location:index.php');
		
	}

 

* come to think of that again, i always get zero, is it because it never reaches days in my program! I am using this for attendance system so only hours and minutes are used. Please help.

Edited March 13, 2020 by ramiwahdan
thoughts

After being forced to have the server upgraded I am having problems with my 'reset password' pages.

What I wondered is, has there been any changes to PHP or MySQL between these versions ?

The PHP version was 5.2.9 and is now 5.2.14
The MySQL version was Client API version 5.0.45 and is now Client API version 5.0.90

Some one clicks a link like this.

www.site.com/resetpw.php?pwr=a1b2c3d4e5f6

the code would be a 32 char hash that is checked against the database, but my code now (which was never changed before or after the server change) seems to find the database line and update it but show the message that it was invalid ?  instead of showing the the message, your password will be sent to you after changing the DB

does anyone have any ideas ?

Code: [Select]
<?php
  include('includes/connection.php');
  include('includes/functions.php');
  date_default_timezone_set('Europe/London');

  if(isset($_POST['reset']) && trim($_POST['reset']) == 'Reset') {

    $email    = mysql_real_escape_string($_POST['email']);

    $checkVerify = mysql_query("SELECT account_id FROM customers WHERE email='$email' AND verified='No' LIMIT 1");
    $checkBanned = mysql_query("SELECT account_id FROM customers WHERE email='$email' AND suspended='Yes' LIMIT 1");

    if(!$email) {
      $thisError = 'Please enter your e-mail address.';
    } else if(!$password) {
      $thisError = 'Please enter your password.';
    } else if(mysql_num_rows($checkVerify)) {
      $thisError = 'Your account has not been approved by an Admin.';
    } else if(mysql_num_rows($checkBanned)) {
      $thisError = 'Your account has been suspended by an Admin.';
    } else {
      $password = md5($password);

      $checkAccount = mysql_query("SELECT account_id FROM customers WHERE email='$email' AND password='$password' LIMIT 1");
      if(mysql_num_rows($checkAccount)) {
        $_SESSION['FM_user'] = $email;
        header('Location: members.php'); exit;
      } else {
        $thisError = 'Your e-mail address and/or password is incorrect.';
      }
    }
  }

  include('includes/header.php'); 
?>
<body>

  <div class="headerBar">
<?php include('includes/navigation.php');?>
  </div>

  <?php headerText(); ?>

  <div class="content">
    <div class="widthLimiter contentStyle">
      <div class="formWrapper">
        <?php if(isset($thisError)) { echo '<div class="errorDiv">',$thisError,'</div>'; } ?>
        <?php if(isset($thisSuccess)) { echo '<div class="successDiv">',$thisSuccess,'</div>'; } ?>
        <span class="subHeader">Initiate Password Reset</span>
<?php
// include("sendmail2010.php");
$securitycode = ($_GET['pwr']);
//echo("53:security:".$securitycode.":<br>");
if ($securitycode != "") { $sql = "SELECT * FROM `customers` WHERE `changeofpasswordcode` = '".mysql_real_escape_string($securitycode)."' LIMIT 1";
//echo("54:sql:".$sql.":<br>");
$res = mysql_query($sql) or die(mysql_error());
//echo("57:<br>");
if (mysql_num_rows($res) != 0) {
//echo("59:sql:".$sql.":<br>");
$customerName = mysql_result($res, 0 ,'fullname');
$email = mysql_result($res, 0 ,'email');
$yourpasswordtologin = CreateNewPassword();
$format = 'Y-m-d H:i:s'; $date = date( $format );
$sql = "UPDATE `customers` SET `password` = '" . md5($yourpasswordtologin) . "', `password2` = '" . mysql_real_escape_string($yourpasswordtologin) . "', `changeofpasswordcode` = '', `newpasswordrequestedon` = '" . $date . "' WHERE `changeofpasswordcode` = '" . mysql_real_escape_string($securitycode) . "' LIMIT 1";
//echo("65:sql:".$sql.":<br>");
$res = mysql_query($sql) or die(mysql_error());
$_SESSION['customerName'] = $customerName;
$_SESSION['customerEmail'] = $email;
$_SESSION['generatePass'] = $yourpasswordtologin;
//echo("send email");
$sendemailnow = createEmailSend('newPassword', 'Your new password', 'customer');
//echo("email sent ".$sendemailnow);
?><div style="margin: 30px;">Thank you for completing your password reset process.<br><br>An email with a randomly generated password has been sent to your email address, please check your email account for this email as you will need this password to access your <?=$_SESSION['siteName'];?> account.<br><br><strong><em>Please check your 'spam folder' in case our emails are showing up there.</em></strong><br><br>You may now <a href="<?=$_SESSION['webAddress'];?>">sign in</a> to your account.</div><?php
//echo("72:end of IF send email<br>");
} else {
//echo("74 bad link<br>");
?><div style="margin: 20px;">Sorry the link you clicked is and old password reset link or is not valid, please delete the email.<br><br>If you were trying to reset your password, please click the<br>'Member Login' link on our site and then click the 'Reset Password' link.</div><?php
//echo("end of IF bad<br>");
}
//echo("78:end of first IF<br>");
} ?>
      </div>
    </div>
  </div>
<?php include('includes/footer.php');?>
</body>
</html>