Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (67424 Members, 783 Products, 5279 Topic, 12953 Comments)

Mohon bantuan untuk list checkbox hapus data error sms gateway

Dibuat
Login Terakhir 5 Tahun lalu,
Telah Dilihat 1139 Kali
Nian Dwi Christianto SW Mengatakan : Sultan Account
  1. Selamat Sore !
  2.  
  3. <?php
  4. //SourceCode by AndezNET.com
  5. $sesi_username = isset($_SESSION['username']) ? $_SESSION['username'] : NULL;
  6. if ($sesi_username != NULL || !empty($sesi_username) ||$_SESSION['leveluser']=='1' ) {
  7.  
  8. include "../config/koneksi.php";
  9. $data = mysql_query("select * from pbk");
  10. $no = 1;
  11. while($d = mysql_fetch_array($data))
  12.  
  13.  
  14. ?>
  15.  
  16.  
  17.  
  18.  
  19. <div class="span8">
  20. <div class="table-responsive">
  21.  
  22. <table class="table table-striped" cellspacing="0" width="100%">
  23. <thead>
  24. <tr>
  25. <th class="site-footer">HAPUS</th>
  26. <th class="site-footer">NO</th>
  27. <th class="site-footer">FOTO</th>
  28. <th class="site-footer">NO HP</th>
  29. <th class="site-footer">NAMA KONTAK</th>
  30. <th class="site-footer">TGL LAHIR</th>
  31. <th class="site-footer">GROUP</th>
  32. <th class="site-footer"></th>
  33. </tr>
  34. </thead>
  35. <tbody>
  36. <?php
  37. $i = 1;
  38.  
  39. $jml_per_halaman = 7; // jumlah data yg ditampilkan perhalaman
  40. $jml_data = mysqli_num_rows(mysqli_query($mysqli,"SELECT a.ID,a.Name,a.Number,a.Foto,a.tgl_lahir, b.NameGroup as NameGroup FROM pbk a
  41. LEFT JOIN pbk_groups b on a.GroupID=b.GroupID
  42. order by a.Name ASC"));
  43.  
  44. $jml_halaman = ceil($jml_data / $jml_per_halaman);
  45. // query pada saat mode pencarian
  46. if(isset($_POST['cari'])) {
  47. $kunci = $_POST['cari'];
  48. echo "<strong>Hasil pencarian untuk kata kunci $kunci</strong>";
  49. $query = mysqli_query($mysqli,"
  50. SELECT a.ID,a.Name,a.Number,a.Foto,a.tgl_lahir, b.NameGroup as NameGroup FROM pbk a
  51. LEFT JOIN pbk_groups b on a.GroupID=b.GroupID
  52. WHERE a.Name LIKE '%$kunci%'
  53. OR a.Number LIKE '%$kunci%'
  54. order by a.Name ASC
  55. ");
  56. // query jika nomor halaman sudah ditentukan
  57. } elseif(isset($_POST['halaman'])) {
  58. $halaman = $_POST['halaman'];
  59. $i = ($halaman - 1) * $jml_per_halaman + 1;
  60. $query = mysqli_query($mysqli,"SELECT a.ID,a.Name,a.Number,a.tgl_lahir,a.Foto, b.NameGroup as NameGroup FROM pbk a
  61. LEFT JOIN pbk_groups b on a.GroupID=b.GroupID
  62. order by a.Name DESC LIMIT ".(($halaman - 1) * $jml_per_halaman).", $jml_per_halaman");
  63. // query ketika tidak ada parameter halaman maupun pencarian
  64. } else {
  65. $query = mysqli_query($mysqli,"SELECT a.ID,a.Name,a.Number,a.Foto,a.tgl_lahir, b.NameGroup as NameGroup FROM pbk a
  66. LEFT JOIN pbk_groups b on a.GroupID=b.GroupID
  67. order by a.Name DESC LIMIT 0, $jml_per_halaman");
  68. $halaman = 1; //tambahan
  69. }
  70.  
  71. while($data = mysqli_fetch_array($query)){
  72.  
  73.  
  74. ?>
  75.  
  76.  
  77. <tr>
  78. <td><input type="checkbox" name="pilih[]" value="<?php echo $d['id']; ?>"></td>
  79. <td><?php echo $i ?></td>
  80. <td><img src="<?php echo $data['Foto'] ?>" height="50" width="50"></td>
  81. <td><?php echo $data['Number'] ?></td>
  82. <td><?php echo $data['Name'] ?></td>
  83. <td><?php echo $data['tgl_lahir'] ?></td>
  84. <td><?php echo $data['NameGroup'] ?></td>
  85. <td><div class="btn-group">
  86. <button type="button" class="btn btn-warning dropdown-toggle" data-toggle="dropdown">
  87. Action <span class="caret"></span>
  88. </button>
  89. <ul class="dropdown-menu" role="menu">
  90. <li>
  91. <a data-toggle="modal" id="<?php echo $data['ID'] ?>" class="balaspesan" data-target="#dialog-balaspesan">
  92. <i class="fa fa-envelope"> Balas Pesan</i></a>
  93. </li>
  94. <li>
  95. <a data-toggle="modal" id="<?php echo $data['ID'] ?>" class="ubah" data-target="#dialog-pb">
  96. <i class="fa fa-edit"> Edit</i></a>
  97. </li>
  98. <li>
  99. <a href="?id=pb&mod=del&idpbk=<?php echo $data['ID'] ?>" onclick="return confirm('Menghapus Phonebook <?php echo $data['Name'] ?>')"><i class="glyphicon glyphicon-trash"></i> Hapus</a>
  100. </li>
  101.  
  102. </ul>
  103. </div>
  104. </td>
  105.  
  106. </tr>
  107.  
  108.  
  109. </div>
  110. <?php
  111. $i++;
  112. }
  113. ?>
  114. </tbody>
  115. </table>
  116. </div>
  117. <?php if(!isset($_POST['cari'])) { ?>
  118. <!-- untuk menampilkan menu halaman -->
  119. <div class="pagination">
  120. <ul>
  121.  
  122. <?php
  123.  
  124. // tambahan
  125. // panjang pagig yang akan ditampilkan
  126. $no_hal_tampil = 5; // lebih besar dari 3
  127.  
  128. if ($jml_halaman <= $no_hal_tampil) {
  129. $no_hal_awal = 1;
  130. $no_hal_akhir = $jml_halaman;
  131. } else {
  132. $val = $no_hal_tampil - 3; //3
  133. $mod = $halaman % $val; //
  134. $kelipatan = ceil($halaman/$val);
  135. $kelipatan2 = floor($halaman/$val);
  136.  
  137. if($halaman < $no_hal_tampil) {
  138. $no_hal_awal = 1;
  139. $no_hal_akhir = $no_hal_tampil;
  140. } elseif ($mod == 2) {
  141. $no_hal_awal = $halaman - 1;
  142. $no_hal_akhir = $kelipatan * $val + 2;
  143. } else {
  144. $no_hal_awal = ($kelipatan2 - 1) * $val + 1;
  145. $no_hal_akhir = $kelipatan2 * $val + 2;
  146. }
  147.  
  148. if($jml_halaman <= $no_hal_akhir) {
  149. $no_hal_akhir = $jml_halaman;
  150. }
  151. }
  152.  
  153. for($i = $no_hal_awal; $i <= $no_hal_akhir; $i++) {
  154. // tambahan
  155. // menambahkan class active pada tag li
  156. $aktif = $i == $halaman ? ' active' : '';
  157. ?>
  158. <ul class="pagination">
  159.  
  160. <li class="halaman<?php echo $aktif ?>" id="<?php echo $i ?>"><a href="#"><?php echo $i ?></a></li>
  161.  
  162. </ul>
  163.  
  164. <?php } ?>
  165.  
  166.  
  167. </ul>
  168. </div>
  169. <?php } ?>
  170. <?php
  171. }else{
  172. header('Location:../index.php?status=Silahkan Login');
  173. }
  174. ?>
Ada 1 File Kiriman :
1. error_sms_gateway.JPG (64 KB)

Ada 1 Jawaban

Bukhori Muslim
commented on 20 Jun 2018 17:59:07
  1. Assalam,.. Pesan errornya apa gan?
  2. sepertinya ini script/source code dari kontribusi ya?
  3. dan kita lihat query hapus juga tidak ada pada script di atas,..
  4. bisa di info linknya juga sekalian agar bisa kita/teman2 disini bantu,..
Maaf, Untuk Memberikan Komentar Anda Harus Login !!!