删除

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<script type="text/javascript" src="../js/jquery.js"></script>

</head>
<script type="text/javascript">
function deletes($id){
var id=$id;
if (id) {
$.get("../conn/delect.php",{'id':id},function(data){
if (data==200) {
alert("正确");
window.location.href=window.location.href;
}else{
alert("cuouw");
}

});
}
}
</script>
<style>
table{
margin: 0 auto;
}
.table3_12 table {
width:100%;
margin:15px 0
}
.table3_12 th {

background-color:#50C2FF;
color:#FFFFFF

}
.table3_12,.table3_12 th,.table3_12 td
{

font-size:0.95em;
text-align:center;
padding:4px;
border:1px solid #20adfe;
border-collapse:collapse;
}
.table3_12 tr:nth-child(odd){
background-color:#c4eafe;

}
.table3_12 tr:nth-child(even){
background-color:#fdfdfd;
}
tr td{
width: 150px;
height: 30px;
}
tr th{
width: 150px;
height: 30px;
}
</style>
<body>
<table class="table3_12">
<tr>
<th>ID</th><th>用户名</th><th>密码</th><th>性别</th><th>系部</th><th>班级</th><th>电话</th><th>操作</th><th>修改</th>
</tr>
<?php
header("content-type:text/html;charset=utf-8");
include_once("../conn/conn.php");
$sql="SELECT * FROM user ";
$r=mysqli_query($link,$sql);
while ($n=mysqli_fetch_array($r)) {
?>
<tr>
<td><?php echo $n["id"]; ?></td><td><?php echo $n["name"]; ?></td><td><?php echo $n["password"]; ?></td><td><?php echo $n["sex"]; ?></td><td><?php echo $n["college"]; ?></td><td><?php echo $n["class"]; ?></td><td><?php echo $n["tel"]; ?></td><td><button href="" onclick="deletes(<?php echo $n['id'];?>);">删除</button></td><td><a href="jiade.php?id=<?php echo $n['id'];?>"> 修改</a></td>
</tr>


<?php
}
?>
</table>

</body>
</html>

 

 

 

<?php
include_once("conn.php");
$id=$_GET["id"];
$sql="DELETE FROM user WHERE id=$id";
$r=mysqli_query($link,$sql);
if ($r) {
echo 200;
}else{
echo 000;
}
?>

posted @ 2017-12-25 11:17  彬斌宾  阅读(96)  评论(0)    收藏  举报