_post('keyword"/> _post('keyword">

首页  >  文章  >  后端开发  >  关于thinkphp查询以及分页的有关问题

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

WBOY
WBOY原创
2016-06-13 12:59:021242浏览

关于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>
声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn