Jump to content

Archived

This topic is now archived and is closed to further replies.

BillyBoB

[Solved] comparing times

Recommended Posts

i have a timestamp in a db called timein

i want to have it show the how long its been since the last login.
i want it to take time out of db and compare it with the date() function of php and display the dtime between them.

Can u help me ? (there happy)

Share this post


Link to post
Share on other sites
I think that was your que to help him. Not say cool

Sorry billy, im a newb i cant help. Just thought thorpe's post was dumb

Share this post


Link to post
Share on other sites
Statements are not questions, its a pretty simple concept. You'll find a link in my signiture if you need clarification.

Share this post


Link to post
Share on other sites
Just subtract the times.

$time_inbetween = $current_time - $intime;

Where $current_time is the current timestamp and $intime is the timestamp in the database. $timeinbetween should be a timestamp (the number of seconds between the two other timestamps)

So use date() with $time_inbetween to get the number of hours/minutes/seconds/days/weeks or whatever you want.

Share this post


Link to post
Share on other sites
nope that wont work ... it will not work because what if the timein is jan. (01) and the current time is nov. (11) that would give me -10

Share this post


Link to post
Share on other sites
this should of worked sorry no luck.

[code]
<?php

$old_date=date("01-02-09");

$old_result=strtotime($old_date);

$date_now=date("d-m-y");

$date_now_result=strtotime($date_now);

$results=$date_now_result-$old_result;

$total_result=date("d-m-y",$results);

echo $total_result;

?>
[/code]

Share this post


Link to post
Share on other sites
[quote author=BillyBoB link=topic=104559.msg417180#msg417180 date=1155781902]
nope that wont work ... it will not work because what if the timein is jan. (01) and the current time is nov. (11) that would give me -10
[/quote]

It should work if all three variables in my example are timestamps.

Share this post


Link to post
Share on other sites
[quote]dude stop being an ass just anwser my question[/quote]

Read your post again. There is no question!

Share this post


Link to post
Share on other sites
[quote author=BillyBoB link=topic=104559.msg417135#msg417135 date=1155774890]
Can u help me ? (there happy)
[/quote]

whats that i can see one how bout u

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.