关于thinkphp查询以及分页的有关问题

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Release： 2016-06-13 12:59:02

Original

1376 people have browsed it

关于thinkphp查询以及分页的问题
控制器里面的search方法：

public function search(){<br />
    import("@.ORG.Page");<br />
    $list = D('Blog');<br />
    $keyword = trim($this->_post('keyword','htmlspecialchars'));<br />
    $sql = "SELECT b.*, a.`content`, u.`username`<br />
        FROM blog b<br />
        LEFT JOIN blog_attribute a ON a.`blog_id`=b.`id`<br />
        LEFT JOIN user u ON u.`id`=b.`user_id`<br />
        ";<br />
    if(!empty($keyword)){<br />
        $sql .= " WHERE b.`title` LIKE '%{$keyword}%' OR a.`content` LIKE '%{$keyword}%'";<br />
    }<br />
    $count = count($list->query($sql));<br />
    $Page = new Page($count,2);<br />
    $firstRow = $Page->firstRow;<br />
    $listRows = $Page->listRows;<br />
    $this->data = $list->searchBlog($sql,$firstRow,$listRows);<br />
    $xxx['data'] = $this->data;<br />
    $page = $Page->show();<br />
    $xxx['page'] = $page;<br />
    //$this->data['page'] = $page;<br />
    //$this->assign("page",$page);<br />
    //var_dump(urldecode(json_encode($this->data)));<br />
    $this->show(urldecode(json_encode($xxx)));<br />
}

Copy after login

列表页的代码：

<import></import><br>
<import></import><br>
<script><br />
$(document).ready(function(){<br />
    $("button").click(function(){<br />
        var keyword = $(this).parent("div").children("input").val();<br />
        $.ajax({<br />
            url: "{:U('Blog/search')}",<br />
            type: "POST",<br />
            data: {"keyword":keyword},<br />
            error:function(e){<br />
                alert("查询出错！");<br />
            },<br />
            success:function(data){<br />
                $("#cell_tb_list").empty();<br />
                if(data != ""){<br />
                    data = eval('('+data+')');<br />
                    //alert(data.data.length);<br />
                    var layer = "<table class=\"has_checkbox\">";<br />
                    layer    +=     "<colgroup>";<br />
                    layer    +=         "<col class=\"col1\">";<br />
                    layer    +=         "<col class=\"col2\">";<br />
                    layer    +=         "<col class=\"col3\">";<br />
                    layer    +=         "<col class=\"col4\">";<br />
                    layer    +=         "<col class=\"col5\">";<br />
                    layer    +=     "";<br />
                    layer    +=     "<tbody>";<br />
                    layer    +=     "<tr class=\"hoverout\">";<br />
                    layer    +=         "<th class=\"td2\">发布人";<br />
                    layer    +=         "<th class=\"td2\">博客标题";<br />
                    layer    +=         "<th class=\"td2\">发布时间";<br />
                    layer    +=         "<th class=\"td2\">更新时间";<br />
                    layer    +=         "<th class=\"td2\">操作";<br />
                    layer    +=     "";<br />
                    for(var i=0;i<data.data.length;i++){<br />
                        layer += "<tr id=\"testhere\">";<br />
                        layer += "<td>"+data.data[i].username+"";<br />
                        layer += "<td>"+data.data[i].title+"";<br />
                        layer += "<td>"+data.data[i].create_time+"";<br />
                        layer += "<td>"+data.data[i].update_time+"";<br />
                        layer += "<td>修改|删除";<br />
                        layer += "";<br />
                    }<br />
                    layer    +=         "<tr class=\"hoverout\" ><td colspan=\"6\" id=\"td_click\" style=\"text-align:right;\">"+data.page+""; <div class="clear">
                  
               
               
         
            </script>

Copy after login