ya2nk

Untitled

May 21st, 2023
1,027
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.88 KB | None | 0 0
  1. <?php
  2.                         $cari = @$_GET['cari'];
  3.                         $batas = 10;
  4.                         $halaman = isset($_GET['halaman'])?(int)$_GET['halaman'] : 1;
  5.                         $halaman_awal = ($halaman>1) ? ($halaman * $batas) - $batas : 0;   
  6.                  
  7.                         $previous = $halaman - 1;
  8.                         $next = $halaman + 1;
  9.                         $sql  = "select * from urf2021 WHERE lower(prihal) LIKE '%".strtolower($cari)."%'";
  10.                         $data = mysqli_query($koneksi,$sql);
  11.  
  12.                 $jumlah_data = mysqli_num_rows($data);
  13.                 $total_halaman = ceil($jumlah_data / $batas);
  14.  
  15.                         $no = 1;
  16.                        
  17.       $query = mysqli_query($koneksi," $sql limit $halaman_awal, $batas");
  18.       $nomor = $halaman_awal+1;
  19.      
  20.                 while($data=mysqli_fetch_array($query))
  21.       {
  22.        
  23.           ?>
Advertisement
Add Comment
Please, Sign In to add comment