| 319,7 → 319,6 |
|---|
| // comme avec implode (attention au fait que l'on concatène des % au début et à la fin) |
| foreach($mots_cles as $mot_cle) { |
| $requeteMotsCles = $this->proteger('%'.$mot_cle.'%'); |
| $requeteMotsClesImg .= 'di.mots_cles_texte LIKE '.$requeteMotsCles.' AND '; |
| $requeteMotsClesObs .= 'dob.mots_cles_texte LIKE '.$requeteMotsCles.' AND '; |
| } |
| $requeteMotsClesImg = rtrim($requeteMotsClesImg, ' AND '); |
| 340,12 → 339,21 |
|---|
| * Chargement depuis la bdd de toutes les liaisons entre images et observations |
| * */ |
| private function chargerObservations() { |
| $requete = 'SELECT distinct id_observation '. |
| /*$requete = 'SELECT DISTINCT id_observation '. |
| 'FROM '.$this->gestionBdd->formaterTable('del_obs_image', 'dob'). |
| $this->chargerClauseWhere(). |
| ' GROUP BY id_observation'. |
| //' ORDER BY '.$this->tri.' '.$this->directionTri.' '. |
| $this->gestionBdd->getLimitSql(); |
| $this->gestionBdd->getLimitSql();*/ |
| |
| $requete = 'SELECT DISTINCT dob.id_observation '. |
| 'FROM '.$this->gestionBdd->formaterTable('del_observation', 'dob'). |
| 'INNER JOIN '.$this->gestionBdd->formaterTable('del_obs_image', 'doi'). |
| 'ON doi.id_observation = dob.id_observation '. |
| $this->chargerClauseWhere(). |
| ' ORDER BY '.$this->tri.' '.$this->directionTri.' '. |
| $this->gestionBdd->getLimitSql(); |
| |
| return $this->bdd->recupererTous($requete); |
| } |
| |