- 数据回显出问题,数据库没有对应字段,初始设计时联表未考虑到,也可能是数据库名称对应不上
- 表格渲染出不来,可能是layui的问题,这时候重新渲染表格form.render();
- 后端php返回数据类型问题,返回数据类型有数组和对象
$machines = Db::name('machines')->where($where)->order('id desc')->paginate(15);//返回的是对象
$list = Db::name('location')->alias('r')
->leftJoin('repository f','f.id = r.repository_id')
->where('r.is_delete',0)
->field('r.*,f.name as repository_name')->select();//返回的是数组
4.分页设计
//分页
$("#next").click(function () {
let curPage = Number($("#curPage").text());
let limit = $("#limit").val();
let total = $("#totalPage").text();
if (curPage + 1 <= total) {
window.location.href = `${curPath}?page=${curPage + 1}&limit=${limit}`;
} else {
layer.msg("没有下一页")
}
});
$("#previous").click(function () {
let curPage = Number($("#curPage").text());
let limit = $("#limit").val();
if (curPage - 1 > 0) {
window.location.href = `${curPath}?page=${curPage - 1}&limit=${limit}`;
} else {
layer.msg("没有上一页")
}
});
$("#navTo").click(function () {
let navPage = Number($("#navPage").val());
let limit = $("#limit").val();
let total = Number($("#totalPage").text());
if (0 < navPage && navPage <= total) {
window.location.href = `${curPath}?page=${navPage}&limit=${limit}`;
} else {
layer.msg("跳转的页面不存在哦")
}
});
let limit = localStorage.getItem("limit");
if (limit) {
$('#limit').val(limit);
layui.form.render();
}
layui.form.on('select(limit)', data => {
let limit = data.value
localStorage.setItem("limit", limit);
let navPage = Number($("#navPage").val());
window.location.href = `${curPath}?page=1&limit=${limit}`;
});
5.对数据库字段进行修改时,数据库字段未修改问题,缺少一个取地址符&
foreach ($data["news"] as &$new){
if($new["summary"] == ''){
$new["summary"] = mb_substr($new["title"] , 0, 18);
}
}