API tools faq
paste
Advertisement
LeBizu2561

Deni

LeBizu2561
Aug 7th, 2023
12
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.44 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE html>
  2. <html lang="en">
  3.  
  4. <head>
  5. <meta charset="UTF-8">
  6. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  7. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  8. <title>Data Karyawan</title>
  9.  
  10. <style>
  11. /* Gaya tampilan tabel */
  12. table {
  13. border-collapse: collapse;
  14. width: 100%;
  15. }
  16.  
  17. th,
  18. td {
  19. border: 1px solid #dddddd;
  20. text-align: left;
  21. padding: 8px;
  22. }
  23.  
  24. th {
  25. background-color: #f2f2f2;
  26. }
  27.  
  28. tr:hover {
  29. background-color: #f5f5f5;
  30. }
  31.  
  32. .taksi {
  33. display: flex;
  34. justify-content: flex-end;
  35. }
  36.  
  37. .navbar {
  38. justify-content: space-between;
  39. }
  40.  
  41. .search-form {
  42. display: flex;
  43. align-items: center;
  44. }
  45.  
  46. .search-input {
  47. margin-left: 350px;
  48. }
  49. </style>
  50.  
  51. <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.1/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-4bw+/aepP/YC94hEpVNVgiZdgIC5+VKNBQNGCHeKRQN+PtmoHDEXuppvnDJzQIu9" crossorigin="anonymous">
  52. <link href="https://cdn.datatables.net/v/bs5/jq-3.7.0/dt-1.13.6/datatables.min.css" rel="stylesheet">
  53. <script src="https://cdn.datatables.net/v/bs5/jq-3.7.0/dt-1.13.6/datatables.min.js">
  54. </script>
  55. </head>
  56.  
  57. <script>
  58. $(document).ready(function() {
  59. $('#myTable').dataTable();
  60. });
  61. </script>
  62.  
  63. <body>
  64. <nav class="navbar navbar-expand-lg bg-body-tertiary">
  65. <div class="container-fluid">
  66. <img src="logo-lbe.png" alt="Bootstrap" width="50" height="50">
  67. <a class="navbar-brand" href="#">PT Lestari Banten Energi</a>
  68. <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
  69. <span class="navbar-toggler-icon"></span>
  70. </button>
  71. <form class="search-form d-flex" role="search">
  72. <input class="form-control me-2 search-input" type="search" style="width: 500px;" placeholder="Search" aria-label="Search">
  73. <button class="btn btn-outline-primary" type="submit">Search</button>
  74. </form>
  75. <ul class="navbar-nav me-auto mb-2 mb-lg-0">
  76. </ul>
  77. </div>
  78. </nav>
  79.  
  80. <div class="container mt-4">
  81. <h2>Data Karyawan</h2>
  82. <?php
  83. $server = "localhost";
  84. $username = "root";
  85. $password = "";
  86. $database = "data_karyawan";
  87.  
  88. $conn = new mysqli($server, $username, $password, $database);
  89.  
  90. if ($conn->connect_error) {
  91. die("Connection failed: " . $conn->connect_error);
  92. }
  93.  
  94. if (isset($_POST['editSubmit'])) {
  95. $editName = $_POST['editName'];
  96. $newName = $_POST['newName'];
  97. $sql = "UPDATE data_karyawan SET Nama='$newName' WHERE Nama='$editName'";
  98. $conn->query($sql);
  99. }
  100.  
  101. if (isset($_GET['delete'])) {
  102. $deleteName = $_GET['delete'];
  103. $sql = "DELETE FROM data_karyawan WHERE Nama='$deleteName'";
  104. $conn->query($sql);
  105. }
  106.  
  107. $phonebookData = [];
  108. $sql = "SELECT * FROM data_karyawan";
  109. $result = $conn->query($sql);
  110.  
  111. if ($result->num_rows > 0) {
  112. while ($row = $result->fetch_assoc()) {
  113. $phonebookData[] = $row;
  114. }
  115. }
  116.  
  117. $conn->close();
  118.  
  119. echo '<table id="myTable" class="table table-striped display">
  120. <thead>
  121. <tr>
  122. <th>Nama</th>
  123. <th>Departemen</th>
  124. <th>Telepon</th>
  125. <th>Aksi</th>
  126. </tr>
  127. </thead>
  128. <tbody>';
  129.  
  130. foreach ($phonebookData as $data) {
  131. echo '<tr>';
  132. echo '<td>' . $data['Nama'] . '</td>';
  133. echo '<td>' . $data['Departemen'] . '</td>';
  134. echo '<td>' . $data['Telepon'] . '</td>';
  135. echo '<td class="aksi">
  136. <button class="btn btn-primary" data-toggle="modal" data-target="#editModal' . $data['Nama'] . '">Edit</button>
  137. <a href="?delete=' . $data['Nama'] . '" class="btn btn-danger ms2">Hapus</a>
  138. </td>';
  139. echo '</tr>';
  140. }
  141.  
  142. echo '</tbody></table>';
  143.  
  144. foreach ($phonebookData as $data) {
  145. echo '<div class="modal fade" id="editModal' . $data['Nama'] . '" tabindex="-1" role="dialog" aria-labelledby="editModalLabel' . $data['Nama'] . '" aria-hidden="true">
  146. <div class="modal-dialog" role="document">
  147. <div class="modal-content">
  148. <div class="modal-header">
  149. <h5 class="modal-title" id="editModalLabel' . $data['Nama'] . '">Edit Data Karyawan</h5>
  150. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  151. <span aria-hidden="true">&times;</span>
  152. </button>
  153. </div>
  154. <div class="modal-body">
  155. <form action="" method="post">
  156. <input type="hidden" name="editName" value="' . $data['Nama'] . '">
  157. <div class="form-group">
  158. <label for="newName">Nama Baru:</label>
  159. <input type="text" class="form-control" id="newName" name="newName" value="' . $data['Nama'] . '" required>
  160. </div>
  161. <button type="submit" class="btn btn-primary" name="editSubmit">Simpan Perubahan</button>
  162. </form>
  163. </div>
  164. </div>
  165. </div>
  166. </div>';
  167. }
  168. ?>
  169. </div>
  170.  
  171. <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.1/dist/js/bootstrap.bundle.min.js" integrity="sha384-HwwvtgBNo3bZJJLYd8oVXjrBZt8cqVSpeBNS5n7C8IVInixGAoxmnlMuBnhbgrkm" crossorigin="anonymous"></script>
  172. </body>
  173.  
  174. </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!