Jual Beli Produk Digital - Cepat, Aman, Dan Terpercaya Sejak 2012 (Ada 70396 Members, 829 Products, 4760 Topic, 13103 Comments)

Mohon bantuan untuk list checkbox hapus data error sms gateway

Dibuat
Login Terakhir 7 Tahun lalu,
Telah Dilihat 1402 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 !!!

Online