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

Home  >  Article  >  Backend Development  >  关于thinkphp查询以及分页的有关问题

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

WBOY
WBOYOriginal
2016-06-13 12:59:021283browse

关于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>
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn