/trunk/jrest/lib/RechercheObservation.php |
---|
100,7 → 100,7 |
$ids_mots_cles = $this->getIdsMotsClesObservation($observation['id_observation']); |
$mots_cles_chaine = ''; |
foreach($ids_mots_cles as $id_mot_cle) { |
$mots_cles_chaine .= $id_mot_cle['id_mot_cle_utilisateur'].';'; |
$mots_cles_chaine .= $id_mot_cle['id_mot_cle_obs'].';'; |
} |
$mots_cles_chaine = rtrim($mots_cles_chaine,';'); |
$observation['mots_cles'] = $mots_cles_chaine; |
111,7 → 111,7 |
private function getIdsMotsClesObservation($id_observation) { |
$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_utilisateur '. |
$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_obs '. |
'FROM cel_obs_mots_cles '. |
'WHERE id_observation = '.$id_observation; |
/trunk/jrest/lib/RechercheImage.php |
---|
287,7 → 287,7 |
$ids_mots_cles = $this->getIdsMotsClesImage($image['id_image']); |
$mots_cles_chaine = ''; |
foreach($ids_mots_cles as $id_mot_cle) { |
$mots_cles_chaine .= $id_mot_cle['id_mot_cle_utilisateur'].','; |
$mots_cles_chaine .= $id_mot_cle['id_mot_cle_image'].','; |
} |
$mots_cles_chaine = rtrim($mots_cles_chaine,','); |
$image['mots_cles'] = $mots_cles_chaine; |
298,7 → 298,7 |
private function getIdsMotsClesImage($id_image) { |
$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_utilisateur '. |
$requete_selection_mots_cles = 'SELECT DISTINCT id_mot_cle_image '. |
'FROM cel_images_mots_cles '. |
'WHERE id_image = '.$id_image; |