Advertisement
yudhaez0212

Untitled

Jan 6th, 2021
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.26 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>PAGINATION DENGAN PHP & MYSQL</title>
  4. </head>
  5. <body>
  6. <h2 align="center">PAGINATION DENGAN PHP & MYSQL</h2>
  7. <table border="1px" align="center" width="80%" >
  8. <tr>
  9. <th>No</th>
  10. <th>NPM</th>
  11. <th>Nama Mahasiswa</th>
  12. <th>Tempat Lahir</th>
  13. <th>Tanggal Lahir</th>
  14. </tr>
  15. <?php
  16. include "koneksi.php";
  17. $batas = 10;
  18. $halaman = isset($_GET['halaman'])?(int)$_GET[''] : 1;
  19. $halaman_awal = ($halaman>1) ? ($halaman * $batas) - $batas : 0;
  20.  
  21. $sebelumnya = $halaman - 1;
  22. $selanjutnya = $halaman + 1;
  23.  
  24. $sql=mysqli_query($koneksi,"SELECT * FROM t_mahasiswa");
  25. $jumlah_data = mysqli_num_rows($sql);
  26. $total_halaman = ceil ($jumlah_data / $batas);
  27.  
  28. $tampil=mysqli_query($koneksi,"SELECT * FORM t_mahasiswa order by nama_mahasiswa ASC limit $halaman_awal, $batas");
  29. $nomor = $halaman_awal+1;
  30. while($data=mysqli_fetch_array($tampil)){
  31.  
  32. ?>
  33.  
  34. <tr>
  35. <td><?=$nomor?></td>
  36. <td><?=$data['npm']?></td>
  37. <td><?=$data['nama_mahasiswa']?></td>
  38. <td><?=$data['tempat_lahir']?></td>
  39. <td><?=date_format(data_create($data['tanggal_lahir']),"d/m/y")?></td>
  40. </tr>
  41. <?php
  42. $nomor++;
  43. }
  44. ?>
  45. </table>
  46. <p align="center">
  47. <a <?php if ($halaman > 1){ echo "href='?halaman=$sebelumnya'"; }?>
  48. >sebelumnya
  49. </a>
  50. <?php
  51. for ($i=1;$i<=$total_halaman;$i++)
  52. {
  53. ?>
  54. <a href="?halaman<?php echo $i ?>">
  55. <?php echo $i; ?>
  56. </a>
  57. <?php
  58. }
  59. ?>
  60.  
  61. <a <?php if($halaman < $total_halaman) { echo "href='?halaman=$selanjutnya'"; } ?>
  62. >$selanjutnya
  63. </a>
  64. </p>
  65. </body>
  66. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement