<h2>Liste écoles participantes</h2>
<?php
require_once ("creds.php");

try {
    
    $link = @mysql_connect(__MYSQL_HOSTNAME__, __MYSQL_USERNAME__, __MYSQL_PASSWORD__);

    if (!$link) {
    	throw new Exception('Impossible de se connecter : ' . mysql_error());
    }
    
    if (!mysql_select_db('crep', $link)) {
        throw new Exception('Selection de la base de donnees impossible');
    }
    mysql_query("SET NAMES 'utf8'");
    $requete = "SELECT DISTINCT `nom`, `circonscription`, `adresse`, `enseignant` FROM `school` ORDER BY nom ASC";

    $resultat = mysql_query($requete);

    if (!$resultat) {
    	throw new Exception('Résultat vide.');
    }

    mysql_close($link);
?>

<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>Adresse</th>
					<th>Enseignant</th>
				</tr>
			</thead>
		</div >
		<tbody>
<?php
    
    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 '</tr>';
    }
?>

		</tbody>
	</table>
</center>
<?php
}
catch(Exception $e) {
?>
<div class="alert alert-danger" role="alert">
Impossible d'afficher la liste des écoles participantes.<br/>
Merci de rééssayer ultérieurement.
</div>
<!--
<?php
echo $e;
?>
-->
<?php
}
?>
