分页难题。。。。。
我2张表查询出的结果,不会分页,,论坛里的都是1张表的。。。 不容易啊,被我搞出来了,用的常规法做的,,爷爷的,控制,模型,视图,3个都要改,,加完了分页方法后,连主方法也不得不改。。。function sel2($page)
{
$page_size=2;//每页显示记录
$message_count=$this->db->count_all("talk ");
$page_count=ceil($message_count/$page_size);
if($page<=0) $page=1;
if($page>=$page_count) $page=$page_count;
$offset=($page-1)*$page_size;
function fenye($page)
{
$data['page']=$page;
$data['d']=$this->session->userdata('d');
$data['dat'] = $this->luntantest->sel2($page);
$this->load->view('index',$data);
}
<?php
$page_size=2;//每页显示记录
$message_count=$this->db->count_all("talk");
$page_count=ceil($message_count/$page_size);
if($page<=0) $page=1;
if($page>=$page_count) $page=$page_count;
$offset=($page-1)*$page_size;
echo "
";
$prev_page=$page-1;
$next_page=$page+1;
if($page<=1) echo "第一页";
else echo "<a href= 'http://localhost/Myluntan/ci/index.php/luntan/fenye/1'>第一页</a>";
echo " ";
if ($prev_page<1) echo "上一页";
else
echo "<a href= 'http://localhost/Myluntan/ci/index.php/luntan/fenye/$prev_page'>上一页</a>";
echo " ";
if ($next_page>$page_count) echo "下一页";
else echo "<a href=' http://localhost/Myluntan/ci/index.php/luntan/fenye/$next_page'>下一页</a>";
echo " ";
if ($page>=$page_count) echo "最后一页";
else echo "<a href='http://localhost/Myluntan/ci/index.php/luntan/fenye/$page_count'>最后一页</a>";
echo " ";
?> 不用分页类?c和m里面侵入html将来维护麻烦 <?php
1.get_total_rows();
2.get_per();
3.get_start();
4.select_data();
5.show_data();
?> 2表,联表才可以分页咯;真不联表,也只能以一个表来做主表来分页,不然实在不知道怎么可以分页。
libraries/Pagination 很好用啊,不是很理解楼主的意图
页:
[1]