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
|
<?php
$sqlEntr = mysql_query("SELECT * FROM document order by code_doc");
while ($T=mysql_fetch_array($sqlEntr))
{
$code_doc=$T['code_doc'];
echo"<tr>";echo"<th>"; print "<input type='checkbox' name='choisir' value='$code_doc'> ";echo"</th>";echo"<th>"; print "$T[code_doc]";echo"</th>";echo"<td>"; print "<a href='detail_index.php?No=.$T[code_doc].'>".$T["url"]."</a>" ; echo"</td>"; echo"</tr>";
}
echo"</table>";
?>
<?php
if(isset($_POST["choisir"]))
{$choisir=$_POST["choisir"];
if(!empty ($choisir))
{
$sql="DELETE FROM document WHERE code_doc='".$choisir."'";
$sql1="DELETE FROM terme WHERE code_doc='".$choisir."'";
$sql11="DELETE FROM titre WHERE code_doc='".$choisir."'";
$requete = mysql_query($sql, $cnx) or die( mysql_error() ) ;
mysql_close();
$requete1 = mysql_query($sql1, $cnx) or die( mysql_error() ) ;
mysql_close();
$requete11 = mysql_query($sql11, $cnx) or die( mysql_error() ) ;
mysql_close();
if(($requete) && ($requete1) && (requete11))
{
echo ("supprimer");
echo("<META HTTP-equiv=\"refresh\" content=0;URL=afficher_index.php>");
}
else
{
echo("L'insertion à échouée<br>") ;
}
}
}
?> |
Partager