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 = ''; |