PHP - Timestamps Differences

As you may of guessed, it's a nightmare.
If my birthday is on 10th June GMT, it would still be my birthday on the 11th June in Australian time. Though.. the 11th June, is not my birthday. It's not hard to understand this bit as Australia is like.. many hours ahead. Though when it comes to PHP... if I used some Timezone plug-in then this would bring up the same result as it does now. Though when that persons age is displayed... if my birthday is 10th June at 1AM, in America, it would be the 9th June. There for, they won't see my age change to 18 until it is 10th June their time.

To prevent this, is when calculating the persons age, you would be adding their timezone offset onto their birthday timestamp. So regardless on what day it is around the world, if they are celebrating their birthday... then it's their birthday all around the world even though it's different times.

To do this, i would need timezone offsets. I would have a field in the database I assume. I would convert their DOB to timestamp. I would add their offset onto that timestamp or take it away and display whatever result that gives to every user. This would display their age as whatever to every user.

The next problem is... strtotime works in MM/DD/YYYY, so how do I make it work with DD/MM/YYYY ?

I'm actually not making much sense, how would you work with Timestamps and Ages? Also for my next question question, if I had someones DOB, how do I bring up their next birthday out of it for when I am displaying "Bobs birthday is on the..."

Now for final, apparently on 19th Jan 2038 the UNIX Timestamp will cease to work due to a 32-bit overflow. How can this be true when converting a date in the year 2500 still brings a timestamp?

Ok sorry if this is a proper newbie question but say i have a timestamp saved in a database in a table called "news" and the field is called "date" how do i get the month and year only from example if the time stamp is 2011-03-29 13:57:05.

And i want to list all news articles from the month 03 and the year 2011 how would i go about doing this?


Thank you for reading

Why doesn't this code work...

echo '<p>time() = ' . time() . ' seconds</p>';
echo '<p>$lastActivity = ' . $lastActivity . '</p>';
echo '<p>Seconds Active: ' . time() - $lastActivity . ' seconds</p>';

...where $lastActivity comes from my database.


When I run my script I see...
Quote

time() = 1331187131 seconds

$lastActivity = 1331186745
-1331186745 seconds


The last line is dropping the label and there is now Date Math?!


Debbie

