Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. class ClassModel
  2. {
  3. static public function selectAll()
  4. {
  5.  
  6.  
  7. $image = array();
  8.  
  9.  
  10. $sql = "SELECT * FROM `pageimage`";
  11.  
  12. $result = DataBase::connectDB()->query($sql);
  13.  
  14. $i = 0;
  15. while($row = $result->fetch_assoc())
  16. {
  17. $image[$i]["image"] = $row["image"];
  18. $image[$i]["keywords"] = $row["keywords"];
  19. $i++;
  20. }
  21.  
  22. return $image;
  23. }
  24.  
  25. static public function selectByName($parametr)
  26. {
  27.  
  28. $parametr = is_string($parametr);
  29.  
  30. if ($parametr)
  31. {
  32.  
  33.  
  34. $prepare = DataBase::connectDB()->prepare("SELECT keywords FROM pageimage WHERE keywords= ?");
  35.  
  36. $prepare->bind_param("s" , $parametr);
  37.  
  38. $prepare->execute();
  39.  
  40. $prepare->bind_result($image);
  41.  
  42. $prepare->fetch();
  43.  
  44. return $image;
  45.  
  46. }
  47.  
  48. }
  49. }
  50.  
  51. class PageController
  52. {
  53.  
  54. function __construct()
  55. {
  56. $image = array();
  57. $image = ClassModel::selectAll();
  58. require_once("view/index.php");
  59.  
  60. }
  61.  
  62. public function actionCategory($parametr = false)
  63. {
  64.  
  65.  
  66.  
  67. $parametr = ClassModel::selectByName($parametr);
  68.  
  69.  
  70. }
  71.  
  72. }
  73.  
  74. <div class="category-navigation">
  75. <?php foreach($image as $keywords){ ?>
  76. <a href="/freetemplate/<?php print "category/" .$keywords["keywords"]; ?>" class="cat"><?php print $keywords["keywords"]; ?></a>
  77. <?php } ?>
  78. </div>
  79.  
  80. <div class="row category-item">
  81. <div class="category-wrapping">
  82. <?php foreach($image as $key){ ?>
  83. <div class="category-container">
  84. <img src="/template/images/<?php print $key["image"]; ?>">
  85. </div>
  86. <?php } ?>
  87. <?php if($parametr){ ?>
  88. <div class="category-container">
  89. <img src="/template/images/<?php print $parametr; ?>">
  90. </div>
  91. <?php } ?>
  92. </div>
  93. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement