Blame view

pages/schools.php 1.7 KB
722c6952   Geoffrey PREUD'HOMME   schools: Nicer ex...
1
  <h2>Liste écoles participantes</h2>
56320b01   Jean Wasilewski   Added creds
2
  <?php
722c6952   Geoffrey PREUD'HOMME   schools: Nicer ex...
3
4
5
6
7
8
9
10
11
12
13
14
15
16
  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'");
de397a8d   Geoffrey PREUD'HOMME   Removed contact f...
17
      $requete = "SELECT DISTINCT `nom`, `circonscription`, `adresse`, `enseignant` FROM `school` ORDER BY nom ASC";
722c6952   Geoffrey PREUD'HOMME   schools: Nicer ex...
18
19
20
  
      $resultat = mysql_query($requete);
  
c5246861   Geoffrey PREUD'HOMME   Obviously catched...
21
22
23
24
      if (!$resultat) {
      	throw new Exception('Résultat vide.');
      }
  
722c6952   Geoffrey PREUD'HOMME   schools: Nicer ex...
25
      mysql_close($link);
56320b01   Jean Wasilewski   Added creds
26
  ?>
368cb3c0   Jean Wasilewski   Added school list
27
28
29
30
31
32
33
34
  
  <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>
c8a4fc85   Geoffrey PREUD'HOMME   Also where did th...
35
  					<th>Adresse</th>
722c6952   Geoffrey PREUD'HOMME   schools: Nicer ex...
36
37
  <?php /*
  					<th>Enseignant</th>
722c6952   Geoffrey PREUD'HOMME   schools: Nicer ex...
38
  */ ?>
368cb3c0   Jean Wasilewski   Added school list
39
40
41
42
43
  				</tr>
  			</thead>
  		</div >
  		<tbody>
  <?php
722c6952   Geoffrey PREUD'HOMME   schools: Nicer ex...
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
      
      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>';
722c6952   Geoffrey PREUD'HOMME   schools: Nicer ex...
60
61
          echo '</tr>';
      }
368cb3c0   Jean Wasilewski   Added school list
62
  ?>
722c6952   Geoffrey PREUD'HOMME   schools: Nicer ex...
63
  
368cb3c0   Jean Wasilewski   Added school list
64
65
66
  		</tbody>
  	</table>
  </center>
722c6952   Geoffrey PREUD'HOMME   schools: Nicer ex...
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
  <?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
  }
  ?>