Hi, I just want to see what way you guys think is best.
On this little community I'm building I have decided to implement a function to see who were active within the last 15 minutes.
I made a table (just user and timestamp) to register the last activity of any logged on user.
Then I have a variable to take off 15 minutes from that but I can't get them to compare.
Googling the issue I found people are solving this in very different ways.
I wanted to see what phpfreaks recommend as the next step.
Here is some code (that doesn't work properly - no results found as I compare to different timestamps):

Code: [Select]
include_once'header.php';
$now=time();
$now=(date("Y-m-d H:i:s"));
//$mins = mktime(0,$now-15,0, date("Y"), date("m"),date("d"));
$mins = time();
$mins15 = $mins-(60*15);
$mins15 = (date("Y-m-d H:i:s", $mins15));
$online="SELECT * FROM user_online" WHERE last_activity > mins15;
$result = mysql_query($online);
if (!$result) die ("Database access failed: " . mysql_error());
$rows = mysql_num_rows($result);

echo <<< _END
<div id='statusbar'>
<h4>Online now: $rows</h4>

Getting the difference in seconds between two timestamps is easy.  Taking the seconds and doing a breakdown of time frames is also easy.
Code: [Select]
<?php

echo '<p>There are a total of ' . round($seconds) . ' seconds between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round($seconds / 60) . ' minutes between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round(($seconds / 60) / 1440) . ' days between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round((($seconds / 60) / 1440) / 7) . ' weeks between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round((((($seconds / 60) / 1440) / 7) / 30)) . ' months between Timestamp 1 and Timestamp 2.</p>';
echo '<p>The total breakdown of time from Timestamp 1 to Timestamp 2 is .</p>';
?>
What I am trying to figure out, is get a collective amount as well....
X years X months X weeks X days X minutes and X seconds.
Does anyone have any good algorithm for handling that, or have any feedback on where to start to handle this type of math.

Okay guys.

My brain has completely froze and I can't figure out how to do this.

I have one date, that is somewhat static it doesn't change regularly but it changes. Anyway let's say this timestamp is:

2011-07-12 10:30:00

and the current timestamp is

2011-07-13 10:30:00

That's exactly a day difference, which will produce 86400 seconds.

How would I write this in PHP?

I have an array that looks like this:

 

array(5642) {

[0]=> string(19) "2021-02-10 09:04:48"

[1]=> string(19) "2021-02-10 09:04:54"

[2]=> string(19) "2021-02-10 09:05:00"

[3]=> string(19) "2021-02-10 09:05:06"

[4]=> string(19) "2021-02-10 09:05:12"

[5]=> string(19) "2021-02-10 09:05:18"

[6]=> string(19) "2021-02-10 09:06:18"

[7]=> string(19) "2021-02-10 09:06:24"

}

 

I need to group the instances any time there is more than a 6 second gap between elements. So 0 =>5 would be one array and 6 and 7 would be a new array.

 

Ive been able to produce the following but its not ideal

 

array(5642) {

[0]=> string(19) "2021-02-10 09:04:48"

[1]=> string(19) "2021-02-10 09:04:54"

[2]=> string(19) "2021-02-10 09:05:00"

[3]=> string(19) "2021-02-10 09:05:06"

[4]=> string(19) "2021-02-10 09:05:12"

[5]=> string(19) "2021-02-10 09:05:18"

[6]=> string(19) "end"

[7]=> string(19) "2021-02-10 09:06:18"

[8]=> string(19) "2021-02-10 09:06:24" }

 

$burner_time = array();

foreach($Burner_Control_Alm as $new_burner){ $burner_time[] = strtotime($new_burner); }

$repl = 'end'; for ($i=1; $i<count($burner_time); $i++) { $value_second = $burner_time[$i]; $value_first = $burner_time[$i-1] === $repl ? $burner_time[$i-2] : $burner_time[$i-1]; if ($value_second > $value_first + 6) {

array_splice($burner_time, $i++, 0, $repl);

}

print_r($burner_time);

}

I have some data where each has a timestamp when is was measured, and not all data points will be necessarily measured at the same time.

 

                Time |    Value1 |    Value2 |    Value3 |    Value4
 2020-12-15 00:05:07 |           |      27.6 |           |          
 2020-12-15 00:30:27 |           |           |        26 |          
 2020-12-15 01:20:10 |      53.9 |      25.2 |           |          
 2020-12-15 02:09:44 |           |      26.4 |           |      60.2
 2020-12-15 02:43:19 |        33 |      49.2 |           |          
 2020-12-15 03:04:44 |      30.8 |           |           |        42
 2020-12-15 03:21:46 |           |        54 |           |          
 2020-12-15 03:47:19 |      52.8 |           |      53.3 |          
 2020-12-15 04:26:20 |           |           |      27.3 |          
 2020-12-15 04:45:10 |      37.4 |           |           |          
 2020-12-15 05:24:25 |           |        42 |           |          
 2020-12-15 05:34:49 |      36.3 |           |      41.6 |          
 2020-12-15 05:36:04 |      24.2 |           |           |          
 2020-12-15 06:06:47 |      49.5 |           |           |          
 2020-12-15 07:00:07 |           |           |           |        49
 2020-12-15 07:59:17 |           |      27.6 |           |          
 2020-12-15 08:14:45 |           |           |      48.1 |      51.8
 2020-12-15 08:26:36 |           |           |      53.3 |          
 2020-12-15 08:54:23 |      50.6 |           |           |          
 2020-12-15 09:46:53 |           |           |      58.5 |      43.4
 2020-12-15 10:25:03 |           |           |           |      36.4

 

I am trying to obtain the total value (i.e. value1 + value2 + value3 + value4) and since there is no common time interval, come up with an arbitrary one such as one hour.  It doesn't need to be exact and one option is to linearize each sample between each of their individual timestamps, but ideally I can do a little better.  It has been many, many years, and I recall that least squares regression used to be used for things like this, but I think I would need to the process the entire series for each which I expect would require many polynomials.  I've never used R and it might be an option if necessary.  Not sure if there is anything baked into PHP which would be great.    Any ideas?  Thanks

                Time |Total Value
 2020-12-15 00:00:00 |      27.3
 2020-12-15 01:00:00 |      48.4
 2020-12-15 02:00:00 |        21
 2020-12-15 03:00:00 |        22
 2020-12-15 04:00:00 |        49
 2020-12-15 05:00:00 |        38
 2020-12-15 06:00:00 |        49
 2020-12-15 07:00:00 |        29
 2020-12-15 08:00:00 |        49
 2020-12-15 09:00:00 |        46
 2020-12-15 10:00:00 |        36

 

I am making a php/ajax chat, when a post is sent to the chat, a timestamp using mktime() is stored in the database to show when that post was sent. My concern is that I am from England and my timestamp is GMT +0. Will people from different locations around the world see the wrong times that other users post into the chat? If so what do I need to do to make this work ideally?

Thanks

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.

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>

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

I don't know if this is the correct type of question to ask here - I built a sandbox about 3 months ago with the latest XAMPP. I know that it came with PHP 5.x [5.2 I think]. I am not at home right now to check it. I just found out that the host server is running 4.4.9. I have no control over the host, or host selection. I am going to attempt to get a database online using basic [I hope] PHP scripts to query the otherwise static database. Are there major differences in the versions that I need to watch out for? I realize that I will now have to get 4.4.9 installed on my sandbox. I plan on using Dreamweaver CS5 to get my pages built. The main site is built and managed by another person using Expression Web 2. I am also unaware if the master.dwt built in Expression can be somehow brought into my PHP for site consistency. I am open to all comments and suggestions.

Can someone explain the difference between the following?

function a(array $var) { }

function a($var = array()) { }

function a(Array $var) { }

I have seen these recently in a script I am modifying, but not 100% sure as to what each one does. Well I know what the middle one does, but am a little confused on the 1st and 3rd one.

Thanks!
Dennis

I have Win 7 home premium, Apache 2.2 (installed using the .msi) and PHP 5.2.14 (downloaded as "php-5.2.14-Win32-VC6-x86.zip", installed manually, it works) on both machines. The other is 32-bit and the other is 64-bit, both Windows 7 Home Premium.

When I run the exactly same script on one machine, it does what it is supposed to (32-bit), but on the 64-bit it does not.

Basically this appears in two situations (so far): I have a script that reads a (xml) file into a simplexml object, and if this is not successful, it prints an error message. On the 32-bit machine I can import (read) another xml file at once once the first one is processed (into a sqlite database), but on the 64-bit machine it gives me an error originating from the fact that the script did not manage to create the simplexml object.

The other situation is when I want to open a specific PDF - file in a browser window (Firefox, the newest one, on the 32-bit machine, IE something newish on the 64-bit). The file exists, the path to the folder is in the Path environment variable, I can open it normally etc on the 64-bit machine, but when I click on a link that is supposed to open the file in a browser window I only get an error message saying that the file does not start with "%PDF....

Needless to say, the precisely same script works just fine on the 32 bit machine.

$path_to_image="D:\\path_to_folder\\";

$file_name=$_GET['file_name'];

header("Content-disposition: inline; filename=".$path_to_image.$file_name);
header("Content-type: application/pdf");
readfile($path_to_image.$file_name);

The above code is from the part that receives the file name from a form (other file).

Anyone noticed anything like this? Any suggestions? Have been trying to figure this out for days, now...

Oh, forgot: In both cases the thing is accessed as/from "localhost".