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();
?> |
Partager