1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
| if($nb_mess >= 1) {
$req = Cnx::connectCnx()->prepare("SELECT e.nom, e.prenom, e.session, e.token, m.id, m.id_expediteur, m.id_destinataire, m.titre_mess, m.message, m.postit, m.lu, m.date_mess FROM messagerie m INNER JOIN equipe e ON m.id_expediteur = e.id AND m.id_destinataire = :id AND m.postit=0 ORDER BY date_mess");
$req->execute(array('id' => $Auth->user('id')));
echo '<div class="mess"';
while($user=$req->fetch(PDO::FETCH_OBJ)) {
echo '<FORM action="index.php" method="POST">';
echo '<span class="mess_ligne">';
if (($user->lu)==1) {
echo '<input type="checkbox" name="choix[]" value="'.$user->id.'"> <span class="img_mess_lu"></span>';
}
else {
echo '<input type="checkbox" name="choix[]" value="'.$user->id.'"> <span class="img_mess_non_lu"></span>';
}
echo '<span class="mess_date">'.dateFr($user->date_mess).'</span>';
echo '<span class="mess_head">'.ucfirst($user->prenom). ' '.ucfirst($user->nom).'</span>';
echo '<span class="titre"><a href=\'indv.php?id='.$user->id.'&lu='.$user->lu.'&token='.$user->token.'\'>'.ucfirst($user->titre_mess).'</a></span><br>';
}
echo '<p>
<input onclick="CocheTout(this, \'choix[]\');" type="checkbox"><br>
<input type="submit" value="Supprimer" name="mess_suppr"/>
</p>
</FORM>
</div>';
if (isset($_POST["mess_suppr"])){
$donnees = filter_input_array(INPUT_POST, FILTER_SANITIZE_MAGIC_QUOTES);
foreach ($donnees['choix'] as $id) { /* LIGNE 44*/
$req = Cnx::connectCnx()->exec("DELETE FROM messagerie WHERE id=$id");
header ("Refresh: 0;URL=index.php");
}
}
else {
echo "La suppression n'a pas eu lieu.";
}
}
else{
echo "Aucun message";
} |
Partager