| Line 160... |
Line 160... |
| 160 |
|
160 |
|
| 161 |
private function executerRequeteMiseAJourMotCleTexte($mots_cles_texte_chaine, $id_image_ou_obs, $identifiant_utilisateur) {
|
161 |
private function executerRequeteMiseAJourMotCleTexte($mots_cles_texte_chaine, $id_image_ou_obs, $identifiant_utilisateur) {
|
| 162 |
$requete = 'UPDATE '.(($this->mode == 'obs') ? 'cel_obs' : 'cel_images').' '.
|
162 |
$requete = 'UPDATE '.(($this->mode == 'obs') ? 'cel_obs' : 'cel_images').' '.
|
| 163 |
'SET mots_cles_texte = '.$this->proteger($mots_cles_texte_chaine).' '.
|
163 |
'SET mots_cles_texte = '.$this->proteger($mots_cles_texte_chaine).' '.
|
| 164 |
'WHERE '.(($this->mode == 'obs') ? 'id_observation' : 'id_image').' = '.$this->proteger($id_image_ou_obs).
|
164 |
'WHERE '.(($this->mode == 'obs') ? 'id_observation' : 'id_image').' = '.$this->proteger($id_image_ou_obs).
|
| 165 |
' AND ce_utilisateur = '.$this->proteger($identifiant_utilisateur);
|
165 |
' AND id_utilisateur = '.$this->proteger($identifiant_utilisateur);
|
| 166 |
return $this->executer($requete);
|
166 |
return $this->executer($requete);
|
| Line 167... |
Line 167... |
| 167 |
}
|
167 |
}
|
| 168 |
|
168 |
|
| Line 173... |
Line 173... |
| 173 |
'('.
|
173 |
'('.
|
| 174 |
'SELECT id_mot_cle_'.(($this->mode == 'obs') ? 'obs' : 'image').' '.
|
174 |
'SELECT id_mot_cle_'.(($this->mode == 'obs') ? 'obs' : 'image').' '.
|
| 175 |
'FROM cel_'.$this->mode.'_mots_cles '.
|
175 |
'FROM cel_'.$this->mode.'_mots_cles '.
|
| 176 |
'WHERE '.(($this->mode == 'obs') ? 'id_observation' : 'id_image').' = '.$this->proteger($id_image_ou_obs).
|
176 |
'WHERE '.(($this->mode == 'obs') ? 'id_observation' : 'id_image').' = '.$this->proteger($id_image_ou_obs).
|
| 177 |
')'.
|
177 |
')'.
|
| 178 |
' AND ce_utilisateur = '.$this->proteger($identifiant_utilisateur);
|
178 |
' AND id_utilisateur = '.$this->proteger($identifiant_utilisateur);
|
| 179 |
$resultats = $this->requeter($requete);
|
179 |
$resultats = $this->requeter($requete);
|
| 180 |
return $resultats;
|
180 |
return $resultats;
|
| 181 |
}
|
181 |
}
|
| Line 182... |
Line 182... |
| 182 |
|
182 |
|