1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| <?php
function sum_time($time)
{
static $sum_time = 0;
list($hour, $minute, $second) = explode(':', $time);
printf('<br />%d heures<br />%d minutes<br />%d secondes<br />', $hour, $minute, $second);
$sum_time += ($second + $minute*60 + $hour*3600);
$sum_time_hour = floor($sum_time/3600);
$sum_time_minute = floor(($sum_time - $sum_time_hour*3600)/60);
$sum_time_second = ($sum_time - $sum_time_hour*3600 - $sum_time_minute*60);
return sprintf('%d:%d:%d', $sum_time_hour, $sum_time_minute, $sum_time_second);
}
$sql = 'SELECT temps_jour FROM presence WHERE id_sem = \'1\' AND id_stagiaire = \'2\'';
echo($sql);
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result))
{
echo('<br />',$row['temps_jour'],' TIME<br /><br />');
$total = sum_time($row['temps_jour']);
}
echo('<br />',$total,' TOTAL TIME<br /><br />');
// Pour récuperer les nombres d'heures, minutes, secondes :
// list($total_hours, $total_minutes, $total_seconds) = explode(':', $total);
// printf('<br />%d heures<br />%d minutes<br />%d secondes<br />', $total_$hours, $total_$minutes, $total_seconds);
?> |
Partager