阿贾克斯数据库删除

最新推荐文章于 2022-09-26 22:17:50 发布

weixin_34303897

最新推荐文章于 2022-09-26 22:17:50 发布

阅读量228

点赞数

文章标签： php 数据库 javascript ViewUI

原文链接：http://www.cnblogs.com/index0629/p/7904832.html

版权

<!DOCTYPE html>
<html>
<head>
<script type="text/javascript" src="js/jquery-1.11.3.min.js"></script>
</head>
<style type="text/css">
table.imagetable {
font-family: verdana,arial,sans-serif;
font-size:11px;
color:#333333;
border-width: 1px;
border-color: #999999;
border-collapse: collapse;
}
table.imagetable th {
background:#b5cfd2 url('cell-blue.jpg');
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #999999;
}
table.imagetable td {
background:#dcddc0 url('cell-grey.jpg');
border-width: 1px;
padding: 8px;
border-style: solid;
border-color: #999999;
}
</style>

<body>
<table class="imagetable">
<tr>
<th>id</th><th>name</th><th>password</th><th>sex</th><th>college</th><th>class</th><th>telephone number</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);
// $row=mysqli_fetch_array($r);

while ($row=mysqli_fetch_array($r)) {
?>
<tr>
<td><?php echo $row["id"]?></td>
<td><?php echo $row["name"]?></td>
<td><?php echo $row["password"]?></td>
<td><?php echo $row["sex"]?></td>
<td><?php echo $row["college"]?></td>
<td><?php echo $row["class"]?></td>
<td><?php echo $row["tel"]?></td>
<td><button οnclick="del(<?php echo $row["id"]?>);">删除</button></td>
</tr>

<?php
}
?>
</table>
<script type="text/javascript">
function del($id){
  var id=$id;
  if(id){
       $.get("delete.php",{'id':id,},function(data){
       if(data==1){
         alert('成功');
         window.location.href=window.location.href;
       }else{
         alert('失败');
       }
       });
  }
}
</script>
</body>