school.php
1.19 KB
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
<?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>
</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;
}
$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>