Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include('koneksi.php');
- include('index_inputan.php');
- $dataPerPage = 5;
- if(isset($_GET['page']))
- {
- $noPage = $_GET['page'];
- }
- else
- {
- $noPage = 1;
- }
- $offset = ($noPage - 1) * $dataPerPage;
- $query = "SELECT * FROM tmptoken LIMIT $offset, $dataPerPage";
- $result = mysql_query ($query)or die("sql:<br> $query<hr>".mysql_error());
- $no = 1;
- echo "<table border='1'>";
- echo "<tr><td>No</td><td>Nama</td><td>Frekuensi</td></tr>";
- while($data = mysql_fetch_array($result))
- {
- echo "<tr><td>".$no."</td><td>".$data['kata']."</td><td>".$data['frekuensi']."</td></tr>";
- $no++;
- }
- echo "</table>";
- $query2 = "SELECT COUNT(*) AS kata FROM tmptoken";
- $result2 = mysql_query ($query2)or die("sql:<br> $query<hr>".mysql_error());
- /*
- APA INI?? MASA HASIL QUERY DI QUERY LAGI
- $hasil = mysql_query($result2)or die("sql:<br> $query<hr>".mysql_error());
- */
- $data2 = mysql_fetch_array($result2); //$hasil);
- $jumData = $data2['kata'];
- $jumPage = ceil($jumData/$dataPerPage);
- if ($noPage > 1) echo "<a href='".$_SERVER['PHP_SELF']."?page=".($noPage-1)."'><< Prev</a>";
- for($page = 1; $page <= $jumPage; $page++)
- {
- if (
- (($page >= ($noPage - 3))
- && ($page <= $noPage + 3))
- || ($page == 1)
- || ($page == $jumPage)
- )
- {
- if (($showPage == 1) && ($page != 2)) echo "...";
- if (($showPage != ($jumPage - 1)) && ($page == $jumPage)) echo "...";
- if ($page == $noPage) echo " <b>".$page."</b> ";
- else echo " <a href='".$_SERVER['PHP_SELF']."?page=".$page."'>".$page."</a> ";
- $showPage = $page;
- }
- }
- if ($noPage < $jumPage){
- echo "<a href='".$_SERVER['PHP_SELF'].
- "?page=".($noPage+1)."'>Next >></a>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement