$this->load->library('table'); $config['base_url']='http://localhost/AnimeInventory/index.php/maincontroller/records'; $config['total_rows'] = $this->db->get('detail')->num_rows(); $config['per_page'] = 5; $config['num_links'] = 2; $config['uri_segment'] = 3; $data['getRecords'] = $this->inventoryModel->selectData($config['per_page'],$this->uri->segment(3)); $this->pagination->initialize($config); $this->load->view('template/header'); $this->load->view('printdog',$data); $this->load->view('template/footer');
public function selectData(){ $sql = "SELECT detail.id, detail.Title, genre.GenreName, detail.EntryDate From detail INNER JOIN genre on detail.GenreID = genre.GenreID LIMIT 5 OFFSET 5"; $daf = $this->db->query($sql); return $daf->result_array(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)