| 456,7 → 456,7 |
|---|
| } |
| |
| private function creerSousRequeteMotsCles($mot_cle) { |
| $requete = ''; |
| $requete = ' ( '; |
| if (preg_match('/.*,.*/', $mot_cle)) { |
| $requete = $this->creerSousRequeteMotsClesOu($mot_cle); |
| } else if (preg_match('/.*ET.*/', $mot_cle)) { |
| 463,7 → 463,7 |
|---|
| $requete = $this->creerSousRequeteMotsClesEt($mot_cle); |
| } else { |
| // Construction de la requête |
| $prerequete = "SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire FROM cel_mots_cles_images WHERE $where ". |
| $prerequete = "SELECT cmc_id_mot_cle_utilisateur, cmc_id_proprietaire FROM cel_mots_cles_images WHERE ". |
| 'cmc_id_mot_cle_general = '.$this->bdd->quote($this->encoderMotCle($mot_cle)); |
| $elements = $this->executerRequete($prerequete); |
| if ($elements != false && count($elements) > 0) { |
| 473,12 → 473,12 |
|---|
| } |
| } |
| } |
| $requete = rtrim($requete,' OR ').' AND '; |
| $requete = rtrim($requete,' OR ').' ) AND '; |
| return $requete; |
| } |
| |
| private function creerSousRequeteMotsClesOu($mot_cle) { |
| $requete = ''; |
| $requete = ' ( '; |
| |
| $tab_mots_cles = explode(',', $mot_cle); |
| $where = ''; |
| 500,7 → 500,7 |
|---|
| } |
| |
| private function creerSousRequeteMotsClesEt($mot_cle) { |
| $requete = ''; |
| $requete = ' ( '; |
| $where = ''; |
| $champs = 'a.cmc_id_proprietaire , '; |
| $table = ''; |