html代码
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
Documenttable.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;
}
id | 姓名 | 密码 | 性别 | 系部 | 班级 | 电话 | 操作 |
---|
header( 'Content-Type:text/html;charset=utf-8 ');
include_once("conn/conn.php"); //引入导入数据库控制页面
$sql="SELECT*from user"; //查询数据库中的user;
$r=mysqli_query($link,$sql);
$row=mysqli_fetch_array($r); //查询出来的数组类型
while ($row=mysqli_fetch_array($r)){
/*print_r($row);
echo "
";*/
/* echo $row["name"]."=>".$row["mima"]; //查询姓名和密码 也可以用键来查询
echo "
";*/
?>
<?php echo $row["id"]?><?php echo $row["name"]?><?php echo $row["mima"]?><?php echo $row["xingbie"]?> <?php echo $row["xibu"]?><?php echo $row["banji"]?><?php echo $row["tex"]?> );">删除}
?>
function del($id) {
var id=$id;
if (id){
$.get("shanchu.php",{id:id},function (data) { /*get获取数据*/
if (data=201){
alert("成功");
window.location.href=window.location.href; /* 刷新*/
}else {
alert("失败");
}
});
}else {
alert("失败");
}
}
php代码
header( 'Content-Type:text/html;charset=utf-8 ');
include_once("conn/conn.php");
$id=$_GET["id"];
$sql="delete from USER WHERE id=$id";
$r=mysqli_query($link,$sql);
if ($r){
echo "201";
}else{
echo "200";
}