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 | ?> |