skulle selv lige prøve den, og blev glædelig overrasket, den tager forbehold for skudår, det er en klar kandidat til mit functions lib
<?php
class myClass{
public $year;
public $month;
public $day;
public $hour;
public $min;
public $sec;
public function diff($start,$end = false) {
/*
* For this function, i have used the native functions of PHP. It calculates the difference between two timestamp.
*
* Author: Toine
*
* I provide more details and more function on my website
*/
// Checks $start and $end format (timestamp only for more simplicity and portability)
if(!$end) { $end = time(); }
if(!is_numeric($start) || !is_numeric($end)) { return false; }
// Convert $start and $end into EN format (ISO 8601)
$start = date('Y-m-d H:i:s',$start);
$end = date('Y-m-d H:i:s',$end);
$d_start = new DateTime($start);
$d_end = new DateTime($end);
$diff = $d_start->diff($d_end);
// return all data
$this->year = $diff->format('%y');
$this->month = $diff->format('%m');
$this->day = $diff->format('%d');
$this->hour = $diff->format('%h');
$this->min = $diff->format('%i');
$this->sec = $diff->format('%s');
return true;
}
}
$myClass = new myClass();
$start = time() - 31536060; // 1 år og 1 min, hvis det ikke var skudår :)
$myClass->Diff($start);
// Display result
echo '<br />Year: '.$myClass->year;
echo '<br />Month: '.$myClass->month;
echo '<br />Day: '.$myClass->day;
echo '<br />Hour: '.$myClass->hour;
echo '<br />Min: '.$myClass->min;
echo '<br />Sec: '.$myClass->sec;
/* det er jo skud år i år
Year: 0
Month: 11
Day: 28
Hour: 0
Min: 1
Sec: 0
*/
?>
så din udregning burde være noget med
// tiden nu - 5 min pr række * 60 sek
$time = (time() - ($stmt->num_rows * 5*60));
$myClass->Diff($time);
// Display result
echo '<br />Year: '.$myClass->year;
echo '<br />Month: '.$myClass->month;
echo '<br />Day: '.$myClass->day;
echo '<br />Hour: '.$myClass->hour;
echo '<br />Min: '.$myClass->min;
echo '<br />Sec: '.$myClass->sec;