此分页类如何倒叙输出

hbhero

PHP复制代码

 
<?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Pager {
public $length = 5;
public $prevLabel = '';
public $nextLabel = '';
public $first = 0; //第一页
public $slider = 3;
public $perpage = 3;
public $query;
public $table;
public $count;
public $obj;
public $current;
 
 
function init($table,$perpage,$segment=3){
 
$this->table = $table;
$this->obj =& get_instance();  
$this->obj->load->database();
$this->current = $this->obj->uri->segment($segment);  
$this->perpage = $perpage;    
return $this;
 
}
 
 
//使用AR
 
function ar(){
 
$this->count = $this->obj->db->count_all($this->table);  
$this->query = $this->obj->db->get($this->table, $this->perpage,$this->perpage*$this->current);
 
return $this;
 
}
 
 
 
//使用 自己写的SQL
 
function sql($query,$count){
$this->count = $count;  
$this->query = $query;  
return $this;
 
}
 
 
function page($url,$current){
$perpage = $this->perpage;
$last = ceil($this->count/$perpage);
$prev = $current - 1; //上一页
$next = $current + 1;    //下一页
$output = "<ul class='pagenav'>";
    if ($current == $this->first) {
 
        $output .= "<li class=\"disabled\">首页 ".$this->prevLabel."</li>";
 
    } else {  
          $output .= "<li><a href='".site_url($url.'/')."'>首页  ".$this->prevLabel."</a></li>";  
    }
 
$mid = intval($this->length / 2);
 
    if ($current < $this->first) {
 
        $current = $this->first;
 
    }
 
    if ($current > $last) {
 
        $current = $last;
 
    }
    $begin = $current - $mid;
 
    if ($begin < $this->first) { $begin = $this->first; }
 
    $end = $begin + $this->length - 1;
 
 
    if ($end >= $last) {
 
        $end = $last-1;
 
        $begin = $end - $this->length + 1;
 
        if ($begin < $this->first) { $begin = $this->first; }
 
    }
 
    if ($begin > $this->first) {
 
        for ($i = $this->first; $i < $this->first + $this->slider && $i < $begin; $i++) {
 
            $page= $i;
 
            $in = $i + 1;
            $urls=site_url($url.'/'.$page);
 
            $output .= "<li><a href=\"{$urls}\">{$in}</a></li>";
 
        }
        if ($i < $begin) {
 
            $output .= "<li class=\"none\">...</li>";
 
        }
 
    }    
 
    for ($i = $begin; $i <= $end ; $i++) {
 
        $page = $i;
 
        $in = $i + 1;
 
        if ($i == $current) {
 
            $output .= "<li class=\"current\">{$in}</li>";
 
        } else {
 
            $urls=site_url($url.'/'.$page);
            $output .= "<li><a href=\"{$urls}\">{$in}</a></li>";
 
        }
 
    }
 
    if ($last - $end > $this->slider) {
 
        $output .= "<li class=\"none\">...</li>";
        $end = $last - $this->slider;
 
    }
 
 
    for ($i = $end + 1; $i < $last; $i++) {
 
        $page = $i;
        $in = $i + 1;
                $urls=site_url($url.'/'.$page);
        $output .= "<li><a href=\"{$urls}\">{$in}</a></li>";
 
    }
 
    if ($current == $last-1) {
 
        $output .= "<li class=\"disabled\">".$this->nextLabel." 末页</li>";
 
    } else {
        $page = $last-1;
                $urls=site_url($url.'/'.$page);
        $output .= "<li><a href=\"{$urls}\">".$this->nextLabel." 末页</a></li>";
    }
    $output .= "</ul>";
 
echo $output;  
}
 
}
 

复制代码

view

PHP复制代码

 
<div class="news">
 
       
<?php foreach($query->result() as $row){?>
<div class="student">
<div id="stu">
<div id="stu_img"><img src="<?php echo $row->pic;?>" height="100" width="100" alt="<?php echo $row->title;?>"/></div>
                <span style="font-size:14px; font-weight:bold"><?=anchor('shufa/student_view/'.$row->id,$row->title)?></span><br /><br />
        情景介绍：<?php echo $row->descr;?>
</div>
</div>
<?php }?>
       
 
<div style="width:460px; text-align:center; border:0px solid; float:right; padding-top:15px">
 
<?php $this->pager->page('shufa/student',$current);?>
</div>
</div>
 

复制代码

hbhero

其实我是想知道$this->db->get(table)这个方法如何如何能够加进去order by id desc

lijun14992560

$this->db->order_by("id", "desc");
$this->db->get(table);