PHP - Relative Timestamps

hi, there.

I have a timestamp in my mysql database called timestamp and it'll record the current timestamp. however it also records the time etc how do i use php to take apart these for example if i wanted to echo the date and time in a different order or if i only wanted to echo the date not the time.

how is this possible?

Thanks for reading.

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

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 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 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);

}

Directory structu

/home/~test/public_html/soap/
    .../xml/
    .../bin/
    .../products/browser/

In file /home/~test/public_html/soap/bin/products/browser/test.php, I include another file and call it's function:
Code: [Select]
require("../../xml/processXML.php");

$xmlData = generateXML(....);

In the /home/~test/public_html/soap/xml/processXML.php, I have the following code:
Code: [Select]
function generateXML()
{
     exec("../bin/code.cur");
}

The problem is the exec("../bin/code.cur") fails of the relative path issue.  I did a getcwd() before the exec() and it returned /home/~test/public_html/soap/bin/products/browser.  I have tried using dirname() and no help.  I hope this is clear enought to understand where I am coming from.

Thank you.
AM

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=345942.0

I am trying to load an xml file but I can't seem to find the location to load it.
Here is the location of the xml file:
C:\inetpub\wwwroot\php\webphp.xml

Here is the location of the file trying to load the xml:
C:\inetpub\wwwroot\php\gui\guiindex.php

What location would I put in he
$xml = new SimpleXMLElement("XMLFILELOCATION", NULL, true);

Any thoughts on this function? Basically what it does is take the current users location ($location) and a relative path ($link) and convert it to a valid URL. I do know that this does work on my example, but does anyone have any suggestions on this?

Code: [Select]
<?php
$location = "http://mysite.com/pages/images/docs/myfile.html";
$link = "../../games/game.html";

function resolve_url($current, $link){
$ui = (object)parse_url($current);
$domain = $ui->scheme."://".$ui->host;
$levelsA = preg_split("/\.\.\//", $link);
$levels = 0;
foreach($levelsA as $l){
if(empty($l)) $levels++;
}
$currentA = preg_split("/\//", $current);
$length = count($currentA);
array_splice($currentA, -$levels - 1);
$currentA[] = preg_replace("/\.\.\//", "", $link);
return implode("/", $currentA);
}

echo resolve_url($location, $link);
?>
Thanks!

Hi,

I'm sorry if this has already been posted, a search of the forum didn't turn anything up so i'll ask away.

I'm trying to fetch urls from a document on my server and convert them into absolute urls.  I can extract them but some of my links use ../ or ./.  I think i've solved the ./ one but I can't find anything on getting the url when ../ is used.

As an example some urls use ../index.php when in a directory so http://www.example.com/dir/test.php, so a url of ../index.php from here would land the user on http://www.example.com/index.php.  At the moment it's landing on http://www.example.com/../index.php.

Any ideas?  Help would be appreciated 

Hope this goes here.

I run php5 apache 2.2 with mysql4 on my local machine

I prefer relative addresses.

Can someone help with the correct syntax to call... say.. the Home page (index.php)  in the root directory with something like <a href="../"  (../ takes me back too far) when called internally

At the moment I have to stipulate eg.  <a href=index.php> etc

Cheers
Brian

I found one post that related to this topic but I want to make sure I understand. If I have a site with the structu

/root/
____pageone.php
____common/
___________base.php
___________header.php
____inc/
______constants.inc.php
____admin/
_________login.php

and base.php includes:
<?php
// Include site constants
include_once "../inc/constants.inc.php";
?>
and login.php includes:
<?php
include_once "../common/base.php";
$pageTitle = "Log in";
include_once "../common/header.php";
?>
and pageone.php includes:
Code: [Select]
<?php
include_once "common/base.php";
$pageTitle = "Page One";
include_once "common/header.php";
?>the login page loads normally, but pageone.php is broken; I get error messages like
Quote

Warning: include_once(../inc/constants.inc.php) [function.include-once]: failed to open stream: No such file or directory in /Applications/XAMPP/xamppfiles/htdocs/rootdirectory/common/base.php on line 10

.

From what I understand, PHP doesn't want to include the same files from different relative paths; you either need to use absolute paths or change the directory structure so that the included files are accessed through the exact same relative path. Is this correct? I find that if I move pageone.php to the admin folder and make the relative path the same, it does work.

I have to say, I'm leery of using absolute paths; and if I'm understanding this correctly, you're really constrained on how you set up your directory structure. Comments?