Requete avec checkbox

Version imprimable

Voir 40 message(s) de cette discussion en une page

Il faut apprendre à faire simple :

Code:

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
$requete_select = "SELECT
	numStage,
	stage.libelle AS libelleStage,
	DATE_FORMAT(dateDebut,'%d/%m/%Y') AS dateDebut,
	DATE_FORMAT(dateFin,'%d/%m/%Y') AS dateFin,
	theme.libelle AS themeStage,
	DATE_FORMAT(dateLimite,'%d/%m/%Y') dateLimite,
	nbMax,
	specialite.libelle AS libelleSpe
FROM stage
	INNER JOIN theme ON stage.id_Theme = theme.id
        INNER JOIN specialite ON stage.id_Specialite = specialite.id
        LEFT OUTER JOIN inscrire ON inscrire.numStage_Stage = stage.numStage
	LEFT OUTER JOIN personnel ON personnel.id = inscrire.id_Personnel ";
 
if (isset($_POST['passe'])) {
	$critere[] = 'stage.dateFin < CURDATE()';
}
if (isset($_POST['aVenir'])) {
	$critere[] = 'stage.datedebut > CURDATE()';
}
if ((isset($_POST['enCours'])) {
	$critere[] = 'CURDATE() BETWEEN stage.datedebut AND stage.dateFin';
}
if (isset($critere)) {
 $requete_select .= ' WHERE ' . implode(' OR ', $critere);
}

04/07/2013, 21h46
totot

j'ai fait ce que tu ma dit et voilà ma requete qui fonctionne pas
1 thème sélectionné et deux cases cochées
2013-07-04

Code:

SELECT numStage, stage.libelle AS libelleStage, DATE_FORMAT(dateDebut,'%d/%m/%Y') AS dateDebut, DATE_FORMAT(dateFin,'%d/%m/%Y') AS dateFin, theme.libelle AS themeStage, DATE_FORMAT(dateLimite,'%d/%m/%Y') dateLimite, nbMax, specialite.libelle AS libelleSpe FROM stage INNER JOIN theme ON stage.id_Theme = theme.id INNER JOIN specialite ON stage.id_Specialite = specialite.id LEFT OUTER JOIN inscrire ON inscrire.numStage_Stage = stage.numStage LEFT OUTER JOIN personnel ON personnel.id = inscrire.id_Personnel WHERE stage.datedebut > '2013-07-04' OR '2013-07-04' BETWEEN stage.datedebut AND stage.dateFin WHERE theme.id ='2'ORDER BY stage.numStage
04/07/2013, 22h00
sabotage

Dans la requête que tu mets il a en plus " WHERE theme.id ='2' " qui n'est pas dans mon exemple.
Je pense que tu vas quand même arriver a correctement l'intégrer.

je l'ai réimplanté comme ceci-ci et sa va pas
Code:

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 $requete_select = "SELECT numStage, stage.libelle AS libelleStage, DATE_FORMAT(dateDebut,'%d/%m/%Y') AS dateDebut, DATE_FORMAT(dateFin,'%d/%m/%Y') AS dateFin, theme.libelle AS themeStage, DATE_FORMAT(dateLimite,'%d/%m/%Y') dateLimite, nbMax, specialite.libelle AS libelleSpe FROM stage INNER JOIN theme ON stage.id_Theme = theme.id INNER JOIN specialite ON stage.id_Specialite = specialite.id LEFT OUTER JOIN inscrire ON inscrire.numStage_Stage = stage.numStage LEFT OUTER JOIN personnel ON personnel.id = inscrire.id_Personnel "; if(isset($_POST["themeStage"]) && $_POST["themeStage"]!="") $critere[] = "theme.id = $_POST[themeStage]"; if(isset($_POST["nomPrenomVisiteur"]) && $_POST["nomPrenomVisiteur"]!="") $critere[] = "inscrire.id_Personnel = $_POST[nomPrenomVisiteur]"; if(isset($_POST["dateDebut"]) && $_POST["dateDebut"]!="") { $dateDebut = conversionDateFrançaisVersMySql($_POST["dateDebut"]); $critere[] = "stage.dateDebut = $dateDebut"; } if(isset($_POST["dateFin"]) && $_POST["dateFin"]!="") { $dateFin = conversionDateFrançaisVersMySql($_POST["dateFin"]); $critere[]= "stage.dateFin = $dateFin" ; } if ((isset($_POST['passe'])==true) && $_POST["passe"]!="") $critere[] = "stage.dateFin < '$date'"; if ((isset($_POST['aVenir'])==true) && $_POST["aVenir"]!="") $critere[] = "stage.datedebut > '$date'"; if ((isset($_POST['enCours'])==true) && $_POST["enCours"]!="") $critere[] = "'$date' BETWEEN stage.datedebut AND stage.dateFin"; if (isset($critere)) { $requete_select .= ' WHERE ' . implode(' OR ', $critere); } $requete = $requete_select." ORDER BY stage.numStage";
requete:

Code:

SELECT numStage, stage.libelle AS libelleStage, DATE_FORMAT(dateDebut,'%d/%m/%Y') AS dateDebut, DATE_FORMAT(dateFin,'%d/%m/%Y') AS dateFin, theme.libelle AS themeStage, DATE_FORMAT(dateLimite,'%d/%m/%Y') dateLimite, nbMax, specialite.libelle AS libelleSpe FROM stage INNER JOIN theme ON stage.id_Theme = theme.id INNER JOIN specialite ON stage.id_Specialite = specialite.id LEFT OUTER JOIN inscrire ON inscrire.numStage_Stage = stage.numStage LEFT OUTER JOIN personnel ON personnel.id = inscrire.id_Personnel WHERE theme.id = 2 OR inscrire.id_Personnel = 2 OR stage.dateFin < '2013-07-04' OR stage.datedebut > '2013-07-04' OR '2013-07-04' BETWEEN stage.datedebut AND stage.dateFin ORDER BY stage.numStage

j'ai tout coché dans mon formulaire
je voudrais avoir sa:

Code:

SELECT numStage, stage.libelle AS libelleStage, DATE_FORMAT(dateDebut,'%d/%m/%Y') AS dateDebut, DATE_FORMAT(dateFin,'%d/%m/%Y') AS dateFin, theme.libelle AS themeStage, DATE_FORMAT(dateLimite,'%d/%m/%Y') dateLimite, nbMax, specialite.libelle AS libelleSpe FROM stage INNER JOIN theme ON stage.id_Theme = theme.id INNER JOIN specialite ON stage.id_Specialite = specialite.id LEFT OUTER JOIN inscrire ON inscrire.numStage_Stage = stage.numStage LEFT OUTER JOIN personnel ON personnel.id = inscrire.id_Personnel WHERE theme.id = 2 AND inscrire.id_Personnel = 2 AND stage.dateFin < '2013-07-04' OR stage.datedebut > '2013-07-04' OR '2013-07-04' BETWEEN stage.datedebut AND stage.dateFin ORDER BY stage.numStage

Après 14 minutes tu abandonnes la reflexion ?

Code:

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
 
if(!empty($_POST["themeStage"]))
		$critere['AND'][] = 'theme.id = ' . intval($_POST['themeStage']);
 
if(!empty($_POST["nomPrenomVisiteur"]))
		$critere['AND'][] = 'inscrire.id_Personnel = "' .  mysql_real_escape_string($_POST['nomPrenomVisiteur']) .'"';
 
if (isset($_POST['passe']))
		$critere['OR'][] = "stage.dateFin < CURDATE()";
 
if (isset($_POST['aVenir']))
		$critere['OR'][] = "stage.datedebut > CURDATE()";
 
if (isset($_POST['enCours']))
		$critere['OR'][] = "CURDATE() BETWEEN stage.datedebut AND stage.dateFin";
 
 
	    if (isset($critere))   {
                  $n = TRUE;
                  foreach($critere as $operateur=>$conditions) {
                         $requete_select .= ($n) ? ' WHERE ' : ' AND ';
                         $requete_select .= '(' . implode(' ' . $operateur . ' ', $conditions) . ')';
                         $n = FALSE;
                  }
	    }
 
	    $requete = $requete_select." ORDER BY stage.numStage";

Je n'ai pas traité tes cas "égal" car on n'en avait pas parlé jusque là et comme j'ai du refaire toutes les corrections que tu as retirés, je n'ai plus le temps :P

Voir 40 message(s) de cette discussion en une page