I want to subtract one date to another using php and display result in the days - hours - min - sec format. How i do this using php . I tried this using time stamp but it does not give proper values. please give suggestion
For ex : from date 2012-04-27 19:30:56 to date 2012-04-27 19:37:56
i used this code
if(strtotime($history['datetimestamp']) > strtotime($lasttime)) {
                 $totalelapsed1 = (strtotime($history['datetimestamp'])-strtotime($lasttime)); 
                     if($totalelapsed1 > 60 ) {
                         $sec = $totalelapsed1%60;
                         $min = round($totalelapsed1/60 , 0);
                         $minute = $min + $minute;
                         $second = $sec + $second;
                        // echo $min. " min " .$sec." sec";
                     } else {
                         //echo "0 min " . $totalelapsed1." sec";
                         $minute = 0 + $minute;
                         $second = $totalelapsed1 + $second;
                    }
                } else {
                     $minute = 0 + $minute;
                     $second = 0 + $second;
                    // echo "0 min 0 sec";
                }
                From how to subtract two dates and times to get difference by VolkerK:
You have to use like this:-
<?php //$now = new DateTime(); // current date/time $now = new DateTime("2010-07-28 01:11:50"); $ref = new DateTime("2010-07-30 05:56:40"); $diff = $now->diff($ref); printf('%d days, %d hours, %d minutes', $diff->d, $diff->h, $diff->i); prints 2 days, 4 hours, 44 minutessee http://docs.php.net/datetime.diff
edit: But you could also shift the problem more to the database side, e.g. by storing the expiration date/time in the table and then do a query like ...
WHERE key='7gedufgweufg' AND expires<Now()Many rdbms have reasonable/good support for date/time arithmetic.
Link Url:- how to subtract two dates and times to get difference
http://www.webpronews.com/calculating-the-difference-between-two-dates-using-php-2005-11
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With