thinkphp项目中所遇到的问题

121 阅读1分钟
  1. 数据回显出问题,数据库没有对应字段,初始设计时联表未考虑到,也可能是数据库名称对应不上
  2. 表格渲染出不来,可能是layui的问题,这时候重新渲染表格form.render();
  3. 后端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);
            }
        }