Advertisement
newbie296

my code

Oct 19th, 2015
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.15 KB | None | 0 0
  1. Controller :
  2. function perkategori(){
  3.  
  4. $arsesi = array(
  5. 'sesi_id' => $this->input->get('list')
  6. );
  7. $this->session->set_userdata($arsesi);
  8. redirect('categoryproduct');
  9. }
  10.  
  11. function listcategory(){
  12.  
  13. if($this->session->userdata('sesi_id') == false){
  14. redirect(base_url(),'redirect');
  15. return false;
  16. }
  17. $data['categoryHead'] = $this->M_home->listCategory();
  18. $this->load->view('frontend/template/header', $data);
  19. $data['productsLast'] = $this->M_home->listProductLast();
  20. $data['productsLast2'] = $this->M_home->listProductLast2();
  21. $data['category'] = $this->M_home->listCategory();
  22.  
  23. $config['base_url'] = base_url().'categoryproduct/'.$this->session->userdata('sesi_id');
  24. $config['total_rows'] = $this->M_home->listProductPerCategory_num_rows();
  25. $config['per_page'] = 12;
  26. $config['first_link'] = 'First';
  27. $config['last_link'] = 'Last';
  28. $config['next_link'] = 'Next';
  29. $config['prev_link'] = 'Prev';
  30. $config['use_page_numbers'] = TRUE;
  31. $page = ($this->uri->segment(3)) ? $this->uri->segment(3) : 0;
  32. $this->pagination->initialize($config);
  33. $data['listCategory'] = $this->M_home->listProductPerCategory($config['per_page'],$page);
  34.  
  35.  
  36. $this->load->view('frontend/category', $data);
  37. $this->load->view('frontend/template/footer');
  38. }
  39. Model :
  40. function listProductPerCategory($limit1='',$limit2=''){
  41. $data = array();
  42. $sql = "SELECT category.category, product.id, product.picture, product.name, product.part_no FROM product, category
  43. WHERE category.id=product.id_category AND product.id_category = ".$this->session->userdata('sesi_id').
  44. " ORDER BY product.part_no ASC LIMIT ".$limit2;
  45. if($limit1){
  46. $sql .= ",".$limit1;
  47. }
  48. $hasil = $this->db->query($sql);
  49. if($hasil->num_rows() > 0){
  50. $data = $hasil->result();
  51. }
  52. $hasil->free_result();
  53. return $data;
  54. }
  55.  
  56. function listProductPerCategory_num_rows(){
  57. $this->db->select('*');
  58. $this->db->from('product');
  59. $this->db->join('category', 'product.id_category = category.id');
  60. $this->db->where('product.id_category', $this->session->userdata('sesi_id'));
  61. $data = $this->db->get();
  62. return $data->num_rows();
  63. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement