[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);