Advertisement
Guest User

data ajax

a guest
Apr 23rd, 2019
254
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.91 KB | None | 0 0
  1. <?php
  2.  
  3. require 'data_koneksi.php';
  4.  
  5. extract($_GET);
  6.  
  7. if (isset($_GET['pageData'])) {
  8.  
  9.     $pageAktif = $_GET['pageData'];
  10.     $jumpageTampilkan = 3;
  11.     $pageMulai = ($pageAktif - 1) * $jumpageTampilkan;
  12.  
  13.         $sql = "SELECT * FROM data LIMIT $pageMulai, $jumpageTampilkan";
  14.  
  15.         $query = $conn->query($sql);
  16.  
  17.         $table = '';
  18.         $id = 1;
  19.         foreach($query as $rows) {
  20.  
  21.         $table .= '<tr>
  22.  
  23.           <td>'. $id++ .'</td>;
  24.           <td>'. $rows['nama']. '</td>;
  25.           <td> <img src="'. $rows['gambar'].'" width="50px" height="50px" class="rounded-circle"> </td>;
  26.           <td>'. $rows['status']. '</td>;
  27.           <td> <button class="btn btn-success" data-target="#updateData" data-toggle="modal" onclick="ubahData('.$rows['id'].')"> Edit </button></td>;
  28.           <td> <button class="btn btn-danger" onclick="hapusData('.$rows['id'].')"> Hapus </button></td>;
  29.  
  30.           </tr>';
  31.         }
  32.  
  33.       echo $table;
  34.  
  35.   }
  36.  
  37.  else {
  38.  
  39.      1;
  40.  }
  41.  
  42.  $conn->close();
  43.  
  44. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement