212,7 → 212,7 |
return $requete_maj_champs; |
} |
|
public function supprimerImage($id_utilisateur, $ordre_image_ou_tableau) { |
public function supprimerImageParOrdre($id_utilisateur, $ordre_image_ou_tableau) { |
|
if(is_array($ordre_image_ou_tableau)) { |
$id_image_ou_tableau = array_map(array($this,'proteger'),$ordre_image_ou_tableau); |
222,18 → 222,31 |
} |
|
$requete_selection_ids_images = 'SELECT id_image FROM cel_images WHERE '. |
'ce_utilisateur = '.$this->proteger($id_utilisateur).' '. |
'AND ordre IN ('.$ids_images.') '; |
|
$tableau_ids_images = $this->requeter($requete_selection_ids_images); |
'ce_utilisateur = '.$this->proteger($id_utilisateur).' '. |
'AND ordre IN ('.$ids_images.') '; |
|
$tableau_ids_images = $this->requeter($requete_selection_ids_images); |
$chaine_ids_images = ''; |
foreach($tableau_ids_images as $id_image) { |
$chaine_ids_images .= $id_image['id_image']; |
} |
} |
|
$chaine_ids_images = rtrim($chaine_ids_images,','); |
|
|
return $this->supprimerImage($id_utilisateur, $ordre_image_ou_tableau); |
} |
|
public function supprimerImage($id_utilisateur, $id_image_ou_tableau) { |
|
if(is_array($id_image_ou_tableau)) { |
$id_image_ou_tableau = array_map(array($this,'proteger'),$id_image_ou_tableau); |
$chaine_ids_images = implode(',',$id_image_ou_tableau); |
} else { |
$chaine_ids_images = $this->proteger($id_image_ou_tableau); |
} |
|
$requete_suppression_images = "DELETE FROM cel_images WHERE id_image in (".$chaine_ids_images.")"; |
|
$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.")"; |
|