| Line 126... |
Line 126... |
| 126 |
$requete_objets_lies_mot_cle = 'SELECT '.$champ_objet_lie.' as id FROM cel_'.$this->mode.'_mots_cles WHERE '.
|
126 |
$requete_objets_lies_mot_cle = 'SELECT '.$champ_objet_lie.' as id FROM cel_'.$this->mode.'_mots_cles WHERE '.
|
| 127 |
$champ_mot_cle.' IN '.$chaine_mot_cles_ids;
|
127 |
$champ_mot_cle.' IN '.$chaine_mot_cles_ids;
|
| Line 128... |
Line 128... |
| 128 |
|
128 |
|
| 129 |
$requete_suppression_liaison_mot_cle = 'DELETE FROM cel_'.$this->mode.'_mots_cles WHERE '.
|
129 |
$requete_suppression_liaison_mot_cle = 'DELETE FROM cel_'.$this->mode.'_mots_cles WHERE '.
|
| 130 |
$champ_mot_cle.' IN '.$chaine_mot_cles_ids;
|
130 |
$champ_mot_cle.' IN '.$chaine_mot_cles_ids;
|
| 131 |
|
131 |
|
| Line 132... |
Line 132... |
| 132 |
$resultat_suppression_mot_cle = $this->executer($requete_suppression_liaison_mot_cle);
|
132 |
$resultat_suppression_mot_cle = $this->executer($requete_suppression_liaison_mot_cle);
|
| 133 |
|
133 |
|
| 134 |
$resultat_requete_objets_lies_mot_cle = $this->requeter($requete_objets_lies_mot_cle);
|
134 |
$resultat_requete_objets_lies_mot_cle = $this->requeter($requete_objets_lies_mot_cle);
|
| Line 161... |
Line 161... |
| 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 ce_utilisateur = '.$this->proteger($identifiant_utilisateur);
|
| 166 |
echo $requete;
|
- |
|
| 167 |
return $this->executer($requete);
|
166 |
return $this->executer($requete);
|
| 168 |
}
|
167 |
}
|
| Line 169... |
Line 168... |
| 169 |
|
168 |
|
| 170 |
private function obtenirMotsClesTexte($id_image_ou_obs, $identifiant_utilisateur) {
|
169 |
private function obtenirMotsClesTexte($id_image_ou_obs, $identifiant_utilisateur) {
|