API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 18th, 2019
212
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.79 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE html>
  2. <!--< lang="en" dir="ltr">-->
  3. <head>
  4. <meta charset="utf-8">
  5. <title>Wide World Importers</title>
  6. <!-- Fontawesome script foor icoontjes en indien nodig fonts-->
  7. <script src="https://kit.fontawesome.com/88f9e92465.js" crossorigin="anonymous"></script>
  8. <!-- Favicon -->
  9. <link rel="shortcut icon" type="image/png" href="favicon.ico"/>
  10. <link rel="stylesheet" href="browse_items.css">
  11. <!-- Bootstrap -->
  12. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css"
  13. integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T"
  14. crossorigin="anonymous">
  15. <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"
  16. integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo"
  17. crossorigin="anonymous"></script>
  18. <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"
  19. integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1"
  20. crossorigin="anonymous"></script>
  21. <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"
  22. integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM"
  23. crossorigin="anonymous"></script>
  24. </head>
  25. <body>
  26.  
  27.  
  28. <!--Navigatiebar-->
  29. <nav class="navbar navbar-expand-lg navbar-dark primary-color bg-primary">
  30.  
  31. <!-- Navbar brand -->
  32. <a class="navbar-brand" href="index.php">Wide World Importers</a>
  33.  
  34. <!-- Collapse button -->
  35. <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#basicExampleNav"
  36. aria-controls="basicExampleNav" aria-expanded="false" aria-label="Toggle navigation">
  37. <span class="navbar-toggler-icon"></span>
  38. </button>
  39.  
  40. <!-- Content navbar -->
  41. <div class="collapse navbar-collapse" id="basicExampleNav">
  42.  
  43. <!-- Links van de navbar -->
  44. <ul class="navbar-nav mr-auto">
  45. <li class="nav-item">
  46. <a class="nav-link" href="#">Inloggen</a>
  47. </li>
  48. <li class="nav-item">
  49. <a class="nav-link" href="#">Registreren</a>
  50. </li>
  51. <li class="nav-item">
  52. <a class="nav-link" href="#">Klantenservice</a>
  53. </li>
  54. <li class="nav-item">
  55. <a class="nav-link" href="#">FAQ</a>
  56. </li>
  57.  
  58. <!-- Dropdown -->
  59. <li class="nav-item dropdown">
  60. <a class="nav-link dropdown-toggle" id="navbarDropdownMenuLink" data-toggle="dropdown"
  61. aria-haspopup="true" aria-expanded="false">Dropdown</a>
  62. <div class="dropdown-menu dropdown-primary" aria-labelledby="navbarDropdownMenuLink">
  63. <a class="dropdown-item" href="#">Dit is een voorbeeld</a>
  64. <a class="dropdown-item" href="#">Voorbeeld</a>
  65. <a class="dropdown-item" href="#">voorbeeld</a>
  66. </div>
  67. </li>
  68. </ul>
  69. </div>
  70.  
  71. </nav>
  72. <form method="post" action="zoek.php">
  73. <div id="vorm2-zoekbalk">
  74. <!-- plaatje van wwi-->
  75. <div id="thumbnailgrootte">
  76. <a href="index.php"><img src="wwi.png" class="img-fluid" alt="Responsive image"></a>
  77. </div>
  78. <!-- zoekbalk-->
  79. <div class="sizezoek">
  80. <input type="search" name="Zoeken" placeholder="Waar bent u naar op zoek?"
  81. aria-describedby="button-addon1"
  82. class="form-control border-0 bg-light">
  83. </div>
  84. <!-- zoekknopje-->
  85. <div class="input-group-append">
  86. <button id="button-addon1" name="zoek" type="submit" class="btn btn-link text-primary"><i
  87. class="fa fa-search"></i>
  88. </button>
  89. </div>
  90. <!-- accountplaatje-->
  91. <div id="accountcss">
  92. <a href="#" id="user"><i class="fas fa-user"></i></a>
  93. </div>
  94. <!-- winkelwagenplaatje-->
  95. <div id="winkelwagenicoontje">
  96. <a href=""><i class="fas fa-shopping-cart"></i></a>
  97. </div>
  98. </div>
  99. </form>
  100. <div id="banneropmaak">
  101. <?php
  102. $naam = "geen bestaande catgorie";
  103. if ($_GET["c"] == 1) {
  104. $naam = "nieuw";
  105. }
  106. if ($_GET["c"] == 2) {
  107. $naam = "kleding";
  108. }
  109. if ($_GET["c"] == 3) {
  110. $naam = "mokken";
  111. }
  112. if ($_GET["c"] == 4) {
  113. $naam = "t-shirts";
  114. }
  115. if ($_GET["c"] == 5) {
  116. $naam = "vliegtuigjes";
  117. }
  118. if ($_GET["c"] == 6) {
  119. $naam = "computer gadgets";
  120. }
  121. if ($_GET["c"] == 7) {
  122. $naam = "USB gadgets";
  123. }
  124. if ($_GET["c"] == 8) {
  125. $naam = "pluizige schoenen";
  126. }
  127. if ($_GET["c"] == 9) {
  128. $naam = "speelgoed";
  129. }
  130. if ($_GET["c"] == 10) {
  131. $naam = "verpakkingsmaterialen";
  132. }
  133. print "U zoekt nu in $naam";
  134. ?>
  135. </div>
  136. <div id="paginaopmaakbrowse">
  137. <!-- Lijst met categorieën -->
  138. <div id="categorieopmaak">
  139. <div class="container bg-light" style="margin-top: 10px;">
  140. <h6>Categorieën:</h6>
  141. <div class="list-group w-5 p-3">
  142. <a href="browse_items.php?c=1" class="list-group-item list-group-item-action">Nieuw</a>
  143. <a href="browse_items.php?c=2" class="list-group-item list-group-item-action">Kleding</a>
  144. <a href="browse_items.php?c=3" class="list-group-item list-group-item-action">Mokken</a>
  145. <a href="browse_items.php?c=4" class="list-group-item list-group-item-action">T-Shirts</a>
  146. <a href="browse_items.php?c=5" class="list-group-item list-group-item-action">Vliegtuigjes</a>
  147. <a href="browse_items.php?c=6" class="list-group-item list-group-item-action">Computer
  148. gadgets</a>
  149. <a href="browse_items.php?c=7" class="list-group-item list-group-item-action">USB gadgets</a>
  150. <a href="browse_items.php?c=8" class="list-group-item list-group-item-action">Pluizige
  151. schoenen</a>
  152. <a href="browse_items.php?c=9" class="list-group-item list-group-item-action">Speelgoed</a>
  153. <a href="browse_items.php?c=10" class="list-group-item list-group-item-action">Verpakkingsmaterialen</a>
  154.  
  155. </div>
  156. </div>
  157. </div>
  158. </body>
  159. <div>
  160.  
  161. <!-- --><?php
  162. // if (isset($_GET["knop"])) {
  163. // $count = $_GET["COUNT()"];
  164. // $prijs = $_GET["RecommendedRetailPrice"];
  165. // $foto = $_GET["Photo"];
  166. // $naam = $_GET["StockItemName"];
  167. // }
  168. //
  169. // $sql1 = "SELECT COUNT() FROM stockitems";
  170. // $statement = mysqli_prepare($connection,$sql1);
  171. // if($statement === false) {
  172. // die("Er is wat mis gegaan bij het ophalen binnen de database: " . mysqli_error($connection));
  173. // }
  174. // mysqli_stmt_execute($statement);
  175. // $result = mysqli_stmt_get_result($statement);
  176. //
  177. // while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){
  178. // $count = $row["COUNT()"];
  179. // print($row["COUNT()"] . " Resultaten" . "<br> <br>");
  180. // }
  181. //
  182.  
  183.  
  184. ?>
  185. <?php
  186.  
  187. if (!empty($_GET["c"])) {
  188. $zoek = $_GET["c"];
  189. }
  190. function MaakVerbinding()
  191. {
  192. $host = 'localhost';
  193. $user = 'root';
  194. $pass = 'root';
  195. $databasename = "wideworldimporters";
  196. $connection = mysqli_connect($host, $user, $pass, $databasename);
  197. return $connection;
  198. }
  199.  
  200. function SluitVerbinding($connection)
  201. {
  202. mysqli_close($connection);
  203. }
  204.  
  205.  
  206. //pakt het paginanr uit de url als die er niet staat gebruikt 1
  207. $pagina = $_GET["pagina"] ?? 1;
  208.  
  209. $per_page = 24;
  210. //pakt pagina en vermenigvuldigd het met hoeveel producten je wilt per pagina
  211. $offset = ($pagina - 1) * $per_page;
  212. $connection = MaakVerbinding();
  213. //SELECT * FROM stockitems s JOIN stockitemsstockgroups x USING StockItemID JOIN stockgroups g USING StockGroupID WHERE g.StockGroupName = ?
  214. //sql querie voor de zoekmachine
  215. $sql = "SELECT StockItemID,StockItemName,RecommendedRetailPrice,UnitPrice FROM Stockitems WHERE StockItemID IN (SELECT StockItemID FROM Stockitemstockgroups WHERE StockGroupID = ?) LIMIT $offset,$per_page";
  216. $sqlCount = "SELECT COUNT(*) FROM Stockitems WHERE StockItemID IN (SELECT StockItemID FROM Stockitemstockgroups WHERE StockGroupID = ?)";
  217.  
  218. // $zoek = "%$zoek%";
  219. //maakt een sql querie gereed om te gebruiken doormiddel van een variable
  220. $statement = mysqli_prepare($connection, $sql);
  221. //bind variable aan die $statement als parameters
  222. mysqli_stmt_bind_param($statement, 's', $zoek);
  223. //voert de $statement uit waardoor je resultaat krijgt
  224. mysqli_stmt_execute($statement);
  225. //Slaat het resultaat op in een variable
  226. $result = mysqli_stmt_get_result($statement);
  227.  
  228. //doet hetzelfde als hierboven alleen dan om te checken hoeveel pagina's je nodig hebt
  229. $statementCount = mysqli_prepare($connection, $sqlCount);
  230. mysqli_stmt_bind_param($statementCount, 's', $zoek);
  231. mysqli_stmt_execute($statementCount);
  232. $resultCount = mysqli_stmt_get_result($statementCount);
  233. $totalItems = mysqli_fetch_all($resultCount)[0][0];
  234. // berekent hoeveel pagina's je nodig hebt
  235. $pages = ceil($totalItems / $per_page);
  236.  
  237. //"vangt het resultaat in een variable $row en maakt er een array van zodat je het kan printen
  238. $count = 0;
  239. while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
  240. // als count 0 maakt het een nieuwe rij met producten
  241. if ($count == 0) {
  242. print ("<div class='row'>");
  243. }
  244. ?>
  245. <!--Css classes om de producten te stylen-->
  246. <div class="col-md-4">
  247. <div id="resultaatopmaak">
  248. <figure class="card card-product">
  249. <div class="img-wrap">
  250. <img src="sample.png">
  251. </div>
  252. <figcaption class="info-wrap">
  253. <h6 class="title text-dots"><a
  254. href="productpagina.php?productid=<?php print($row['StockItemID']) ?>"><?php echo $row['StockItemName']; ?></a>
  255. </h6>
  256. <div class="action-wrap">
  257. <a href="#" class="btn btn-primary btn-sm float-right"><i
  258. class="fas fa-cart-plus"></i></a>
  259. <div class="price-wrap h5">
  260. <span class="price-new">€<?php echo $row['UnitPrice']; ?></span>
  261. <del class="price-old">€<?php echo $row['RecommendedRetailPrice'] ?></del>
  262. </div> <!-- price-wrap.// -->
  263. </div> <!-- action-wrap -->
  264. </figcaption>
  265. </figure> <!-- card // -->
  266. </div> <!-- col // -->
  267. </div>
  268.  
  269. <?php
  270. $count++;
  271. // als count 3 is beiindigd de if statement de nieuwe rij door het te sluiten en count weer op 0 te zetten zodat er een nieuwe rij word gemaakt
  272. if ($count == 3) {
  273.  
  274. print ("</div>");
  275. $count = 0;
  276. }
  277. }
  278.  
  279.  
  280. ?>
  281.  
  282. <?php
  283.  
  284. sluitVerbinding($connection);
  285.  
  286. ?>
  287.  
  288. </div>
  289. </div>
  290. </div>
  291. <?php if ($pages != 0){?>
  292. <nav class="d-flex justify-content-center">
  293. <ul class="pagination">
  294. <?php
  295. // zorgt ervoor dat je geen negatieve pagina's krijgt
  296. $disabled = ($pagina == 1) ? "disabled" : "";
  297. $pre = $pagina - 1;
  298. //hiermee ga je naar de vorige pagina
  299. echo "
  300. <li class=\"page-item $disabled\">
  301. <a class=\"page-link\" href=\"?c=$zoek&pagina=$pre\">Previous</a>
  302. </li> ";
  303. //print je de pagina nummers in classes
  304. for ($i = 1; $i <= $pages; $i++) {
  305. $active = ($pagina == $i) ? "active" : "";
  306. echo "<li class=\"page-item $active\"><a class=\"page-link\" href=\"?c=$zoek&pagina=$i\">$i</a></li>";
  307. }
  308. $disabled = ($pagina == $pages) ? "disabled" : "";
  309. $n = $pagina + 1;
  310. //hiermee ga je naar de volgende pagina
  311. echo "
  312. <li class=\"page-item $disabled\">
  313. <a class=\"page-link\" href=\"?c=$zoek&pagina=$n\">Next</a>
  314. </li>";
  315. ?>
  316. </ul>
  317. </nav>
  318. <?php }?>
  319. <!--Footer-->
  320. <footer>
  321. <div class="mt-5 pt-5 pb-5 footer bg-primary">
  322. <div class="container">
  323. <div class="row">
  324. <div class="col-lg-5 col-xs-12 about-company">
  325. <h2>Wide World Importers</h2>
  326. <p class="pr-5 text-white-50">Dit is een sample text van de footer maar hier staat eigenlijk
  327. niets
  328. maar ook weer wel.</p>
  329. </div>
  330. <div class="col-lg-3 col-xs-12 links" style="height: 100px">
  331. <h4 class="mt-lg-0 mt-sm-3">Links</h4>
  332. <ul class="m-0 p-0">
  333. <li>- <a href="#" class="pr-5 text-white-50">Contact</a></li>
  334. <li>- <a href="#" class="pr-5 text-white-50">Bestellen & leveren</a></li>
  335. <li>- <a href="#" class="pr-5 text-white-50">Retourneren</a></li>
  336. <li>- <a href="#" class="pr-5 text-white-50">Betalen</a></li>
  337. <li>- <a href="#" class="pr-5 text-white-50">Garantie</a></li>
  338. <li>- <a href="#" class="pr-5 text-white-50">Algemene voorwaarden</a></li>
  339. </ul>
  340. </div>
  341. <div class="col-lg-4 col-xs-12 location">
  342. <h4 class="mt-lg-0 mt-sm-4">Contact</h4>
  343. <p class="mb-0"><i class="fa fa-phone mr-3"></i>088 469 9911</p>
  344. <p class="mb-0"><i class="fa fa-envelope-o mr-3"></i><a id="linkmail"
  345. href="mailto:info@wideworldimporters.nl">info@wideworldimporters.nl</a>
  346. </p>
  347. <p class="mb-0"><i class="fas fa-map-pin" style="margin-right: 22px"></i><a
  348. style="text-decoration: none; color: white;"
  349. href="https://maps.google.com/?ll=52.499560,6.080570">Campus 2, 8017 CA Zwolle</a>
  350. </p>
  351. </div>
  352. </div>
  353.  
  354. <div class="w-25 p-3">
  355. <img src="betaal.png" alt="betaal" style="width: 300px; ">
  356. </div>
  357.  
  358. <div class="row mt-5" style="">
  359. <div class="col copyright">
  360. <p class="">
  361. <small class="text-white-50">© 2019 Wide World Importers</small>
  362. </p>
  363. </div>
  364. </div>
  365. </div>
  366. </div>
  367. </footer>
  368. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!