无法在php中添加两个mySQL持续时间值

Question

The $res['FitnessActivityTime'] contains 2 entries, the first is 04:09:00 and the second is 01:04:00 . These are retrieved by an mySQL table.

foreach ($res as $row) {

    $distance += $row['FitnessDistance'];
    $time += strtotime($row['FitnessActivityTime']);
}
echo "Distance is " . $distance . " and time is " . date("H:i:s",$time) . "<br>";

My problem is that the result that returns is :

Distance is 5 and time is 11:13:00

While I need it to return

Distance is 5 and time is 05:13:00

To clarify what I need is hours second minutes of counting, not a time in the day(ex. 01:04:00 AM)

Answer 1

Guessing your array $row['FitnessActivityTime'] is like

$row['FitnessActivityTime'][] = '04:09:00';
$row['FitnessActivityTime'][] = '01:04:00';

Now explode your string

$parts = explode(':', $row['FitnessActivityTime']);
$seconds+= ($parts[0] * 60 * 60) + ($parts[1] * 60) + $parts[2];

And finally

echo  gmdate("H:i:s", $seconds);