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
| <div id="tbl_heures1">
<table id="tables">
<tr><td id=col120px>Nom</td>
<td id=col120px>Prénom</td>
<td id=col120px>Date</td>
<td id=col120px>Nombre d'heures</td></tr>
<?php
$id_connexion=mysql_connect("localhost","utilisateur","pass");
mysql_select_db("gestion",$id_connexion);
$requete = " SELECT empl_nom, empl_prenom, heu_date, heu_heures
FROM heures_tbl
INNER JOIN employe_tbl ON heures_tbl.heu_empl_id = employe_tbl.empl_id
WHERE empl_id = 2";
$resultat=mysql_query($requete,$id_connexion);
while ($tableau=mysql_fetch_array($resultat,MYSQL_ASSOC))
{
echo '<tr><td>',$tableau['empl_nom'],'</td><td>',$tableau['empl_prenom'],'</td>
<td>',$tableau['heu_date'],'</td><td>',$tableau['heu_heures'],'</td></tr>';
}
?>
</table>
</div> |
Partager