BillyBoB Posted August 17, 2006 Share Posted August 17, 2006 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) Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/ Share on other sites More sharing options...
trq Posted August 17, 2006 Share Posted August 17, 2006 Cool. Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/#findComment-75974 Share on other sites More sharing options...
Nothadoth Posted August 17, 2006 Share Posted August 17, 2006 I think that was your que to help him. Not say coolSorry billy, im a newb i cant help. Just thought thorpe's post was dumb Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/#findComment-75979 Share on other sites More sharing options...
trq Posted August 17, 2006 Share Posted August 17, 2006 Statements are not questions, its a pretty simple concept. You'll find a link in my signiture if you need clarification. Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/#findComment-75981 Share on other sites More sharing options...
BillyBoB Posted August 17, 2006 Author Share Posted August 17, 2006 dude stop being an ass just anwser my question Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/#findComment-75991 Share on other sites More sharing options...
Jeremysr Posted August 17, 2006 Share Posted August 17, 2006 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. Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/#findComment-75995 Share on other sites More sharing options...
BillyBoB Posted August 17, 2006 Author Share Posted August 17, 2006 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 Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/#findComment-76011 Share on other sites More sharing options...
redarrow Posted August 17, 2006 Share Posted August 17, 2006 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] Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/#findComment-76013 Share on other sites More sharing options...
Jeremysr Posted August 17, 2006 Share Posted August 17, 2006 [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. Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/#findComment-76015 Share on other sites More sharing options...
trq Posted August 17, 2006 Share Posted August 17, 2006 [quote]dude stop being an ass just anwser my question[/quote]Read your post again. There is no question! Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/#findComment-76026 Share on other sites More sharing options...
BillyBoB Posted August 17, 2006 Author Share Posted August 17, 2006 [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 Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/#findComment-76030 Share on other sites More sharing options...
trq Posted August 17, 2006 Share Posted August 17, 2006 Oh... well, [b]no[/b] then. Link to comment https://forums.phpfreaks.com/topic/17790-solved-comparing-times/#findComment-76033 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.