| 66,7 → 66,10 |
|---|
| |
| $requete_insertion_infos_image = $this->construireRequeteInsertionImage($informations_image); |
| |
| $resultat_insertion_infos_image = $this->executer($requete_insertion_infos_image); |
| // important ! ne pas utiliser la fonction executerRequete qui renvoie une erreur si la requete contient des | (pipes) |
| // ce qui est fréquent dans les métadonnées |
| // TODO: corriger la fonction ou bien continuer à utiliser executerRequeteSimple |
| $resultat_insertion_infos_image = $this->executerRequeteSimple($requete_insertion_infos_image); |
| |
| if (!$resultat_insertion_infos_image) { |
| $message = "Echec de l'insertion dans la base de donnees : " ; |
| 97,7 → 100,7 |
|---|
| $nouvel_ordre = 0 ; |
| |
| $requete_selection_ordre_max ='SELECT MAX(ordre) as max_ordre FROM cel_images WHERE ce_utilisateur = '.$this->proteger($id_utilisateur) ; |
| $resultat_requete_ordre_max = $this->requeter($requete_selection_ordre_max); |
| $resultat_requete_ordre_max = $this->executerRequete($requete_selection_ordre_max); |
| |
| if($resultat_requete_ordre_max !== false) { |
| $nouvel_ordre = $resultat_requete_ordre_max[0]['max_ordre']; |
| 112,7 → 115,7 |
|---|
| $id_image = false; |
| |
| $requete_id_image ='SELECT id_image FROM cel_images WHERE ce_utilisateur = '.$this->proteger($id_utilisateur).' AND ordre = '.$ordre ; |
| $resultat_id_image = $this->requeter($requete_id_image); |
| $resultat_id_image = $this->executerRequete($requete_id_image); |
| |
| if (count($resultat_id_image) > 0) |
| { |
| 173,7 → 176,7 |
|---|
| $requete_mise_a_jour_image .= ' WHERE id_image = '.$this->proteger($id_image). |
| ' AND ce_utilisateur = '.$this->proteger($utilisateur); |
| |
| $resultat_mise_a_jour = $this->executer($requete_mise_a_jour_image); |
| $resultat_mise_a_jour = $this->executerRequeteSimple($requete_mise_a_jour_image); |
| |
| return ($resultat_mise_a_jour !== false); |
| } |
| 227,7 → 230,7 |
|---|
| 'ce_utilisateur = '.$this->proteger($id_utilisateur).' '. |
| 'AND ordre IN ('.$ids_images.') '; |
| |
| $tableau_ids_images = $this->requeter($requete_selection_ids_images); |
| $tableau_ids_images = $this->executerRequete($requete_selection_ids_images); |
| $chaine_ids_images = ''; |
| foreach($tableau_ids_images as $id_image) { |
| $chaine_ids_images .= $id_image['id_image']; |
| 252,9 → 255,9 |
|---|
| $requete_suppression_lien_images_obs = "DELETE FROM cel_obs_images WHERE id_image in (".$chaine_ids_images.")"; |
| $requete_suppression_lien_images_mots_cles = "DELETE FROM cel_images_mots_cles WHERE id_image in (".$chaine_ids_images.")"; |
| |
| $resultat_suppression_image = $this->executer($requete_suppression_images); |
| $resultat_suppression_lien_images_obs = $this->executer($requete_suppression_lien_images_obs); |
| $resultat_suppression_lien_images_mots_cles = $this->executer($requete_suppression_lien_images_mots_cles); |
| $resultat_suppression_image = $this->executerRequeteSimple($requete_suppression_images); |
| $resultat_suppression_lien_images_obs = $this->executerRequeteSimple($requete_suppression_lien_images_obs); |
| $resultat_suppression_lien_images_mots_cles = $this->executerRequeteSimple($requete_suppression_lien_images_mots_cles); |
| |
| if ($resultat_suppression_image === false) { |
| $message = 'Erreur lors de la suppression de l\'image' ; |