Bonjour,
a partir d'un formulaire je supprime des enregistrement d'une table. le probleme c'est que apres suppression le formulaire ne s'actualise pas les enregistrements supprimés n'existent plus dans la table mais sont visible au niveau du formulaire
voici "mon code" (enfin le code que j'ai copié
)
<?php
//<meta http-equiv="refresh" content="0;URL=http://example.com/page.html">
mysql_connect('localhost', 'root', '') or die ("Erreur de connexion"); //connexion
mysql_select_db("eraf");
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_ss = 10;
$pageNum_ss = 0;
if (isset($_GET['pageNum_ss'])) {
$pageNum_ss = $_GET['pageNum_ss'];
}
$startRow_ss = $pageNum_ss * $maxRows_ss;
$query_ss = "SELECT * FROM enseignant";
$query_limit_ss = sprintf("%s LIMIT %d, %d", $query_ss, $startRow_ss, $maxRows_ss);
$ss = mysql_query($query_limit_ss) or die(mysql_error());
$row_ss = mysql_fetch_assoc($ss);
if (isset($_GET['totalRows_ss'])) {
$totalRows_ss = $_GET['totalRows_ss'];
} else {
$all_ss = mysql_query($query_ss);
$totalRows_ss = mysql_num_rows($all_ss);
}
$totalPages_ss = ceil($totalRows_ss/$maxRows_ss)-1;
if (!empty($_POST['supprimer'])) {
foreach ($_POST['supprimer'] as $cle) {
$Requete2 = mysql_query("SELECT UTLISATEUR,PASSWORD FROM enseignant WHERE NOM = '$cle' ");
$resultat=mysql_fetch_array($Requete2);
$user=$resultat['UTLISATEUR'];
$pwd=$resultat['PASSWORD'];
$req = mysql_query("DELETE FROM poids WHERE PASSWORD = \"$pwd\" AND UTLISATEUR = \"$user\" ")
or die (mysql_error());
$Requete = mysql_query("DELETE FROM enseignant WHERE NOM = '$cle'");
}
//header("Location:suppadm.php"); !! cette instruction ne cause que des problemes !
}
$queryString_ss = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_ss") == false &&
stristr($param, "totalRows_ss") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_ss = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_ss = sprintf("&totalRows_ss=%d%s", $totalRows_ss, $queryString_ss);
?>
<html>
<head>
<title>Supprimer</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body background="arriere/t_15.jpg">
<form name="form1" method="post" action="">
<p align="center"> <font color="#000066" size="+6">Supprimer Enseignant</font></p>
<p align="center"> </p>
<table width="100%" border="1">
<tr>
<td width="23%"><div align="center"><strong>Nom</strong></div></td>
<td width="38%"><div align="center"><strong>Prenom</strong></div></td>
<td width="13%"><div align="center"><strong>Suppression</strong></div></td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_ss['NOM']; ?></td>
<td><?php echo $row_ss['PRENOM']; ?></td>
<td><input name="supprimer[]" type="checkbox" id="supprimer[]2" value="<?php echo $row_ss['NOM']; ?>"></td>
</tr>
<?php } while ($row_ss = mysql_fetch_assoc($ss)); ?>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="supprimer"></td>
</tr>
</table>
</form>
<p> Enregistrements <?php echo ($startRow_ss + 1) ?> à <?php echo min($startRow_ss + $maxRows_ss, $totalRows_ss) ?> sur <?php echo $totalRows_ss ?></p>
<p> <a href="<?php printf("%s?pageNum_ss=%d%s", $currentPage, max(0, $pageNum_ss - 1), $queryString_ss); ?>">Précédent
</a><a href="<?php printf("%s?pageNum_ss=%d%s", $currentPage, min($totalPages_ss, $pageNum_ss + 1), $queryString_ss); ?>">Suivant</a></p>
</body>
</html>
<?php
mysql_free_result($ss);
?>
merci pour votre aide