| 1,8 → 1,7 |
|---|
| <?php |
| |
| Class InventoryImageListPublic extends Cel { |
| class InventoryImageListPublic extends Cel { |
| |
| private $criteres = array('mots-cles' => 'c.ci_meta_mots_cles', |
| private $criteres = array('tag' => 'c.ci_meta_mots_cles', |
| 'auteur' => 'c.ci_ce_utilisateur', |
| 'commune' => 'b.location', |
| 'dept' => 'b.id_location', |
| 50,6 → 49,7 |
|---|
| $this->limit = $_GET['limit']; |
| } |
| |
| |
| // Construction de la requête |
| $requete_debut = 'SELECT * '; |
| |
| 233,7 → 233,7 |
|---|
| |
| private function creerSousRequeteMotsCles($mot_cle) { |
| $requete = ''; |
| if (preg_match('/.*,.*/', $mot_cle)) { |
| if (preg_match('/.*OU.*/', $mot_cle)) { |
| $requete = $this->creerSousRequeteMotsClesOu($mot_cle); |
| } else if (preg_match('/.*ET.*/', $mot_cle)) { |
| $requete = $this->creerSousRequeteMotsClesEt($mot_cle); |
| 256,7 → 256,7 |
|---|
| private function creerSousRequeteMotsClesOu($mot_cle) { |
| $requete = ''; |
| |
| $tab_mots_cles = explode(',', $mot_cle); |
| $tab_mots_cles = explode('OU', $mot_cle); |
| $where = ''; |
| foreach ($tab_mots_cles as $mot) { |
| $where .= 'cmc_id_mot_cle_general = '.$this->proteger($this->encoderMotCle($mot)).' OR '; |