<div class="layui-body">
<table class="layui-hide" id="test" lay-filter="test"></table>
</div>
<script type="text/html" id="barDemo">
<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="del" href="/demo/delete.php">删除</a>
</script>
<script type="text/javascript" meth>
layui.use('table', function(){
var table = layui.table;
table.render({
elem: '#test'
,url:'/demo/select.php'
,toolbar: true
,title: '用户数据表'
,contentType:'application/json'
,cols: [[
{field:'id', title:'ID', width:80, fixed: 'left', unresize: true, sort: true, totalRowText: '合计行'}
,{field:'username', title:'用户名', width:120}
,{field:'password', title:'密码', width:150}
,{field:'age', title:'年龄', width:100}
,{field:'sex', title:'性别', width:80}
,{field:'phonenumber', title:'电话号码', width:100}
,{fixed: 'right', title:'操作', toolbar: '#barDemo', width:150}
]]
,page: true
,parseData: function(res){ //将原始数据解析成 table 组件所规定的数据
return {
"code": res.code, //解析接口状态
"msg": res.message, //解析提示文本
"count": res.count, //解析数据长度
"data": res.data //解析数据列表
};
}
});
table.on('toolbar(test)', function(obj){
var checkStatus = table.checkStatus(obj.config.id);
switch(obj.event){
case 'del':
layer.msg('删除');
url:'/demo/delete.php';
break;
};
});
});
</script>
<?php
$servername = "localhost";
$user = "admin";
$pass = "123456";
$dbname = "admin";
$username = $_POST["username"];
// 链接数据库
var_dump($username);
session_start();
header("Content-type:text/html;charset=utf-8");
$link = mysqli_connect($servername,$user,$pass,$dbname);
$del = "DELETE FROM test3 WHERE username = '$username'";
$del_q = mysqli_query($link,$del);
var_dump($del);
var_dump($del_q);
if($del_q){
echo "删除成功";
}
echo "删除失败";
?>