View difference between Paste ID: GBVfEsF9 and CqTEitMj
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)."'>&lt;&lt; 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 &gt;&gt;</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 &gt;&gt;</a>";
63
}
64
?>