Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
3,661
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. Array ( [0] => Array ( [user_id] => 6 [email] => jeremy2@gmail.com [voornaam] => Jeremy [product_id] => 73 [category_id] => 3 [product_naam] => Tennisracket ) ) jeremy2@gmail.com Jeremy Tennisracket
  2.  
  3. **jeremy2@gmail.com Jeremy Tennisracket**
  4.  
  5. <?php print_r($userdetail_list);
  6. foreach($userdetail_list as $row)
  7. {
  8. ?>
  9. <tr>
  10. <td><?php echo $row['email'];?></td>
  11. <td><?php echo $row['voornaam'];?></td>
  12. <td><?php echo $row['product_naam'];?></td>
  13. </tr>
  14. <?php } ?>
  15.  
  16. public function details($product_id)
  17. {
  18. //load the Product_model
  19. $this->load->model('Product_model');
  20.  
  21. //call function getdata in de Product_model
  22. $data['userdetail_list'] = $this->Product_model->getdata();
  23.  
  24. //get product details
  25. $data['product'] = $this->Product_model->get_product_details($product_id);
  26.  
  27. //laad view
  28. $data['main_content'] = 'details';
  29. $this->load->view('details',$data);
  30. }
  31.  
  32. public function getdata()
  33. {
  34. $this->db->select('users.user_id,users.email,users.voornaam,products.product_id,products.category_id,products.product_naam');
  35. $this->db->from('users');
  36. $this->db->join('products','products.user_id = users.user_id');
  37. $query = $this->db->get();
  38. if($query->num_rows()>0)
  39. {
  40. return $query->result_array();
  41. }
  42. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement