Membre
|
Bonjour, voila j'aimerais un peu d'aide pour la suppression des messages et cela par le membre
bon je préviens tout de suite je suis un débutant qui code mal
j'ai coder (on va dire ça ) un moyen de supprimer les messages pour l'instant sa marche le membre clique et le message se supprime mais le hic c'est qu'il faut cliquer deux fois sur
supprimer pour que le message se supprime
et je comprend pas pourquoi
<?php
include('config.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Nixsis</title>
<meta name="robots" content="all,index,follow" />
<meta name="Content-language" content="French" />
<meta name="revisit-after" content="1 days" />
<meta name="distribution" content="Global" />
<meta name="rating" content="general" />
<meta http-equiv="Content-language" content="fr" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
<link rel="stylesheet" type="text/css" href="css/global.css" />
</head>
<?php
//On verifie que lutilisateur est connecte
if(isset($_SESSION['username']))
{
//On affiche la liste des messages de l'utilisateur sous la forme dun tableau
//Deux requettes sont executees, une pour recuperer les messages non-lus et une pour les messages lus
$req1 = mysql_query('select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, users.id as userid, users.username from pm as m1, pm as m2,users where ((m1.user1="'.$_SESSION['userid'].'" and m1.user1read="no" and users.id=m1.user2) or (m1.user2="'.$_SESSION['userid'].'" and m1.user2read="no" and users.id=m1.user1)) and m1.id2="1" and m2.id=m1.id group by m1.id order by m1.id desc');
$req2 = mysql_query('select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, users.id as userid, users.username from pm as m1, pm as m2,users where ((m1.user1="'.$_SESSION['userid'].'" and m1.user1read="yes" and users.id=m1.user2) or (m1.user2="'.$_SESSION['userid'].'" and m1.user2read="yes" and users.id=m1.user1)) and m1.id2="1" and m2.id=m1.id group by m1.id order by m1.id desc');
?>
<body>
<div id="wrapper">
<div id="header">
<div class="limites"></div>
<div id='espace'>
<br/>
<br/>
<img src="images/anonyme.png" alt="logo" width="48" height="48" alt="" style="float:left; margin:0 10px;" />
<p>Attention cette section n’ est pas mit à jours quotidiennement..</p>
<br/>
<br/>
</div>
</div>
<ul id="speedbar">
<li><a href="index.php" ><img src="images/icons/accueil.png" alt="accueil" /><b>Accueil</b></a></li>
<li><a href="http://board.nixsis.powa.fr/index.php"><img src="../images/forum.png" width="26"alt="forum"> <b>Forum</b></a></li>
<li><a href="propos.html"><img src="../images/propos.png" width="26"alt="propos" /><b>A propos</b></a></li>
<li><a href="services.php"><img src="../images/service.png"width="26" alt="services" /><b>Nos services</b></a></li>
<li><a href="contact.html"><img src="../images/contact.png"width="26" alt="contact" /><b>Nous contacter</b></a></li>
</ul>
<div id="middle">
<div id="menu_messagerie">
<ul class="right"id="menu">
<li class="title bigest"><h2>Votre<br/> messagerie</h2></li>
<br/>
<li><a href="new_pm.php">Envoyer un message</a></li>
<li><a href="envmessagerie.php">Message(s) envoyé(s)</a></li>
<li><a href="messagerie.php">Boite de messagerie</a></li>
</ul></div>
<div id="content">
<br>
<br>
<div id="menu_reception">
Voici la liste de vos messages:<br/>
<h3>Messages non-lus(<?php echo intval(mysql_num_rows($req1)); ?>):</h3>
<table>
<tr>
<th class="title_cell">Titre</th>
<th>Nb. Réponses</th>
<th>Participant</th>
<th>Date d'envoi</th>
<th>Supprimer</th>
</tr>
<?php
//On affiche la liste des messages non-lus
while($dn1 = mysql_fetch_array($req1))
{
?>
<tr>
<td class="left"><a href="read_pm.php?id=<?php echo $dn1['id']; ?>"><?php echo htmlentities($dn1['title'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo $dn1['reps']-1; ?></td>
<td><a href="profile.php?id=<?php echo $dn1['userid']; ?>"><?php echo htmlentities($dn1['username'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo date('d/m/Y H:i:s' ,$dn1['timestamp']); ?></td>
</tr>
<?php
}
//Sil na aucun message non-lu, on le dit
if(intval(mysql_num_rows($req1))==0)
{
?>
<tr>
<td colspan="4" class="center">Vous n'avez aucun message non-lu.</td>
</tr>
<?php
}
?>
</table>
<br />
<h3>Messages lus(<?php echo intval(mysql_num_rows($req2)); ?>):</h3>
<table>
<tr>
<th class="title_cell">Titre</th>
<th>Nb. Réponses</th>
<th>Participant</th>
<th>Date d'envoi</th>
<th>Supprimer</th>
</tr>
<?php
//Supression du message
if ($suppr) {
$result=mysql_query ("DELETE FROM pm WHERE id='$suppr'") or die ("Erreur de suppression");}
//On affiche la liste des messages lus
while($dn2 = mysql_fetch_array($req2))
{
?>
<tr>
<td class="left"><a href="read_pm.php?id=<?php echo $dn2['id']; ?>"><?php echo htmlentities($dn2['title'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo $dn2['reps']-1; ?></td>
<td><a href="profile.php?id=<?php echo $dn2['userid']; ?>"><?php echo htmlentities($dn2['username'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo date('d/m/Y H:i:s' ,$dn2['timestamp']); ?></td>
<td>
<a href="messagerie.php?suppr=<?php echo $dn2['id']; ?>"><center><img src="http://www.widgetvalley.com/img/delete.png"width="16" /></center></a></td></td>
</tr>
<?php
}
//Sil na aucun message lu, on le dit
if(intval(mysql_num_rows($req2))==0)
{
?>
<tr>
<td colspan="4" ><center><img src="http://www.lbcreationimagia.123.fr/wp-content/themes/rt_crystalline_wp/images/icons/icon-warning.png"width="16"/>Vous n'avez aucun message lu.</center></td>
</tr>
<?php
}
?>
</table>
<?php
}
else
{
echo 'Vous devez être connecté pour accéder à cette page.';
}
?>
<p class="clear"></p>
</div>
<br/>
<br/>
<br/>
<div id="footer">
<ul>
<li><a href="#"><img src="" alt="" /></a></li>
<li class="tcenter">
© 2010 Naveo - Design by cenker <br/>
Ce site est la propriété exclusive de ses auteurs <br/>
</li>
<li>
Informations :<br/>
Site en construction !!<br/>
</li>
<li class="final">
Contact :<br />
Email : <a href="#">eddyjoron@gmail.com</a><br/>
Site Principale : <a href="#">Naveo.powa.fr</a>
</li>
</ul>
<p class="clear"> </p>
</div>
</div>
</div>
</body>
</html>
|
Admin
|
Bonjour,
il faut mettre le code de suppression avant l'affiche de la liste des messages:
<?php
include('config.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Nixsis</title>
<meta name="robots" content="all,index,follow" />
<meta name="Content-language" content="French" />
<meta name="revisit-after" content="1 days" />
<meta name="distribution" content="Global" />
<meta name="rating" content="general" />
<meta http-equiv="Content-language" content="fr" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
<link rel="stylesheet" type="text/css" href="css/global.css" />
</head>
<?php
//On verifie que lutilisateur est connecte
if(isset($_SESSION['username']))
{
//On affiche la liste des messages de l'utilisateur sous la forme dun tableau
//Deux requettes sont executees, une pour recuperer les messages non-lus et une pour les messages lus
$req1 = mysql_query('select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, users.id as userid, users.username from pm as m1, pm as m2,users where ((m1.user1="'.$_SESSION['userid'].'" and m1.user1read="no" and users.id=m1.user2) or (m1.user2="'.$_SESSION['userid'].'" and m1.user2read="no" and users.id=m1.user1)) and m1.id2="1" and m2.id=m1.id group by m1.id order by m1.id desc');
$req2 = mysql_query('select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, users.id as userid, users.username from pm as m1, pm as m2,users where ((m1.user1="'.$_SESSION['userid'].'" and m1.user1read="yes" and users.id=m1.user2) or (m1.user2="'.$_SESSION['userid'].'" and m1.user2read="yes" and users.id=m1.user1)) and m1.id2="1" and m2.id=m1.id group by m1.id order by m1.id desc');
//Supression du message
if ($suppr) {
$result=mysql_query ("DELETE FROM pm WHERE id='$suppr'") or die ("Erreur de suppression");}
?>
<body>
<div id="wrapper">
<div id="header">
<div class="limites"></div>
<div id='espace'>
<br/>
<br/>
<img src="images/anonyme.png" alt="logo" width="48" height="48" alt="" style="float:left; margin:0 10px;" />
<p>Attention cette section n’ est pas mit à jours quotidiennement..</p>
<br/>
<br/>
</div>
</div>
<ul id="speedbar">
<li><a href="index.php" ><img src="images/icons/accueil.png" alt="accueil" /><b>Accueil</b></a></li>
<li><a href="http://board.nixsis.powa.fr/index.php"><img src="../images/forum.png" width="26"alt="forum"> <b>Forum</b></a></li>
<li><a href="propos.html"><img src="../images/propos.png" width="26"alt="propos" /><b>A propos</b></a></li>
<li><a href="services.php"><img src="../images/service.png"width="26" alt="services" /><b>Nos services</b></a></li>
<li><a href="contact.html"><img src="../images/contact.png"width="26" alt="contact" /><b>Nous contacter</b></a></li>
</ul>
<div id="middle">
<div id="menu_messagerie">
<ul class="right"id="menu">
<li class="title bigest"><h2>Votre<br/> messagerie</h2></li>
<br/>
<li><a href="new_pm.php">Envoyer un message</a></li>
<li><a href="envmessagerie.php">Message(s) envoyé(s)</a></li>
<li><a href="messagerie.php">Boite de messagerie</a></li>
</ul></div>
<div id="content">
<br>
<br>
<div id="menu_reception">
Voici la liste de vos messages:<br/>
<h3>Messages non-lus(<?php echo intval(mysql_num_rows($req1)); ?>):</h3>
<table>
<tr>
<th class="title_cell">Titre</th>
<th>Nb. Réponses</th>
<th>Participant</th>
<th>Date d'envoi</th>
<th>Supprimer</th>
</tr>
<?php
//On affiche la liste des messages non-lus
while($dn1 = mysql_fetch_array($req1))
{
?>
<tr>
<td class="left"><a href="read_pm.php?id=<?php echo $dn1['id']; ?>"><?php echo htmlentities($dn1['title'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo $dn1['reps']-1; ?></td>
<td><a href="profile.php?id=<?php echo $dn1['userid']; ?>"><?php echo htmlentities($dn1['username'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo date('d/m/Y H:i:s' ,$dn1['timestamp']); ?></td>
</tr>
<?php
}
//Sil na aucun message non-lu, on le dit
if(intval(mysql_num_rows($req1))==0)
{
?>
<tr>
<td colspan="4" class="center">Vous n'avez aucun message non-lu.</td>
</tr>
<?php
}
?>
</table>
<br />
<h3>Messages lus(<?php echo intval(mysql_num_rows($req2)); ?>):</h3>
<table>
<tr>
<th class="title_cell">Titre</th>
<th>Nb. Réponses</th>
<th>Participant</th>
<th>Date d'envoi</th>
<th>Supprimer</th>
</tr>
<?php
//On affiche la liste des messages lus
while($dn2 = mysql_fetch_array($req2))
{
?>
<tr>
<td class="left"><a href="read_pm.php?id=<?php echo $dn2['id']; ?>"><?php echo htmlentities($dn2['title'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo $dn2['reps']-1; ?></td>
<td><a href="profile.php?id=<?php echo $dn2['userid']; ?>"><?php echo htmlentities($dn2['username'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo date('d/m/Y H:i:s' ,$dn2['timestamp']); ?></td>
<td>
<a href="messagerie.php?suppr=<?php echo $dn2['id']; ?>"><center><img src="http://www.widgetvalley.com/img/delete.png"width="16" /></center></a></td></td>
</tr>
<?php
}
//Sil na aucun message lu, on le dit
if(intval(mysql_num_rows($req2))==0)
{
?>
<tr>
<td colspan="4" ><center><img src="http://www.lbcreationimagia.123.fr/wp-content/themes/rt_crystalline_wp/images/icons/icon-warning.png"width="16"/>Vous n'avez aucun message lu.</center></td>
</tr>
<?php
}
?>
</table>
<?php
}
else
{
echo 'Vous devez être connecté pour accéder à cette page.';
}
?>
<p class="clear"></p>
</div>
<br/>
<br/>
<br/>
<div id="footer">
<ul>
<li><a href="#"><img src="" alt="" /></a></li>
<li class="tcenter">
© 2010 Naveo - Design by cenker <br/>
Ce site est la propriété exclusive de ses auteurs <br/>
</li>
<li>
Informations :<br/>
Site en construction !!<br/>
</li>
<li class="final">
Contact :<br />
Email : <a href="#">eddyjoron@gmail.com</a><br/>
Site Principale : <a href="#">Naveo.powa.fr</a>
</li>
</ul>
<p class="clear"> </p>
</div>
</div>
</div>
</body>
</html>
Cordialement
 |
Membre
|
merci mais même avec ton code pour supprimer mon message il faut que je clique deux fois sur supprimer enfin bon sa marche c'est l'important
|
Admin
|
Bonjour,
désolé, il fallait le mettre encore plus avant:
<?php
include('config.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Nixsis</title>
<meta name="robots" content="all,index,follow" />
<meta name="Content-language" content="French" />
<meta name="revisit-after" content="1 days" />
<meta name="distribution" content="Global" />
<meta name="rating" content="general" />
<meta http-equiv="Content-language" content="fr" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=utf8" />
<link rel="stylesheet" type="text/css" href="css/global.css" />
</head>
<?php
//On verifie que lutilisateur est connecte
if(isset($_SESSION['username']))
{
//Supression du message
if ($suppr) {
$result=mysql_query ("DELETE FROM pm WHERE id='$suppr'") or die ("Erreur de suppression");}
//On affiche la liste des messages de l'utilisateur sous la forme dun tableau
//Deux requettes sont executees, une pour recuperer les messages non-lus et une pour les messages lus
$req1 = mysql_query('select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, users.id as userid, users.username from pm as m1, pm as m2,users where ((m1.user1="'.$_SESSION['userid'].'" and m1.user1read="no" and users.id=m1.user2) or (m1.user2="'.$_SESSION['userid'].'" and m1.user2read="no" and users.id=m1.user1)) and m1.id2="1" and m2.id=m1.id group by m1.id order by m1.id desc');
$req2 = mysql_query('select m1.id, m1.title, m1.timestamp, count(m2.id) as reps, users.id as userid, users.username from pm as m1, pm as m2,users where ((m1.user1="'.$_SESSION['userid'].'" and m1.user1read="yes" and users.id=m1.user2) or (m1.user2="'.$_SESSION['userid'].'" and m1.user2read="yes" and users.id=m1.user1)) and m1.id2="1" and m2.id=m1.id group by m1.id order by m1.id desc');
?>
<body>
<div id="wrapper">
<div id="header">
<div class="limites"></div>
<div id='espace'>
<br/>
<br/>
<img src="images/anonyme.png" alt="logo" width="48" height="48" alt="" style="float:left; margin:0 10px;" />
<p>Attention cette section n’ est pas mit à jours quotidiennement..</p>
<br/>
<br/>
</div>
</div>
<ul id="speedbar">
<li><a href="index.php" ><img src="images/icons/accueil.png" alt="accueil" /><b>Accueil</b></a></li>
<li><a href="http://board.nixsis.powa.fr/index.php"><img src="../images/forum.png" width="26"alt="forum"> <b>Forum</b></a></li>
<li><a href="propos.html"><img src="../images/propos.png" width="26"alt="propos" /><b>A propos</b></a></li>
<li><a href="services.php"><img src="../images/service.png"width="26" alt="services" /><b>Nos services</b></a></li>
<li><a href="contact.html"><img src="../images/contact.png"width="26" alt="contact" /><b>Nous contacter</b></a></li>
</ul>
<div id="middle">
<div id="menu_messagerie">
<ul class="right"id="menu">
<li class="title bigest"><h2>Votre<br/> messagerie</h2></li>
<br/>
<li><a href="new_pm.php">Envoyer un message</a></li>
<li><a href="envmessagerie.php">Message(s) envoyé(s)</a></li>
<li><a href="messagerie.php">Boite de messagerie</a></li>
</ul></div>
<div id="content">
<br>
<br>
<div id="menu_reception">
Voici la liste de vos messages:<br/>
<h3>Messages non-lus(<?php echo intval(mysql_num_rows($req1)); ?>):</h3>
<table>
<tr>
<th class="title_cell">Titre</th>
<th>Nb. Réponses</th>
<th>Participant</th>
<th>Date d'envoi</th>
<th>Supprimer</th>
</tr>
<?php
//On affiche la liste des messages non-lus
while($dn1 = mysql_fetch_array($req1))
{
?>
<tr>
<td class="left"><a href="read_pm.php?id=<?php echo $dn1['id']; ?>"><?php echo htmlentities($dn1['title'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo $dn1['reps']-1; ?></td>
<td><a href="profile.php?id=<?php echo $dn1['userid']; ?>"><?php echo htmlentities($dn1['username'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo date('d/m/Y H:i:s' ,$dn1['timestamp']); ?></td>
</tr>
<?php
}
//Sil na aucun message non-lu, on le dit
if(intval(mysql_num_rows($req1))==0)
{
?>
<tr>
<td colspan="4" class="center">Vous n'avez aucun message non-lu.</td>
</tr>
<?php
}
?>
</table>
<br />
<h3>Messages lus(<?php echo intval(mysql_num_rows($req2)); ?>):</h3>
<table>
<tr>
<th class="title_cell">Titre</th>
<th>Nb. Réponses</th>
<th>Participant</th>
<th>Date d'envoi</th>
<th>Supprimer</th>
</tr>
<?php
//On affiche la liste des messages lus
while($dn2 = mysql_fetch_array($req2))
{
?>
<tr>
<td class="left"><a href="read_pm.php?id=<?php echo $dn2['id']; ?>"><?php echo htmlentities($dn2['title'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo $dn2['reps']-1; ?></td>
<td><a href="profile.php?id=<?php echo $dn2['userid']; ?>"><?php echo htmlentities($dn2['username'], ENT_QUOTES, 'UTF-8'); ?></a></td>
<td><?php echo date('d/m/Y H:i:s' ,$dn2['timestamp']); ?></td>
<td>
<a href="messagerie.php?suppr=<?php echo $dn2['id']; ?>"><center><img src="http://www.widgetvalley.com/img/delete.png"width="16" /></center></a></td></td>
</tr>
<?php
}
//Sil na aucun message lu, on le dit
if(intval(mysql_num_rows($req2))==0)
{
?>
<tr>
<td colspan="4" ><center><img src="http://www.lbcreationimagia.123.fr/wp-content/themes/rt_crystalline_wp/images/icons/icon-warning.png"width="16"/>Vous n'avez aucun message lu.</center></td>
</tr>
<?php
}
?>
</table>
<?php
}
else
{
echo 'Vous devez être connecté pour accéder à cette page.';
}
?>
<p class="clear"></p>
</div>
<br/>
<br/>
<br/>
<div id="footer">
<ul>
<li><a href="#"><img src="" alt="" /></a></li>
<li class="tcenter">
© 2010 Naveo - Design by cenker <br/>
Ce site est la propriété exclusive de ses auteurs <br/>
</li>
<li>
Informations :<br/>
Site en construction !!<br/>
</li>
<li class="final">
Contact :<br />
Email : <a href="#">eddyjoron@gmail.com</a><br/>
Site Principale : <a href="#">Naveo.powa.fr</a>
</li>
</ul>
<p class="clear"> </p>
</div>
</div>
</div>
</body>
</html>
Cordialement
|
