Forum : Réalisée des condition

Bonjour,

Encore moi, sur mon moteur de recherche qui me bloque.
Je vous explique, j'ai 4 critère de recherche qui son le prix, la qualité, le nombre de chambre et le lieux.

Tous fonctionne bien, mais quant un ou plusieurs critère de recherche ne donne pas de résultat mon tableau est vide,
ce que je voudrais faire c'est plusieurs requête de recherche.

Si reponse ne donne pas de résultat,
On passe a reponse1 si celui là ne donne pas de résultat,
On passe a reponse2 et ainsi de suite...
jusqu'a afficher un résultat.
Merci de votre aide,

Voilà mon code :

     <?php

     try
     {
        $bdd = new PDO('mysql:host=dczjfjzdo;dbname=lekfnlen','ekorfko','lekrfjle');
     }
     catch(Exception $e)
     {
        // En cas d'erreur, on affiche un message et on arrête tout
             die('Erreur : '.$e->getMessage());
     }

                      $i = 0;

                        $price = ''. $_GET['price'] . '';
                        $nb_rooms = ''. $_GET['nb_rooms'] . '';
                        $good_quality = ''. $_GET['good_quality'] . '';
                        $neighborhood = ''. $_GET['neighborhood'] . '';
                        $neighborhood_1 = ''. $_GET['neighborhood_1'] . '';
                        $neighborhood_2 = ''. $_GET['neighborhood_2'] . '';
                        $neighborhood_3 = ''. $_GET['neighborhood_3'] . '';
                        $neighborhood_4 = ''. $_GET['neighborhood_4'] . '';
                        $neighborhood_5 = ''. $_GET['neighborhood_5'] . '';
                        $neighborhood_6 = ''. $_GET['neighborhood_6'] . '';
                        $neighborhood_7 = ''. $_GET['neighborhood_7'] . '';

                        if(!empty($budget_min)) { $choix[$i++] = " $price BETWEEN 'budget_min' AND 'budget_max' "; }
                        if(!empty($nb_rooms)) { $choix[$i++] = "nb_rooms = '$nb_rooms'"; }
                        if(!empty($good_quality)) { $choix[$i++] = "good_quality LIKE '$good_quality'"; }
                        if(!empty($neighborhood)) { $choix[$i++] = "neighborhood LIKE '$neighborhood'"; }
                                if(!empty($neighborhood_1)) { $choix[$i++] = "neighborhood_1 LIKE '$neighborhood_1'"; }
                                if(!empty($neighborhood_2)) { $choix[$i++] = "neighborhood_2 LIKE '$neighborhood_2'"; }
                                if(!empty($neighborhood_3)) { $choix[$i++] = "neighborhood_3 LIKE '$neighborhood_3'"; }
                                if(!empty($neighborhood_4)) { $choix[$i++] = "neighborhood_4 LIKE '$neighborhood_4'"; }
                                if(!empty($neighborhood_5)) { $choix[$i++] = "neighborhood_5 LIKE '$neighborhood_5'"; }
                                if(!empty($neighborhood_6)) { $choix[$i++] = "neighborhood_6 LIKE '$neighborhood_6'"; }
                                if(!empty($neighborhood_7)) { $choix[$i++] = "neighborhood_7 LIKE '$neighborhood_7'"; }

                      $critere = $choix[0]." ";

                     for($j=1;$j<$i;$j++)
                     {
                              $critere .= " AND ".$choix[$j]." ";
                      }

                      $reponse = $bdd->query("SELECT * FROM db_purchaser, db_customer WHERE $critere AND id_customer=id_custo") or die(mysql_error());

                      if($i > 0)
                     {

                          $reponse = $bdd->query("SELECT * FROM db_purchaser, db_customer WHERE $critere AND id_customer=id_custo") or die(mysql_error());

                      }

                      elseif($reponse = null)
                     {
                          $reponse1 = $bdd->query("SELECT * FROM db_purchaser, db_customer WHERE $price BETWEEN 'budget_min' AND 'budget_max' AND nb_rooms = '$nb_rooms' AND neighborhood LIKE '$neighborhood' AND id_customer=id_custo") or die(mysql_error());
                      }

                      elseif($reponse1 = null)
                      {
                           $reponse2 = $bdd->query("SELECT * FROM db_purchaser, db_customer WHERE $$price BETWEEN 'budget_min' AND 'budget_max' AND nb_rooms = '$nb_rooms' AND neighborhood LIKE '$neighborhood' AND id_customer=id_custo") or die(mysql_error());
                       }

                      elseif($reponse2 = null)
                       {
                            $reponse3= $bdd->query("SELECT * FROM db_purchaser, db_customer WHERE $$price BETWEEN 'budget_min' AND 'budget_max' AND nb_rooms = '$nb_rooms' AND id_customer=id_custo") or die(mysql_error());
                       }

                      else($reponse3 = null)
                       {
                             $reponse4 = $bdd->query("SELECT * FROM db_purchaser, db_customer WHERE $$price BETWEEN 'budget_min' AND 'budget_max' AND id_customer=id_custo") or die(mysql_error());
                       }

    while ($donnees = $reponse->fetch())
    while ($donnees1 = $reponse1->fetch())
    while ($donnees2 = $reponse2->fetch())
    while ($donnees3 = $reponse3->fetch())
    while ($donnees4 = $reponse4->fetch())

     {
     ?> 

     // affiche mon résultat

26 réponses

Nagase

Réponse acceptée

A partir du moment ou tu passe dans le if tu passe pas dans le elseif, là il faut mettre des if à la place.