Login

12-23-2009, 05:29 AM

[eluser]Sathishkumar[/eluser]
Hi,
Iam newbie in CI. Pagination problem to my site ... its my code

Controller :

Code:
$this->load->model('excute');        

$this->load->database();

$this->load->helper(array('url','form'));

$this->load->library('session');

$this->load->library('pagination');

$config['base_url'] = base_url().'index.php/student_submit/index';

$config['total_rows'] = count($this->excute->get_course2());

$config['per_page'] = 5;

$config['full_tag_open'] = '<p>';

$config['full_tag_close'] = '</p>';

$this->pagination->initialize($config);

$ddata['course'] = $this->excute->get_course2($config['per_page'],$this->uri->segment(3));

$this->load->view('student_submit',$ddata);

View :

Code:
&lt;?php

foreach($course as $key => $value):

?&gt;

&lt;input type="checkbox" name="course[]" value="&lt;?php echo $value['course_id']; ?&gt;" /&gt; 

&lt;?php echo $value['course_id']; ?&gt;

&lt;?php echo $value['course_name']; ?&gt;

&lt;?php echo $value['subject_id']; ?&gt;

&lt;?php echo $value['course_no_of_seats']; ?&gt;

&lt;?php echo $value['course_enroll_no']; ?&gt;

&lt;?php endforeach;?&gt;

&lt;?php echo $this->pagination->create_links(); ?&gt;

Model

Code:
function get_course2()

  { 

        $this->load->database();

        $this->load->library('pagination');

        $query = $this->db->query("SELECT * FROM course WHERE no_of_seats > enroll_no");

        $total_rows=$query->num_rows();

        if($total_rows>0)   

        {

            foreach($query->result_array() as $row) 

            {

                 $result[] = $row;             

            }

            return $result;

        }         

        else

           return 'null';      

  }

Please anybody Help Me....