_post('keyword"/> _post('keyword">
Home > Article > Backend Development > 关于thinkphp查询以及分页的有关问题
关于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 /> }
<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>