如何在codeigniter控制器中使用限制

Kevin 发表于 Dev

凯文

我正在做 ajax 滚动分页。控制器如下

<?php
require APPPATH . '/controllers/user/Usercontroller.php';

class PaginationController extends Usercontroller{

    public function __construct(){
        parent::__construct();
        $this->load->model("Usermodel","",true);    
    }

    private $perPage = 5;

    public function index(){
        $tutorId=$this->session->userdata('cp_userid');
        $categorycourses=$this->Usermodel->getcourses($tutorId);

        $count = $categorycourses->num_rows();

        $data['details']=$categorycourses;          
        $this->load->view("user/pagination_view",$data,true);
    }
}
?>

$count 变量包含 5 个数据，我想为第一页发送 3 个数据，为第二页发送剩余的数据。这该怎么做。

钱德拉·库马尔

试试这个...

模型：

function getcourses($tutorId, $limit = null) {
    $this->db->select('*');
    $this->db->from('courses');
    $this->db->where("tutorId", $tutorId);
    //$this->db->order_by("name", "asc");

    if($limit!=''){
       $this->db->limit($limit);
    }
    $query  = $this->db->get();

    $courses = array();
    foreach ($query->result() as $row)
        array_push($courses, $row);

    return $courses;     
}

控制器：

public function index(){
    $tutorId = $this->session->userdata('cp_userid');
    $limit = 3;
    $categorycourses = $this->Usermodel->getcourses($tutorId, $limit);
    //$categorycourses=$this->Usermodel->getcourses($tutorId);

    $count = $categorycourses->num_rows();

    $data['details'] = $categorycourses;      

    $this->load->view("user/pagination_view", $data, true);
}

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。