<?php require_once("creds.php"); ?> <h2>Liste écoles participantes</h2> <center> <table class="table table-striped table-responsive table-bordered"> <div class="panel_heading"> <thead> <tr> <th>Nom de l'école</th> <th>Circonscription</th> <th>Contact</th> <th>Enseignant</th> <th>Contact</th> </tr> </thead> </div > <tbody> <?php $link = mysql_connect(__MYSQL_HOSTNAME__, __MYSQL_USERNAME__, __MYSQL_PASSWORD__) or die("Impossible de se connecter : " . mysql_error()); if(!mysql_select_db('crep', $link)) { echo 'Selection de la base de donnees impossible'; exit; } mysql_query("SET NAMES 'utf8'"); $requete = "SELECT DISTINCT `nom`, `circonscription`, `adresse`, `enseignant`, `contact` FROM `school` ORDER BY nom ASC"; $resultat = mysql_query($requete); while ($row = mysql_fetch_assoc($resultat)) { echo '<tr>'; echo '<td>'; echo '<p>'.$row['nom'].'</p>'; echo '</td>'; echo '<td>'; echo '<p>'.$row['circonscription'].'</p>'; echo '</td>'; echo '<td>'; echo '<p>'.$row['adresse'].'</p>'; echo '</td>'; echo '<td>'; echo '<p>'.$row['enseignant'].'</p>'; echo '</td>'; // echo '<td>'; // echo '<p>'.$row['contact'].'</p>'; // echo '</td>'; echo '</tr>'; } mysql_close($link); ?> </tbody> </table> </center>