abstract：PHP$pdo = new PDO("mysql:host=localhost;dbname=tk181;charset=utf8","root","root");$page = $_GET['page'];$limit = $_GET['limit'];$sql = "select id,tit
PHP
$pdo = new PDO("mysql:host=localhost;dbname=tk181;charset=utf8","root","root");
$page = $_GET['page'];
$limit = $_GET['limit'];
$sql = "select id,title,date,source,ifshow from article";
$count = $pdo->query($sql)->rowCount(2);
$start = ($page-1)*$limit;
$sql.=" limit $start,$limit";
$data = $pdo->query($sql)->fetchAll(2);
$arr = ["code"=>0,"msg"=>'ok','count'=>$count,'data'=>$data];
echo json_encode($arr);
HTML
<script>
var table = layui.table;
table.render({
elem:"#test",
width:800,
height:500,
url:"table.php",
page:true,
limits:[10,20,30,40],
cols:[[
// {type:'checkbox',LAY_CHECKED:true},
{field:'id',title:'ID',width:80,sort:true,fixed:'left'},
{field:"title",title:'标题',width:300},
{field:'date',title:'发布日期',width:200},
{field:'source',title:'来源',width:150},
{field:'ifshow',title:'是否显示',templet:'#ifshow',width:100},
{title:'操作',toolbar:"#cz",width:150,align:'center',fixed:'right'}
]],
});
table.on('tool(article)',function(obj){
var data = obj.data;
var event = obj.event;
var tr = obj.tr;
if (evt=="edit") {
//修改
}else if(evt=="delete"){
//删除
}
//复选框监听
table.on
console.log(obj);
obj.del();
obj.update({
id:38,title:'haha',date:123,source:'华强',ifshow:0
});
})
</script>
Correcting teacher：查无此人Correction time：2019-06-19 09:23:20
Teacher's summary：完成的不错。不过page和limit 传值一个就行了。继续加油