Hallo,
hab im Netz eine Lösung gefunden, dass man für eine kleine Berechnung ca. 40 Zeilen Code schreiben ist echt der Wahnsinn :/
function makeDifferenz($first, $second)
{
if($first > $second)
$td['dif'][0] = $first - $second;
else
$td['dif'][0] = $second - $first;
$td['sec'][0] = $td['dif'][0] % 60; // 67 = 7
$td['min'][0] = (($td['dif'][0] - $td['sec'][0]) / 60) % 60;
$td['std'][0] = (((($td['dif'][0] - $td['sec'][0]) /60)- $td['min'][0]) / 60) % 24;
$td['day'][0] = floor( ((((($td['dif'][0] - $td['sec'][0]) /60)- $td['min'][0]) / 60) / 24) );
$td = makeString($td);
return $td;
}
function makeString($td)
{
if ($td['min'][0] == 1)
$td['min'][1] = 'Minute';
else
$td['min'][1] = 'Minuten';
if ($td['std'][0] == 1)
$td['std'][1] = 'Stunde';
else
$td['std'][1] = 'Stunden';
if ($td['day'][0] == 1)
$td['day'][1] = 'Tag';
else
$td['day'][1] = 'Tage';
return $td;
}
$secLast = time();
$secNow = mktime ( 10, 53, 0, 3, 6, 2015 );
$td = makeDifferenz($secLast, $secNow);
if ($td['day'][0] < 1) {
echo $td['std'][0] . ' ' . $td['std'][1] . ', ' . $td['min'][0] . ' ' . $td['min'][1];
}
else {
echo $td['day'][0] . ' ' . $td['day'][1] . ', ' . $td['std'][0] . ' ' . $td['std'][1] . ', ' . $td['min'][0] . ' ' . $td['min'][1];
}
?>
Ich dachte eher dass MySQL so etwas direkt kann. Es funktioniert und alles andere soll mir erstmal egal sein.