/home/kkco/public_html/home__2939f42/admin/page/pencarian.php
<div class="panel-body">
<?php
$baris=100;
$no="0";
$hal = isset($_GET['num']) ? $_GET['num'] : 1;
$mulai = $baris * ($hal-1);
if (isset($_GET['num'])&&$_GET['num']!="")
{
$strQuery="order by id desc LIMIT ".$mulai.",".$baris."";
}
else
{
$strQuery="order by id desc LIMIT ".$baris."";
}
?>
<h4>PENCARIAN</h4>
<table border="2">
<tr><td width="20"><strong>No</strong></td><td width="500"><strong>Keyword</strong></td><td width="200"><strong>Total</strong></td></tr>
<?php
$sql=mysql_query("select * from search ".$strQuery." ");
while($data=mysql_fetch_array($sql))
{
$no++;
echo "<tr><td>".$no."</td><td>".$data['keyword']."</td><td>".$data['total']."</td></tr>";
$idAkhir=$data['id'];
}
echo "</table>";
$sqlCount=mysql_query("select * from search");
$count=mysql_num_rows($sqlCount);
$page=ceil($count/$baris);
if ($hal<=2)
{ $awalPage=1; }
else if ($hal>2&&$page-$hal>=1)
{
$awalPage=$hal-1;
}
else if ($hal>2&&$page-$hal<1)
{
$awalPage=$page-2;
}
if ($awalPage+2<=$page)
{
$akhirPage= $awalPage+2;
}
else if ($awalPage+2>$page)
{
$akhirPage= $page;
}
echo "<ul class=\"pagination\">";
if ($hal>1)
{
echo "<li><a href=\"index.php?page=pencarian&num=1\"><<</a></li>";
echo "<li><a href=\"index.php?page=pencarian&num=".($hal-1)."\"><</a></li>";
}
for ($i=$awalPage;$i<=$akhirPage;$i++)
{
echo "<li ".($i==$hal?"class=\"active\"":"")." ><a href=\"index.php?page=pencarian&num=".$i."\">".$i."</a></li>";
}
if ($hal<$page)
{
echo "<li><a href=\"index.php?page=pencarian&num=".($hal+1)."\">></a></li>";
echo "<li><a href=\"index.php?page=pencarian&num=".$page."\">>></a></li>";
}
echo "</ul>";
?>
</div>