API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 24th, 2016
102
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.07 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE html>
  2. <?php
  3. session_start();
  4. include("LoguitButton.php");
  5. ?>
  6. <html lang="en">
  7. <head>
  8. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  9. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-alpha.5/css/bootstrap.min.css" integrity="sha384-AysaV+vQoT3kOAXZkl02PThvDr8HYKPZhNT5h/CXfBThSRXQ6jW5DO2ekP5ViFdi" crossorigin="anonymous">
  10. <link href="styles.css" rel="stylesheet">
  11. <script src="platform.js"></script>
  12. <script src="jquery.min.js"></script>
  13. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-alpha.5/js/bootstrap.min.js" integrity="sha384-BLiI7JTZm+JWlgKa0M0kGRpJbF2J8q+qreVrKBC47e3K6BW78kGLrCkeRX6I9RoK" crossorigin="anonymous"></script>
  14. <meta name="viewport" content="width=device-width, initial-scale=1">
  15. <title>Hardware Project 2016</title>
  16. </head>
  17. <header>
  18. <nav class="navbar">
  19. <ul class="nav nav-pills" role="tablist">
  20. <li class="nav-item">
  21. <a class="nav-link" href="" role="navigation"><b>Home</b></a>
  22. </li>
  23. <li class="nav-item">
  24. <a class="nav-link" href="toevoegen.php" role="navigation"><b>Toevoegen/Wijzigen</b></a>
  25. </li>
  26. <?php echo $Uitlog; echo $NaamProfiel; ?>
  27. <div class="navbar-brand">
  28. <b>Hardware Project 2016.</b>
  29. </div>
  30. </ul>
  31. </nav>
  32. </header>
  33. <body>
  34. <center>
  35.  
  36. </center>
  37. <div class="row-eq-height">
  38. <div class="col-sm-1">
  39. </div>
  40. <div class="col-sm-2">
  41. <?php
  42. $servername = "localhost";
  43. $username = "root";
  44. $password = "";
  45. $dbname = "project_hardware";
  46.  
  47. $conn = new mysqli($servername, $username, $password, $dbname);
  48.  
  49. if ($conn->connect_error) {
  50. die("Connection failed: " . $conn->connect_error);
  51. }
  52. error_reporting(0);
  53. ?>
  54. <div class="searching">
  55. <b>Filter:</b><br>
  56. <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
  57. <input type="text" class="form-control" name="searchO" placeholder="Zoeken in Onderdeel">
  58.  
  59. <input type="text" class="form-control"name="searchP" placeholder="Zoeken in Plek">
  60. <br>
  61. <b> Sorteer op:</b><br>
  62. <select name="sort" class="form-control filterr">
  63. <option value="Onderdeel A-Z">Onderdeel A-Z</option>
  64. <option value="Onderdeel Z-A">Onderdeel Z-A</option>
  65. <option value="Plek A-Z">Plek A-Z</option>
  66. <option value="Plek Z-A">Plek Z-A</option>
  67. <option value="UitgeleendA-Z">Uitgeleend A-Z</option>
  68. <option value="UitgeleendZ-A">Uitgeleend Z-A</option>
  69. <option value="Aantal0-9">Aantal 0-9</option>
  70. <option value="Aantal9-0">Aantal 9-0</option>
  71. <option value="Voorraad">Voorraad</option>
  72. </select><br>
  73.  
  74. <button type="submit" class="btn btn-primary"> Weergeven </button>
  75. </form><br>
  76. A = Available<br>
  77. N = Not Available
  78. </div>
  79. </div>
  80. <div class="col-sm-8">
  81. <?php
  82. $searchO = $_POST['searchO'];
  83. $searchP = $_POST['searchP'];
  84. $sort = $_POST['sort'];
  85. ?>
  86. <b style="font-size: 20px;">U heeft momenteel de tabel gesorteerd op:</b> &nbsp; <b style="text-decoration: underline; font-size: 20px;"><?php echo $sort; ?></b><br>
  87. <?php
  88. if (isset ($_POST['sort'])) {
  89. switch ($_POST['sort']) {
  90. case "Onderdeel A-Z":
  91. if ((isset($_POST['searchO']) == "%") && (isset($_POST['searchP'])) == "%") {
  92. $sql = "SELECT Onderdeel, Plek, Uitgeleend, Datum, Tijdstip, Status, Aantal FROM gegevens WHERE Onderdeel LIKE '%$searchO%' AND Plek LIKE '%$searchP%' ORDER BY Onderdeel ASC";
  93. $result = $conn->query($sql);
  94.  
  95. if ($result->num_rows > 0) {
  96. echo "<table class='table table-hover table-striped'><thead class='thead-inverse'><tr><th class='Status'></th><th>Onderdeel</th><th>Plek</th><th class='Aantal'>Aantal</th><th>Uitgeleend aan</th><th>Datum</th><th>Tijdstip</th></tr></thead>";
  97. while ($row = $result->fetch_assoc()) {
  98. echo "<tr><td>" . $row["Status"] . "</td><td>" . $row["Onderdeel"] . "</td><td>" . $row["Plek"] . "</td><td>" . $row["Aantal"] . "</td><td>" . $row["Uitgeleend"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Tijdstip"] . "</td></tr>";
  99. }
  100. echo "</table>";
  101.  
  102. } else {
  103. echo "<br><div class='Resultaat'><b>Geen resultaten</b></div>";
  104. }
  105.  
  106. }
  107. break;
  108. case "Onderdeel Z-A":
  109. if ((isset($_POST['searchO']) == "%") && (isset($_POST['searchP'])) == "%") {
  110. $sql = "SELECT Onderdeel, Plek, Uitgeleend, Datum, Tijdstip, Status, Aantal FROM gegevens WHERE Onderdeel LIKE '%$searchO%' AND Plek LIKE '%$searchP%' ORDER BY Onderdeel DESC";
  111. $result = $conn->query($sql);
  112.  
  113. if ($result->num_rows > 0) {
  114. echo "<table class='table table-striped'><thead class='thead-inverse'><tr><th class='Status'></th><th>Onderdeel</th><th>Plek</th><th class='Aantal'>Aantal</th><th>Uitgeleend aan</th><th>Datum</th><th>Tijdstip</th></tr></thead>";
  115. while ($row = $result->fetch_assoc()) {
  116. echo "<tr><td>" . $row["Status"] . "</td><td>" . $row["Onderdeel"] . "</td><td>" . $row["Plek"] . "</td><td>" . $row["Aantal"] . "</td><td>" . $row["Uitgeleend"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Tijdstip"] . "</td></tr>";
  117. }
  118. echo "</table>";
  119. } else {
  120. echo "<br><div class='Resultaat'><b>Geen resultaten</b></div>";
  121. }
  122.  
  123. }
  124. break;
  125. case "Plek A-Z":
  126. if ((isset($_POST['searchO']) == "%") && (isset($_POST['searchP'])) == "%") {
  127. $sql = "SELECT Onderdeel, Plek, Uitgeleend, Datum, Tijdstip, Status, Aantal FROM gegevens WHERE Onderdeel LIKE '%$searchO%' AND Plek LIKE '%$searchP%' ORDER BY Plek ASC";
  128. $result = $conn->query($sql);
  129.  
  130. if ($result->num_rows > 0) {
  131. echo "<table class='table table-striped'><thead class='thead-inverse'><tr><th class='Status'></th><th>Onderdeel</th><th>Plek</th><th class='Aantal'>Aantal</th><th>Uitgeleend aan</th><th>Datum</th><th>Tijdstip</th></tr></thead>";
  132. while ($row = $result->fetch_assoc()) {
  133. echo "<tr><td>" . $row["Status"] . "</td><td>" . $row["Onderdeel"] . "</td><td>" . $row["Plek"] . "</td><td>" . $row["Aantal"] . "</td><td>" . $row["Uitgeleend"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Tijdstip"] . "</td></tr>";
  134. }
  135. echo "</table>";
  136. } else {
  137. echo "<br><div class='Resultaat'><b>Geen resultaten</b></div>";
  138. }
  139. }
  140. break;
  141. case "Plek Z-A":
  142. if ((isset($_POST['searchO']) == "%") && (isset($_POST['searchP'])) == "%") {
  143. $sql = "SELECT Onderdeel, Plek, Uitgeleend, Datum, Tijdstip, Status, Aantal FROM gegevens WHERE Onderdeel LIKE '%$searchO%' AND Plek LIKE '%$searchP%' ORDER BY Plek DESC";
  144. $result = $conn->query($sql);
  145.  
  146. if ($result->num_rows > 0) {
  147. echo "<table class='table table-striped'><thead class='thead-inverse'><tr><th class='Status'></th><th>Onderdeel</th><th>Plek</th><th class='Aantal'>Aantal</th><th>Uitgeleend aan</th><th>Datum</th><th>Tijdstip</th></tr></thead>";
  148. while ($row = $result->fetch_assoc()) {
  149. echo "<tr><td>" . $row["Status"] . "</td><td>" . $row["Onderdeel"] . "</td><td>" . $row["Plek"] . "</td><td>" . $row["Aantal"] . "</td><td>" . $row["Uitgeleend"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Tijdstip"] . "</td></tr>";
  150. }
  151. echo "</table>";
  152. } else {
  153. echo "<br><div class='Resultaat'><b>Geen resultaten</b></div>";
  154. }
  155. }
  156. break;
  157. case "UitgeleendA-Z":
  158. if ((isset($_POST['searchO']) == "%") && (isset($_POST['searchP'])) == "%") {
  159. $sql = "SELECT Onderdeel, Plek, Uitgeleend, Datum, Tijdstip, Status, Aantal FROM gegevens WHERE Onderdeel LIKE '%$searchO%' AND Plek LIKE '%$searchP%' ORDER BY Uitgeleend ASC";
  160. $result = $conn->query($sql);
  161.  
  162. if ($result->num_rows > 0) {
  163. echo "<table class='table table-striped'><thead class='thead-inverse'><tr><th class='Status'></th><th>Onderdeel</th><th>Plek</th><th class='Aantal'>Aantal</th><th>Uitgeleend aan</th><th>Datum</th><th>Tijdstip</th></tr></thead>";
  164. while ($row = $result->fetch_assoc()) {
  165. echo "<tr><td>" . $row["Status"] . "</td><td>" . $row["Onderdeel"] . "</td><td>" . $row["Plek"] . "</td><td>" . $row["Aantal"] . "</td><td>" . $row["Uitgeleend"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Tijdstip"] . "</td></tr>";
  166. }
  167. echo "</table>";
  168. } else {
  169. echo "<br><div class='Resultaat'><b>Geen resultaten</b></div>";
  170. }
  171. }
  172. break;
  173. case "UitgeleendZ-A":
  174. if ((isset($_POST['searchO']) == "%") && (isset($_POST['searchP'])) == "%") {
  175. $sql = "SELECT Onderdeel, Plek, Uitgeleend, Datum, Tijdstip, Status, Aantal FROM gegevens WHERE Onderdeel LIKE '%$searchO%' AND Plek LIKE '%$searchP%' ORDER BY Uitgeleend DeSC";
  176. $result = $conn->query($sql);
  177.  
  178. if ($result->num_rows > 0) {
  179. echo "<table class='table table-striped'><thead class='thead-inverse'><tr><th class='Status'></th><th class='Onder'>Onderdeel</th><th>Plek</th><th class='Aantal'>Aantal</th><th class='UitAan'>Uitgeleend aan</th><th class='Datumm'>Datum</th><th>Tijdstip</th></tr></thead>";
  180. while ($row = $result->fetch_assoc()) {
  181. echo "<tr><td>" . $row["Status"] . "</td><td>" . $row["Onderdeel"] . "</td><td>" . $row["Plek"] . "</td><td>" . $row["Aantal"] . "</td><td>" . $row["Uitgeleend"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Tijdstip"] . "</td></tr>";
  182. }
  183. echo "</table>";
  184. } else {
  185. echo "<br><div class='Resultaat'><b>Geen resultaten</b></div>";
  186. }
  187. }
  188. break;
  189. case "Aantal0-9":
  190. if ((isset($_POST['searchO']) == "%") && (isset($_POST['searchP'])) == "%") {
  191. $sql = "SELECT Onderdeel, Plek, Uitgeleend, Datum, Tijdstip, Status, Aantal FROM gegevens WHERE Onderdeel LIKE '%$searchO%' AND Plek LIKE '%$searchP%' ORDER BY Aantal ASC";
  192. $result = $conn->query($sql);
  193.  
  194. if ($result->num_rows > 0) {
  195. echo "<table class='table table-striped'><thead class='thead-inverse'><tr><th class='Status'></th><th>Onderdeel</th><th>Plek</th><th class='Aantal'>Aantal</th><th>Uitgeleend aan</th><th>Datum</th><th>Tijdstip</th></tr></thead>";
  196. while ($row = $result->fetch_assoc()) {
  197. echo "<tr><td>" . $row["Status"] . "</td><td>" . $row["Onderdeel"] . "</td><td>" . $row["Plek"] . "</td><td>" . $row["Aantal"] . "</td><td>" . $row["Uitgeleend"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Tijdstip"] . "</td></tr>";
  198. }
  199. echo "</table>";
  200. } else {
  201. echo "<br><div class='Resultaat'><b>Geen resultaten</b></div>";
  202. }
  203. }
  204. break;
  205. case "Aantal9-0":
  206. if ((isset($_POST['searchO']) == "%") && (isset($_POST['searchP'])) == "%") {
  207. $sql = "SELECT Onderdeel, Plek, Uitgeleend, Datum, Tijdstip, Status, Aantal FROM gegevens WHERE Onderdeel LIKE '%$searchO%' AND Plek LIKE '%$searchP%' ORDER BY Aantal DESC";
  208. $result = $conn->query($sql);
  209.  
  210. if ($result->num_rows > 0) {
  211. echo "<table class='table table-striped'><thead class='thead-inverse'><tr><th class='Status'></th><th>Onderdeel</th><th>Plek</th><th class='Aantal'>Aantal</th><th>Uitgeleend aan</th><th>Datum</th><th>Tijdstip</th></tr></thead>";
  212. while ($row = $result->fetch_assoc()) {
  213. echo "<tr><td>" . $row["Status"] . "</td><td>" . $row["Onderdeel"] . "</td><td>" . $row["Plek"] . "</td><td>" . $row["Aantal"] . "</td><td>" . $row["Uitgeleend"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Tijdstip"] . "</td></tr>";
  214. }
  215. echo "</table>";
  216. } else {
  217. echo "<br><div class='Resultaat'><b>Geen resultaten</b></div>";
  218. }
  219. }
  220. break;
  221. case "Voorraad":
  222. if ((isset($_POST['searchO']) == "%") && (isset($_POST['searchP'])) == "%") {
  223. $sql = "SELECT Onderdeel, Plek, Uitgeleend, Datum, Tijdstip, Status, Aantal FROM gegevens WHERE Onderdeel LIKE '%$searchO%' AND Plek LIKE '%$searchP%' ORDER BY Aantal DESC";
  224. $result = $conn->query($sql);
  225.  
  226. if ($result->num_rows > 0) {
  227. echo "<table class='table table-striped'><thead class='thead-inverse'><tr><th class='Status'></th><th>Onderdeel</th><th>Plek</th><th class='Aantal'>Aantal</th><th>Uitgeleend aan</th><th>Datum</th><th>Tijdstip</th></tr></thead>";
  228. while ($row = $result->fetch_assoc()) {
  229. echo "<tr><td>" . $row["Status"] . "</td><td>" . $row["Onderdeel"] . "</td><td>" . $row["Plek"] . "</td><td>" . $row["Aantal"] . "</td><td>" . $row["Uitgeleend"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Tijdstip"] . "</td></tr>";
  230. }
  231. echo "</table>";
  232. } else {
  233. echo "<br><div class='Resultaat'><b>Geen resultaten</b></div>";
  234. }
  235. }
  236. break;
  237. default:
  238. $sql = "SELECT Onderdeel, Plek, Uitgeleend, Datum, Tijdstip, Status, Aantal FROM gegevens WHERE Onderdeel LIKE '%$searchO%' AND Plek LIKE '%$searchP%' ORDER BY Onderdeel ASC";
  239. $result = $conn->query($sql);
  240.  
  241. if ($result->num_rows > 0) {
  242. echo "<table class='table table-striped'><thead class='thead-inverse'><tr><th class='Status'></th><th>Onderdeel</th><th>Plek</th><th class='Aantal'>Aantal</th><th>Uitgeleend aan</th><th>Datum</th><th>Tijdstip</th></tr></thead>";
  243. while ($row = $result->fetch_assoc()) {
  244. echo "<tr><td>" . $row["Status"] . "</td><td>" . $row["Onderdeel"] . "</td><td>" . $row["Plek"] . "</td><td>" . $row["Aantal"] . "</td><td>" . $row["Uitgeleend"] . "</td><td>" . $row["Datum"] . "</td><td>" . $row["Tijdstip"] . "</td></tr>";
  245. }
  246. echo "</table>";
  247. } else {
  248. echo "<br><div class='Resultaat'><b>Geen resultaten</b></div>";
  249. }
  250. }
  251. break;
  252. }
  253. ?>
  254. </div>
  255. <div class="col-sm-1">
  256. </div>
  257. </div>
  258. </body>
  259. <footer>
  260. <div class="copyright">
  261. <p class="text-muted">Made by Thijs van Verseveld en Corwin Kruijf.</p>
  262. </div>
  263. </footer>
  264. </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!