关于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>