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 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
|
<html>
<head>
<title>Carrabs's Hospital</title>
</head>
<body bgcolor="#01B0F0"><br/>
<center><h1><font color="white">Carrabs's Hospital</font></h1></center>
<form name="hopital" action="" method="POST"><hr />
<br/><br/>
<center><font size=+1 color="silver"> <b>Consultez ici les données du patient</b></font> </center><br/>
<center>
<form name="etat" action="" method="POST">
<table border="1">
<tr><td colspan="3"><center><b>Veuillez indiquer son nom et son prénom</b></center></td></tr>
<tr><td colspan="2">Son Nom</td>
<?php
$conn = mysql_connect('localhost', $_SERVER['DB_USER'], $_SERVER['DB_PASS']);
mysql_select_db("mschyns_".$_SERVER['DB_USER']);
$sql = "SELECT nom FROM patient";
$resul = mysql_query($sql);
$nbre_nom=mysql_num_rows($resul);
echo "<tr><td><select name=nom>";
echo "<option value=\"Vide\" selected=\"selected\">Choisir ici </option>";
for ($n=1;$n<=$nbre_nom;$n++) {
$row = mysql_fetch_assoc($resul);
echo "<option value=\"$n\">".$row["nom"]."</option>";
}
echo "</select>";
echo "</td>";
?>
<tr><td colspan="2">Son Prénom</td><td><input type="text" name="prenom" size="30" /></td></tr>
</table>
<input type="submit" value="Envoyer">
<input type="reset" value="Reset"><br/><br/>
<font color="silver" size=+2>Données demandées</font><br/>
<table border='5'>
<tr><th>Nom du client</th><th>Température</th><th>Tension</th><th>Poids</th><th>Date de visite</th></tr>
<?php
$nom=$_POST['nom'];
$prenom=$_POST['prenom'];
$conn = mysql_connect('localhost', $_SERVER['DB_USER'], $_SERVER['DB_PASS']);
if (!$conn) {
echo "Impossible de se connecter à la base de données : " . mysql_error();
exit;
}
if (!mysql_select_db("mschyns_".$_SERVER['DB_USER'])) {
echo "Impossible de sélectionner la base mydbname : " . mysql_error();
exit;
}
$sql = "SELECT nom, temperature, tension, poids, date FROM patient, details_visite WHERE nom='$nom' AND prenom='$prenom' AND idvisite=idpatient";
$result = mysql_query($sql);
if (!$result) {
echo "Impossible d'exécuter la requête ($sql) dans la base : " . mysql_error();
exit;
}
if (mysql_num_rows($result) == 0) {
echo "Aucune ligne trouvée.";
} else {
while ($row = mysql_fetch_assoc($result)) {
echo "<tr><td>".$row["nom"]."</td>";
echo "<td>".$row["temperature"]."</td>";
echo "<td>".$row["tension"]."</td>";
echo "<td>".$row["poids"]."</td>";
echo "<td>".$row["date"]."</td></tr>";
}
}
mysql_close($conn);
?>
</table>
</center>
<br />
</body>
</html> |
Partager