layui数据库查询及数据处理

<span style="color: #008000;">//</span><span style="color: #008000;">**********************************************************************************</span>
    <span style="color: #0000ff;">case</span> ‘getmess‘:
        <span style="color: #800080;">$page</span> = <span style="color: #800080;">$_REQUEST</span>[‘page‘<span style="color: #000000;">];
        </span><span style="color: #800080;">$limit</span> = <span style="color: #800080;">$_REQUEST</span>[‘limit‘<span style="color: #000000;">];
        </span><span style="color: #800080;">$unames</span> = <span style="color: #800080;">$_REQUEST</span>[‘unames‘<span style="color: #000000;">];
        </span><span style="color: #800080;">$times</span> = <span style="color: #008080;">date</span>("Y-m-d H:i:s"<span style="color: #000000;">);
        </span><span style="color: #800080;">$logs</span> = <span style="color: #800080;">$_REQUEST</span>[‘logs‘<span style="color: #000000;">];
        </span><span style="color: #800080;">$names</span> = <span style="color: #800080;">$_REQUEST</span>[‘names‘<span style="color: #000000;">];
</span><span style="color: #008000;">//</span><span style="color: #008000;">        写sql语句</span>
        <span style="color: #800080;">$sql</span> = "SELECT count(*) FROM messboard WHERE <span style="color: #800080;">$names</span> = ‘<span style="color: #800080;">$unames</span>‘"<span style="color: #000000;">;
</span><span style="color: #008000;">//</span><span style="color: #008000;">        执行SQL语句</span>
        <span style="color: #800080;">$res</span> = <span style="color: #800080;">$db</span>->query(<span style="color: #800080;">$sql</span><span style="color: #000000;">);
</span><span style="color: #008000;">//</span><span style="color: #008000;">        返回结果集</span>
        <span style="color: #800080;">$mrr</span> = <span style="color: #800080;">$res</span>-><span style="color: #000000;">fetch_all();
        </span><span style="color: #0000ff;">if</span>(<span style="color: #800080;">$mrr</span><span style="color: #000000;">){
            </span><span style="color: #800080;">$sql</span> = 
                "SELECT * FROM messboard WHERE <span style="color: #800080;">$names</span> = ‘<span style="color: #800080;">$unames</span>‘ ORDER BY mid DESC limit ".(<span style="color: #800080;">$page</span>-1)*<span style="color: #800080;">$limit</span>.",<span style="color: #800080;">$limit</span>"<span style="color: #000000;">;
            </span><span style="color: #800080;">$res</span> = <span style="color: #800080;">$db</span>->query(<span style="color: #800080;">$sql</span><span style="color: #000000;">);
    </span><span style="color: #008000;">//</span><span style="color: #008000;">        新建数组</span>
            <span style="color: #800080;">$arr1</span> = <span style="color: #0000ff;">array</span><span style="color: #000000;">();
            </span><span style="color: #800080;">$arr2</span> = <span style="color: #0000ff;">array</span><span style="color: #000000;">();
            </span><span style="color: #0000ff;">while</span>(<span style="color: #800080;">$attr</span> = <span style="color: #800080;">$res</span>-><span style="color: #000000;">fetch_assoc()){
                </span><span style="color: #008080;">array_push</span>(<span style="color: #800080;">$arr1</span>,<span style="color: #800080;">$attr</span><span style="color: #000000;">);
            }
            </span><span style="color: #800080;">$arr2</span>["code"] = 0<span style="color: #000000;">;
            </span><span style="color: #800080;">$arr2</span>["msg"] = ""<span style="color: #000000;">;
            </span><span style="color: #800080;">$arr2</span>["count"] = <span style="color: #800080;">$mrr</span>[0][0<span style="color: #000000;">];
            </span><span style="color: #800080;">$arr2</span>["data"] = <span style="color: #800080;">$arr1</span><span style="color: #000000;">;
            </span><span style="color: #0000ff;">include</span>(‘../../../../../public/logpublic.php‘<span style="color: #000000;">);
            </span><span style="color: #0000ff;">echo</span> json_encode(<span style="color: #800080;">$arr2</span><span style="color: #000000;">);
        }
        </span><span style="color: #0000ff;">break</span><span style="color: #000000;">;
</span><span style="color: #008000;">//</span><span style="color: #008000;">************************************************************************</span>

数据响应格式：

JavaScript前台页面数据处理（例）：

<span style="color: #0000ff;">function</span><span style="color: #000000;"> showmess(){
    </span><span style="color: #0000ff;">var</span> preid = $(‘#preid‘).<span style="color: #000000;">html();
    </span><span style="color: #0000ff;">var</span> uid = $(‘#uid‘).<span style="color: #000000;">html();
    </span><span style="color: #0000ff;">var</span> unames = $(‘#unames‘).<span style="color: #000000;">html();
</span><span style="color: #008000;">//</span><span style="color: #008000;">**********************************************************************************</span>
    layui.<span style="color: #0000ff;">use</span>(‘table‘, <span style="color: #0000ff;">function</span><span style="color: #000000;">(){
        </span><span style="color: #0000ff;">var</span> table = layui.<span style="color: #000000;">table;
            table</span>.<span style="color: #000000;">render({
            where</span>:<span style="color: #000000;">{
                type</span>:‘getmess‘
                ,logs:‘查看个人留言板‘
                ,unames:$(‘#unames‘).<span style="color: #000000;">html()
                </span>,names:‘rnames‘<span style="color: #000000;">
                    }
            </span>,elem: ‘#mess_id‘
            ,height:‘450px‘
            ,url:‘messboard/messboard_php.php‘
            ,toolbar: ‘#toolbarDemo‘
            ,limit:‘8‘
            ,title: ‘留言板表‘
        ,cols:<span style="color: #000000;"> [[
          {type</span>: ‘checkbox‘, fixed: ‘left‘<span style="color: #000000;">}
          </span>,{field:‘mid‘, title:‘id‘,width:50<span style="color: #000000;">}
          </span>,{field:‘snames‘, title:‘发送人‘, width:150<span style="color: #000000;">}
          </span>,{field:‘rnames‘, title:‘接收人‘, width:150<span style="color: #000000;">}
          </span>,{field:‘content‘, title:‘留言内容‘, width:350<span style="color: #000000;">}
          </span>,{field:‘messtime‘, title:‘留言时间‘, width:182<span style="color: #000000;">}
          </span>,{field:‘state‘, title:‘状态‘, width:100<span style="color: #000000;">}
          </span>,{fixed: ‘right‘, title:‘操作‘, width:150,templet:<span style="color: #0000ff;">function</span><span style="color: #000000;">(d){
            </span><span style="color: #0000ff;">return</span> "<div class=‘layui-btn-group‘><button class=‘layui-btn layui-btn-sm‘ onClick=‘reply("+d.mid+")‘>回复</button><button class=‘layui-btn layui-btn-sm layui-btn-danger‘ onClick=‘del_mess("+d.mid+")‘>删除</button></div>"<span style="color: #000000;">
                }}
        ]]
        </span>,page: <span style="color: #0000ff;">true</span><span style="color: #000000;">
      })</span>

layui数据库查询及数据处理

标签：height   com   状态   table   bubuko   idt   func   查询   type