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 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
|
<?php
// requête
if (isset($_POST['valid_req']))
{
if((isset ($_POST['an']) ) AND ($_POST['an'] <> "")AND ($_POST['cdc'] <> ""))
{
try {
$tbordcom=$cbd->prepare('SELECT
(DATE_FORMAT(datedec,"%U")) AS NS,
YEAR(datedec) AS an,
cdc,
sum(aes200) As Total_M ,
sum(aes300) As Total_F ,
FROM `conteneur`
WHERE
cdc=:cdc &&
(DATE_FORMAT(datedec,"%U")) BETWEEN :nsdb AND :nsf &&
YEAR(datedec) BETWEEN :an AND :anf
');
$andb =trim(htmlspecialchars($_POST['an']));
$anf =trim(htmlspecialchars($_POST['anf']));
$cdc =trim(htmlspecialchars($_POST['cdc']));
$nsdb =trim(htmlspecialchars($_POST['nsdb']));
$nsf =trim(htmlspecialchars($_POST['nsf']));
$tbordcom->bindParam(':an', $andb , PDO::PARAM_INT);
$tbordcom->bindParam(':anf', $anf , PDO::PARAM_INT);
$tbordcom->bindParam(':nsdb', $nsdb , PDO::PARAM_INT);
$tbordcom->bindParam(':nsf', $nsf , PDO::PARAM_INT);
$tbordcom->bindParam(':cdc', $cdc , PDO::PARAM_STR);
$tbordcom->execute();
// On récupère en 1er toutes les données
$datacom = $tbordcom->fetchAll(PDO::FETCH_ASSOC);
// libèré la connexion du serveur
$tbordcom->closeCursor();
}
catch( Exception $e ){
echo 'Erreur d\'affichage : ', $e->getMessage();
}
/*----------------- fin affichage */
}
}
.........
<form method="post" action="tab.php?page=anal">
<p>
<label for="listCom">Commune:
<select name="com" id="listcom" title="Limiter votre recherche à une Commune précise">
<?php
$Commune = isset($_POST['com'])?$_POST['com']:'';
foreach ($com as $listcom)
{
if ($Commune == $listcom['com'])
{
echo '<option value="'.$listcom['com'].'" selected="selected">'.$listcom['cdc'].'-'.$listcom['com'].'</option>';
}
else
{
echo '<option value="'.$listcom['com'].'">'.$listcom['cdc'].'-'.$listcom['com'].'</option>';
}
}
?>
</select>
</label>
</p>
<p>
<input type="submit" name="valid_req" value="Exécuter" title="Lancer la requête" id="lancer_req"/>
</p>
</form>
...........
?> |
Partager