API tools faq
paste
Advertisement
Guest User

phpdingen

a guest
May 21st, 2019
69
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.51 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. declare (strict_types = 1);
  3. require "includes/header.php";
  4. ?>
  5. <!DOCTYPE html>
  6. <html>
  7.  
  8. <head>
  9.     <meta charset="utf-8">
  10.     <meta name="viewport" content="width=device-width, initial-scale=1.0, shrink-to-fit=no">
  11.     <title>Rubrieken</title>
  12.     <link rel="stylesheet" href="assets/bootstrap/css/bootstrap.min.css">
  13.     <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Amaranth">
  14.     <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Open+Sans">
  15.     <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Raleway">
  16.     <link rel="stylesheet" href="assets/css/rubrieken.css">
  17. </head>
  18.  
  19. <body>
  20.     <div class="container">
  21.         <div class="row d-flex flex-row">
  22.             <div class="col d-flex flex-column align-items-center">
  23.                 <h1>Alle rubrieken</h1>
  24.             </div>
  25.         </div>
  26.         <div class="row d-flex flex-row mx-auto">
  27.             <div class="col text-capitalize d-flex flex-column">
  28.                 <nav class="d-flex justify-content-center">
  29.                     <ul class="pagination flex-wrap justify-content-around">
  30.                     <?php
  31.                     $query = "SELECT * FROM Rubriek WHERE Rubriek = -1 ORDER BY Volgnr, Rubrieknaam ASC";
  32.                     $temp_char = "";
  33.                     $alphabet = range('A', 'Z');
  34.                     $stmt = $dbh->prepare($query);
  35.                     $stmt->execute();
  36.                     $result = $stmt->fetchAll();
  37.                     foreach($result as $row) {
  38.                         $rubrieknaam = $row["Rubrieknaam"];
  39.                         $eerste_letter = $rubrieknaam[0];
  40.                         $eerste_letter = strtoupper($eerste_letter);
  41.                         if($temp_char != $eerste_letter) {
  42.                             $temp_char = $eerste_letter;
  43.                             $db_alphabet[] = $temp_char;
  44.                         }
  45.                     }
  46.                     $alphabet_length = count($alphabet);
  47.                     for ($i = 0; $i < $alphabet_length; $i++) {
  48.  
  49.                         if(in_array($alphabet[$i], $db_alphabet)) {
  50.                             echo "<li class='page-item'><a class='page-link' href='#".$alphabet[$i]."'>".$alphabet[$i]."</a></li>";
  51.                         } else {
  52.                             echo "<li class='alphabet-false'>".$alphabet[$i]."</li>";
  53.                         }
  54.                     }
  55.                         ?>
  56.                     </ul>
  57.                 </nav>
  58.             </div>
  59.         </div>
  60.         <?php
  61. $query     = "SELECT * FROM
  62. (SELECT * , left(Rubrieknaam,1) AS letter FROM rubriek WHERE Rubriek = -1) a
  63. inner join
  64. (select count(left(rubrieknaam,1)) as aantal, left(rubrieknaam, 1) as eerste_letter from Rubriek where Rubriek = -1 group by left(rubrieknaam,1)) b
  65. on b.eerste_letter = a.letter order by 2";
  66. $stmt      = $dbh->prepare($query);
  67. $stmt->execute();
  68. $result = $stmt->fetchAll();
  69. echo "";//////////////////////begin
  70. $temp_char = "";
  71. $counter;
  72. foreach ($result as $root) {
  73.   $rubrieknaam   = $root["Rubrieknaam"];
  74.   $rubrieknummer = $root["Rubrieknummer"];
  75.   $eerste_letter = $rubrieknaam[0];
  76.   if ($temp_char != $eerste_letter) {
  77.     $counter = 0;
  78.     echo "<div class='row d-flex flex-row flex-nowrap'>
  79.    <div class='col-auto text-center d-flex flex-column align-self-start' id='$eerste_letter'>
  80.        <p>$eerste_letter</p>
  81.        <div></div>
  82.    </div><div class='col'>";/////////////////////////eerste van letter
  83.     $temp_char = $eerste_letter;
  84.   }
  85.   $counter ++;
  86.   echo "<div class='d-flex flex-column'>
  87.      <h1><a href='rubriek.php?$rubrieknummer'>$rubrieknaam</a></h1>
  88.      <div class='d-flex flex-row flex-wrap'>";
  89.   $rubriekroot   = $root["Rubrieknummer"];
  90.   $query2 = "SELECT * FROM rubriek WHERE rubriek = $rubriekroot ORDER BY Volgnr, Rubrieknaam ASC";
  91.   $stmt2  = $dbh->prepare($query2);
  92.   $stmt2->execute();
  93.   $result2 = $stmt2->fetchAll();
  94.   foreach ($result2 as $sub) {
  95.     $subnummer = $sub["Rubrieknummer"];
  96.     $subnaam  = $sub['Rubrieknaam'];
  97.  
  98.     echo "<h2><a href='rubriek.php?$subnummer'>$subnaam</a></h2> <br />";/////////////////////////////producten
  99.   }
  100.   echo "</div>
  101. </div>";
  102.   $aantal_letters = $root["aantal"];
  103.   if ($counter == $aantal_letters) {
  104.     echo "</div>
  105. </div>";/////////////////////////////einde van letter
  106.   }
  107. }
  108. ?>
  109.     </div>
  110.     <script src="assets/js/jquery.min.js"></script>
  111.     <script src="assets/bootstrap/js/bootstrap.min.js"></script>
  112.  
  113. </body>
  114. <?php
  115. include "includes/footer.php";
  116. ?>
  117.  
  118.  
  119. </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!