Advertisement
Guest User

Untitled

a guest
Feb 20th, 2020
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.76 KB | None | 0 0
  1. <?php
  2. require_once('./controllers/BaseController.php');
  3. require_once ('./classes/Category.php');
  4.  
  5. class CategoryController extends BaseController
  6. {
  7. protected $name= 'category';
  8. protected $categorySelected;
  9.  
  10. public function __construct($cat)
  11. {
  12. $this->categorySelected = $cat;
  13. var_dump($cat);
  14. parent::__construct();
  15. }
  16.  
  17.  
  18. public function getProductsByCategory($categorie)
  19. {
  20.  
  21. switch ($categorie){
  22. case '':
  23. $result = Db::getInstance()->query("SELECT * FROM products")->fetchAll();
  24.  
  25. break;
  26.  
  27. case 'animaux':
  28. $result = Db::getInstance()->query("SELECT * FROM products WHERE category = 'animal'")->fetchAll();
  29.  
  30. break;
  31.  
  32. case 'travail':
  33. $result = Db::getInstance()->query("SELECT * FROM products WHERE category ='travail'")->fetchAll();
  34.  
  35. break;
  36.  
  37. case 'maison':
  38. $result = Db::getInstance()->query("SELECT * FROM products WHERE category ='maison'")->fetchAll();
  39.  
  40. break;
  41. }
  42.  
  43. $products = [];
  44.  
  45. foreach ($result as $key => $row) {
  46. $products[] = Product::fromRow(new Product(), $row); //on crée un nouvel objet product dans lequel on vient injecter la valeur contenue dans $row
  47.  
  48. }
  49.  
  50. return $products;
  51. }
  52.  
  53.  
  54.  
  55.  
  56.  
  57. protected function getTemplateVars()
  58. {
  59. return array(
  60. "controller" => $this->name,
  61. "products" => $this->getProductsByCategory($this->categorySelected) //"" = nom des variables qui seront utilisées dans le template
  62.  
  63. );
  64. }
  65. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement