1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| <form>
<select name="choi_inscrit" onChange="this.form.submit();">
<option value="inscrit1" <?php if($_POST['choi_inscrit']=="inscrit1") { echo "selected";} ?>>Toutes</option>
<option value="inscrit2" <?php if($_POST['choi_inscrit']=="inscrit2") { echo "selected";} ?>>Inscriptions confirmées</option>
<option value="inscrit3" <?php if($_POST['choi_inscrit']=="inscrit3") { echo "selected";} ?>>Inscriptions abandonnées</option>
</select>
</form>
<?php
if ($_POST['choi_inscrit'] = "inscrit1") {
$reponse = $bdd->query('SELECT idforfait, forfait, duree, cours1, cours2, confirmation, DATE_FORMAT(date_inscription, \'%d/%m/%Y\') AS date_inscription_fr FROM forfaits ORDER BY idforfait DESC LIMIT 0, 200');
}
elseif ($_POST['choi_inscrit'] = "inscrit2") {
$reponse = $bdd->query('SELECT idforfait, forfait, duree, cours1, cours2, confirmation, DATE_FORMAT(date_inscription, \'%d/%m/%Y\') AS date_inscription_fr FROM forfaits WHERE confirmation = \'oui\' ORDER BY idforfait DESC LIMIT 0, 200');
}
else {
$reponse = $bdd->query('SELECT idforfait, forfait, duree, cours1, cours2, confirmation, DATE_FORMAT(date_inscription, \'%d/%m/%Y\') AS date_inscription_fr FROM forfaits WHERE confirmation = \'\' ORDER BY idforfait
DESC LIMIT 0, 200');
}
//J'affiche les lignes de mon tableau une à une avec une boucle.
while ($donnees = $reponse->fetch()) {
.............. |
Partager