repositories / TD_BDD.git / blame
| Commit | Line | Data |
|---|---|---|
| 44ac5003 JB |
1 | <html> |
| 2 | <body> | |
| 3 | <?php | |
| 4 | if( $id = mysql_connect($_SERVER['dbHost'],$_SERVER['dbLogin'],$_SERVER['dbPass']) ) { | |
| 5 | if( $id_db = mysql_select_db($_SERVER['dbBd']) ) { | |
| 6 | echo 'Connexion a la base.<br><br>'; | |
| 7 | $requete = "SELECT NumCl, NomCl, CodePosteCl, VilleCl FROM CLIENTS"; | |
| 8 | if($result = mysql_query($requete)) { | |
| 9 | echo "<table border=1>\n"; | |
| 10 | echo "<tr><td>Code_CL</td><td>Nom</td><td>Rue</td><td>Ville</td></tr>\n"; | |
| 11 | while($ligne = mysql_fetch_row($result)) { | |
| 12 | $code = $ligne[0]; | |
| 13 | $nom = $ligne[1]; | |
| 14 | $rue = $ligne[2]; | |
| 15 | $ville = $ligne[3]; | |
| 16 | echo "<tr><td>$code</td><td>$nom</td><td>$rue</td><td>$ville</td></tr>\n"; | |
| 17 | } | |
| 18 | echo "</table>\n"; | |
| 19 | } else { | |
| 20 | echo 'Erreur de requete'; | |
| 21 | } | |
| 22 | } else { | |
| 23 | die('Echec de connexion a la base'); | |
| 24 | } | |
| 25 | mysql_close(); | |
| 26 | echo '<br>Deconnexion.'; | |
| 27 | } else { | |
| 28 | die('Echec de connexion au serveur de bases de donnees'); | |
| 29 | } | |
| 30 | ?> | |
| 31 | </body> | |
| 32 | </html> | |
| 33 |