SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | include('koneksi.php');
| |
| 3 | include('index_inputan.php');
| |
| 4 | ||
| 5 | $dataPerPage = 5; | |
| 6 | ||
| 7 | if(isset($_GET['page'])) | |
| 8 | {
| |
| 9 | $noPage = $_GET['page']; | |
| 10 | } | |
| 11 | - | else $noPage = 1; |
| 11 | + | else |
| 12 | {
| |
| 13 | $noPage = 1; | |
| 14 | } | |
| 15 | $offset = ($noPage - 1) * $dataPerPage; | |
| 16 | - | $result = mysql_query ($query); |
| 16 | + | |
| 17 | $query = "SELECT * FROM tmptoken LIMIT $offset, $dataPerPage"; | |
| 18 | $result = mysql_query ($query)or die("sql:<br> $query<hr>".mysql_error());
| |
| 19 | $no = 1; | |
| 20 | ||
| 21 | echo "<table border='1'>"; | |
| 22 | echo "<tr><td>No</td><td>Nama</td><td>Frekuensi</td></tr>"; | |
| 23 | while($data = mysql_fetch_array($result)) | |
| 24 | {
| |
| 25 | echo "<tr><td>".$no."</td><td>".$data['kata']."</td><td>".$data['frekuensi']."</td></tr>"; | |
| 26 | $no++; | |
| 27 | } | |
| 28 | - | $result2 = mysql_query ($query2); |
| 28 | + | |
| 29 | - | $hasil = mysql_query($result2); |
| 29 | + | |
| 30 | - | $data2 = mysql_fetch_array($hasil); |
| 30 | + | |
| 31 | $result2 = mysql_query ($query2)or die("sql:<br> $query<hr>".mysql_error());
| |
| 32 | /* | |
| 33 | APA INI?? MASA HASIL QUERY DI QUERY LAGI | |
| 34 | $hasil = mysql_query($result2)or die("sql:<br> $query<hr>".mysql_error());
| |
| 35 | */ | |
| 36 | $data2 = mysql_fetch_array($result2); //$hasil); | |
| 37 | $jumData = $data2['kata']; | |
| 38 | ||
| 39 | - | if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $jumPage)) |
| 39 | + | |
| 40 | - | {
|
| 40 | + | |
| 41 | if ($noPage > 1) echo "<a href='".$_SERVER['PHP_SELF']."?page=".($noPage-1)."'><< Prev</a>"; | |
| 42 | ||
| 43 | for($page = 1; $page <= $jumPage; $page++) | |
| 44 | {
| |
| 45 | if ( | |
| 46 | (($page >= ($noPage - 3)) | |
| 47 | && ($page <= $noPage + 3)) | |
| 48 | || ($page == 1) | |
| 49 | - | if ($noPage < $jumPage) echo "<a href='".$_SERVER['PHP_SELF']."?page=".($noPage+1)."'>Next >></a>"; |
| 49 | + | || ($page == $jumPage) |
| 50 | ) | |
| 51 | {
| |
| 52 | if (($showPage == 1) && ($page != 2)) echo "..."; | |
| 53 | if (($showPage != ($jumPage - 1)) && ($page == $jumPage)) echo "..."; | |
| 54 | if ($page == $noPage) echo " <b>".$page."</b> "; | |
| 55 | else echo " <a href='".$_SERVER['PHP_SELF']."?page=".$page."'>".$page."</a> "; | |
| 56 | $showPage = $page; | |
| 57 | } | |
| 58 | } | |
| 59 | ||
| 60 | if ($noPage < $jumPage){
| |
| 61 | echo "<a href='".$_SERVER['PHP_SELF']. | |
| 62 | "?page=".($noPage+1)."'>Next >></a>"; | |
| 63 | } | |
| 64 | ?> |