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 39 40 41 42 43 44
| <?php
$connexion = mysql_connect("localhost","root","");
$base = mysql_select_db("GestionDePaie");
$varid= htmlspecialchars($_POST['c_cin'],ENT_QUOTES);
$sql = mysql_query('SELECT * FROM salaries WHERE CIN="'.$varid.'"');
?>
<table width="50%" border="1" ><!-- les valeurs des colones -->
<tr>
<th scope="col">N°CIN</th>
<th scope="col">Nom</th><!-- les valeurs de la boucle -->
<th scope="col">Prénom</th>
<th scope="col">N°IMT</th>
<th scope="col">Sit.familiale </th>
<th scope="col">Adresse </th>
<th scope="col">Code Postal </th>
<th scope="col">Ville </th>
<th scope="col">Telephone </th>
<th scope="col">Email </th>
<th scope="col">Emploi </th>
<th scope="col">Etat </th>
<th scope="col">Date d'Entré </th>
</tr>
<?php
while($result = mysql_fetch_array($sql))//le lancement de la boucle
{ ?>
<tr>
<th scope="row"> <?php echo $result ['CIN'] ?></th>
<td><?php echo $result ['Nom']?></td>
<td><?php echo $result ['Prenom']?></td>
<td><?php echo $result ['Imatr']?></td>
<td><?php echo $result ['Sit_familiale']?></td>
<td><?php echo $result ['Adresse']?></td>
<td><?php echo $result ['Code_Postal']?></td>
<td><?php echo $result ['Ville']?></td>
<td><?php echo $result ['Telephone']?></td>
<td><?php echo $result ['Email']?></td>
<td><?php echo $result ['Emploi']?></td>
<td><?php echo $result ['Etat']?></td>
<td><?php echo $result ['Date_Entre']?></td>
</tr>
<?php } ?> |
Partager