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 45 46 47 48 49 50 51 52 53 54 55
|
<?php //Connection avec la BDD.
mysql_connect("localhost", "root", "");
mysql_select_db("cisafri_ciscosante");
$reponse = mysql_query("SELECT * FROM gestion_sante_brm ORDER BY id");
?>
<table width="900">
<tr align="center">
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">Mois de soins</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">Date de soins</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">Nature des soins</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">Codification</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">IPM</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">N° Identifiant</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">Nom patient</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">Prénom</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">Date de saisie</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">Montant</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">Montant par ACTE</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">IMAT SONAM
</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">C</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">K</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">KR</th>
<th colspan="5" style="border-radius: 5px; background-color: #079839; height: 10px;">V</th>
</tr>
<?php //On affiche les lignes du tableau une à une à l'aide d'une boucle
while($donnees = mysql_fetch_array($reponse))
{
?>
<tr bgcolor="#CCCCCC" align="center">
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['mois_de_soins'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['date_de_soins'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['nature_des_soins'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['codification'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['ipm'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['numero_identifiant'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['nom_patient'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['prenom'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['date_de_saisie'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['montant'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['montant_par_acte'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['imat_sonam'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['c'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['k'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['kr'];?></td>
<td colspan="5" style="border-radius: 5px" scope="col"><?php echo $donnees['v'];?></td>
</tr>
<?php
} //fin de la boucle, le tableau contient toute la BDD
mysql_close(); //deconnection de mysql
?>
</table> |
Partager