Guest User

ripples

a guest
Nov 22nd, 2016
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.41 KB | None | 0 0
  1. <?php
  2. function connectDB() {
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "";
  6. $dbname = "tappw";
  7.  
  8. // Create connection
  9. $conn = mysqli_connect($servername, $username, $password, $dbname);
  10.  
  11. // Check connection
  12. if (!$conn) {
  13. die("Connection failed: " + mysqli_connect_error());
  14. }
  15. return $conn;
  16. }
  17.  
  18. function selectAllFromTableBook($table) {
  19. $conn = connectDB();
  20.  
  21. $sql = "SELECT img_path, title, author,publisher,quantity FROM $table";
  22.  
  23. if(!$result = mysqli_query($conn, $sql)) {
  24. die("Error: $sql");
  25. }
  26. mysqli_close($conn);
  27. return $result;
  28. }
  29.  
  30. if ($_SERVER['REQUEST_METHOD'] === 'POST') {
  31. if($_POST['command'] === 'insert') {
  32. insertUser();
  33. } else if($_POST['command'] === 'update') {
  34. updateUser($_POST['userid']);
  35. } else if($_POST['command'] === 'delete') {
  36. deleteUser($_POST['userid']);
  37. }
  38. }
  39.  
  40. ?>
  41.  
  42. <!DOCTYPE html>
  43. <html lang="id">
  44. <head>
  45. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
  46. <link rel="stylesheet" type="text/css" href="//fonts.googleapis.com/css?family=Roboto:300,400,500,700">
  47. <link rel="stylesheet" type="text/css" href="//fonts.googleapis.com/icon?family=Material+Icons">
  48. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  49. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  50. <link rel="stylesheet" type="text/css" href="libs/bootstrap-material-design/dist/css/bootstrap-material-design.css">
  51. <link rel="stylesheet" type="text/css" href="libs/bootstrap-material-design/dist/css/ripples.css">
  52. <script type="text/javascript" src="libs/bootstrap-material-design/dist/js/material.js"></script>
  53. <script type="text/javascript" src="libs/bootstrap-material-design/dist/js/ripples.js"></script>
  54.  
  55. <script type="text/javascript">
  56. $.material.init();
  57. $.material.input();
  58.  
  59. </script>
  60. <link rel="stylesheet" type="text/css" href="src/css/style.css">
  61. <meta charset="utf-8">
  62. <title>PerpusOnline.com | Baca Buku ? Disini aja !</title>
  63. </head>
  64. <body>
  65.  
  66.  
  67. <div class="navbar navbar-default">
  68. <div class="container-fluid">
  69. <div class="navbar-header">
  70. <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-responsive-collapse">
  71. <span class="icon-bar"></span>
  72. <span class="icon-bar"></span>
  73. <span class="icon-bar"></span>
  74. </button>
  75. <a class="navbar-brand" href="javascript:void(0)">PerpusOnline.com</a>
  76. </div>
  77. <div class="navbar-collapse collapse navbar-responsive-collapse">
  78. <form class="navbar-form navbar-left">
  79. <div class="form-group">
  80. <input type="text" class="form-control col-md-8" placeholder="Search">
  81. </div>
  82. </form>
  83. <ul class="nav navbar-nav navbar-right">
  84. <li><a href="login.php">Log In</a></li>
  85. <li><a href="javascript:void(0)">Sign Up</a></li>
  86. </li>
  87. </ul>
  88. </div>
  89. </div>
  90. </div>
  91.  
  92. <div class="jumbotron">
  93. <h1 id="perpus">PerpusOnline.com</h1>
  94. <p id="descPerpus" class="text-primary">Baca Buku ? Disini aja !</p>
  95. </div>
  96.  
  97. <div class="container-fluid">
  98. <div class="tableBook">
  99. <table class="table table-striped table-hover table-bordered">
  100. <thead>
  101. <tr class="success">
  102. <th class="head">Buku</th>
  103. <th class="head">Judul</th>
  104. <th class="head">Pengarang</th>
  105. <th class="head">Penerbit</th>
  106. <th class="head">Jumlah</th>
  107. <th class="head">Action</th>
  108. </tr>
  109. </thead>
  110. <tbody >
  111. <?php
  112.  
  113. $books = selectAllFromTableBook("book");
  114.  
  115. while ($row = mysqli_fetch_row($books)) {
  116.  
  117.  
  118. echo "<tr class='info'>";
  119. foreach($row as $key => $value) {
  120. if ($key == 'img_path') {
  121. echo "<td>
  122.  
  123. <a href='$value' data-toggle='tooltip' title='Click to See Book Image' ><img data-toggle='modal' data-target='#myModal' src='$value' alt='gambar buku' height='150' width='100'/></a>
  124.  
  125.  
  126. </td>";
  127. //echo "<td><img src='$value' alt='gambar buku' height='150' width='100'/></td>";
  128. }
  129. else {
  130. echo "<td>$value</td>";
  131. }
  132. }
  133. echo '<td>
  134. <form action="tutorial.php" method="post">
  135. <input type="hidden" id="delete-userid" name="userid" value="'.$row[0].'">
  136. <input type="hidden" id="delete-command" name="command" value="delete">
  137. <button type="submit" class="btn btn-raised btn-primary">PINJAM</button>
  138.  
  139. <input type="hidden" id="delete-userid" name="userid" value="'.$row[0].'">
  140. <input type="hidden" id="delete-command" name="command" value="delete">
  141. <button type="submit" class="btn btn-raised btn-primary">DETAILS</button>
  142. </form>
  143. </td>';
  144. echo "</tr>";
  145. }
  146. ?>
  147. </tbody>
  148. </table>
  149. </div>
  150. </div>
  151.  
  152.  
  153.  
  154.  
  155.  
  156. </body>
  157. </html>
Add Comment
Please, Sign In to add comment