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
|
<?php
try
{
$bdd = new PDO('mysql:host=localhost;dbname=villes_de_france;charset=utf8', 'root', '');
array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
$req = $bdd->prepare('SELECT SUM(ville_population_2010) AS dept_population, departement_nom, departement_code FROM villes_france_free INNER JOIN departement WHERE villes_france_free.ville_departement = departement.departement_code AND departement_region = :region GROUP BY departement_code ORDER BY dept_population DESC');
$req->execute(array('region' => $_POST['region']));
echo '<ul><p>Région ' . $_POST['region'] . '</p><br>';
$i = 0;
while ($donnees = $req->fetch())
{
echo '<li>' . $donnees['departement_nom'] . ' (' . $donnees['departement_code'] . ') - ' . $donnees['dept_population'] . '</li>';
$i++;
}
echo '<br>La région ' . $_POST['region'] . ' est composée de ' . $i . ' départements</ul><hr>';
$req->closeCursor();
?> |
