Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>PAGINATION DENGAN PHP & MYSQL</title>
- </head>
- <body>
- <h2 align="center">PAGINATION DENGAN PHP & MYSQL</h2>
- <table border="1px" align="center" width="80%" >
- <tr>
- <th>No</th>
- <th>NPM</th>
- <th>Nama Mahasiswa</th>
- <th>Tempat Lahir</th>
- <th>Tanggal Lahir</th>
- </tr>
- <?php
- include "koneksi.php";
- $batas = 10;
- $halaman = isset($_GET['halaman'])?(int)$_GET[''] : 1;
- $halaman_awal = ($halaman>1) ? ($halaman * $batas) - $batas : 0;
- $sebelumnya = $halaman - 1;
- $selanjutnya = $halaman + 1;
- $sql=mysqli_query($koneksi,"SELECT * FROM t_mahasiswa");
- $jumlah_data = mysqli_num_rows($sql);
- $total_halaman = ceil ($jumlah_data / $batas);
- $tampil=mysqli_query($koneksi,"SELECT * FORM t_mahasiswa order by nama_mahasiswa ASC limit $halaman_awal, $batas");
- $nomor = $halaman_awal+1;
- while($data=mysqli_fetch_array($tampil)){
- ?>
- <tr>
- <td><?=$nomor?></td>
- <td><?=$data['npm']?></td>
- <td><?=$data['nama_mahasiswa']?></td>
- <td><?=$data['tempat_lahir']?></td>
- <td><?=date_format(data_create($data['tanggal_lahir']),"d/m/y")?></td>
- </tr>
- <?php
- $nomor++;
- }
- ?>
- </table>
- <p align="center">
- <a <?php if ($halaman > 1){ echo "href='?halaman=$sebelumnya'"; }?>
- >sebelumnya
- </a>
- <?php
- for ($i=1;$i<=$total_halaman;$i++)
- {
- ?>
- <a href="?halaman<?php echo $i ?>">
- <?php echo $i; ?>
- </a>
- <?php
- }
- ?>
- <a <?php if($halaman < $total_halaman) { echo "href='?halaman=$selanjutnya'"; } ?>
- >$selanjutnya
- </a>
- </p>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement