Welcome Guest, Not a member yet? Register   Sign In
jQuery Pagination Help
#1

[eluser]RMinor[/eluser]
I am having issues getting jQuery pagination to work on my site. Below is my code:

Controller:
Code:
class Category extends CI_Controller
{

private $_page = 'category';
  
public function __construct() {
  parent::__construct();
  $this->load->model('Category_model');
  $this->load->library('pagination');
}

public function index($category) {
  $data['page'] = $this->Global_model->pageInformation($this->_page);
  $data['rotators'] = $this->Category_model->getRotators($category);
  $data['initial'] = $this->Category_model->getInitial($category);
  
  // Set pagination    
        $config['base_url']   = site_url('category');        
        $config['total_rows']   = $this->Category_model->getTotalRows($category);
        $config['uri_segment']   = 3;
        $config['per_page']   = '16';
        $config['is_ajax_paging']  =  TRUE; // default FALSE
        $config['paging_function']  = 'ajax_paging'; // Your jQuery paging
        $this->pagination->initialize($config);
        $data['pagination'] = $this->pagination->create_links();
  
  //$data['products'] = $this->Category_model->getProducts($category);
  $data['products'] = $this->Category_model->getProducts($category, $this->pagination->per_page, $this->uri->segment(3));
  $this->load->view('category_view', $data);
}

public function product() {
  $record_id = $_POST['record_id'];
  $data['product'] = $this->Category_model->getOneProduct($record_id);
  $this->load->view('ajax_record', $data);
}

}

Model:
Code:
class Category_model extends CI_Model
{

public function __construct() {
  parent::__construct();
}

public function getProducts($category, $limit, $offset) {
  $result = $this->db->query("SELECT *
   FROM product
   WHERE product_category = ?
   ORDER BY product_name
   LIMIT ?, ?", array($category, $offset, $limit));
  return $result->result_array();
}

public function getInitial($category) {
  $result = $this->db->query("SELECT *
   FROM product
   WHERE product_category = ?
   ORDER BY product_name
   LIMIT 0, 1", array($category));
  return $result->row_array();
}

public function getRotators($category) {
  $result = $this->db->query("SELECT *
   FROM rotator
   WHERE rotator_product_category = ?", array($category));
  return $result->result_array();
}

public function getOneProduct($product_id) {
  $result = $this->db->query("SELECT *
   FROM product
   WHERE product_id = ?", array($product_id));
  return $result->row_array();
}

public function getTotalRows($category) {
  $result = $this->db->query("SELECT COUNT(*) FROM product WHERE product_category = ?", array($category));
  return $result->row_array();
}

}

The error I get is: Fatal error: Unsupported operand types in /home/content/p/i/n/pinkydinks/html/digrepro/system/libraries/Pagination.php on line 125.

Line 125 is this:
Code:
$num_pages = ceil($this->total_rows / $this->per_page);




Theme © iAndrew 2016 - Forum software by © MyBB