1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
$query_ptage= "Select ptage.badge, ptage.d_ptage, ptage.h_ptage, pers_view.nom, pers_view.prenom from ptage, pers_view where ptage.d_ptage='$date_jour' and ptage.badge=pers_view.badge_1 order by pers_view.nom, ptage.h_ptage";
$result_ptage= maxdb_query($link,$query_ptage) or die("La requête a échoué : ".maxdb_error());
while ($ptage=maxdb_fetch_array($result_ptage)){
$date_unix=mktime(0,0,0,substr($ptage[d_ptage],5,2),substr($ptage[d_ptage],8,2),substr($ptage[d_ptage],0,4));
$date_jour=date('d/m/Y',$date_unix);
echo "<tr>";
echo "<td width=150>".$ptage[0].' - '.$ptage[5].' '.$ptage[3].' '.$ptage[4]."</td>";
echo "<td>".$ptage[1]."</td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td>".$ptage[2]."</td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "<td> </td>";
echo "</tr>";
} |
Partager