Advertisement
wildanfuady

List Student

Nov 13th, 2019
181
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.41 KB | None | 0 0
  1. <?php
  2.  
  3. require_once('db.php');
  4.  
  5. $sql = "SELECT * FROM students";
  6.  
  7. // Membuat function paginate
  8. $result = $conn->query($sql);
  9.  
  10. $students = [];
  11.  
  12. while($row = $result->fetch_assoc()){
  13. $students[] = $row;
  14. }
  15.  
  16. ?>
  17.  
  18. <!DOCTYPE html>
  19. <html lang="en">
  20. <head>
  21. <meta charset="UTF-8">
  22. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  23. <meta http-equiv="X-UA-Compatible" content="ie=edge">
  24. <title>List Student</title>
  25. <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css">
  26. <link rel="stylesheet" href="fontawesome/css/all.min.css">
  27. </head>
  28. <body>
  29. <div class="mt-5">
  30. <div class="col-md-12">
  31. <div class="container">
  32. <div class="row">
  33. <div class="col-md-12">
  34. <div class="table-responsive">
  35. <table class="table table-bordered table-hovered">
  36. <thead>
  37. <tr>
  38. <th width="5%">No</th>
  39. <th>Name</th>
  40. <th width="20%">No Hp</th>
  41. <th width="10%">Gender</th>
  42. <th width="15%">Jenjang</th>
  43. <th width="15%">Hobi</th>
  44. <th width="10%">Action</th>
  45. </tr>
  46. </thead>
  47. <tbody>
  48. <?php foreach($students as $k => $student) { ?>
  49. <tr>
  50. <td><?= $k + 1 ?></td>
  51. <td><?= $student['nama_depan']." ".$student['nama_belakang'] ?></td>
  52. <td><?= $student['no_hp'] ?></td>
  53. <td><?= $student['gender'] ?></td>
  54. <td><?= $student['jenjang'] ?></td>
  55. <td><?= $student['hobi'] ?></td>
  56. <td>
  57. <div class="btn-group">
  58. <a href="" class="btn btn-primary btn-sm"><i class="fa fa-eye"></i></a>
  59. <a href="" class="btn btn-success btn-sm"><i class="fa fa-edit"></i></a>
  60. <a href="" class="btn btn-danger btn-sm"><i class="fa fa-trash-alt"></i></a>
  61. </div>
  62. </td>
  63. </tr>
  64. <?php } ?>
  65. </tbody>
  66. </table>
  67. </div>
  68. </div>
  69. </div>
  70.  
  71. </div>
  72. </div>
  73. </div>
  74. <!-- Page Script -->
  75. <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
  76. <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script>
  77. <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
  78. </body>
  79. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement