- Joined
- Jun 21, 2013
- Messages
- 30
- Reaction score
- 1
rangkinglist.php
WhatThePho
-> original sript http://forum.ragezone.com/f705/release-ranking-page-total-accounts-777354-post6521096/#post6521096
PHP:
<!--rangking list-->
<?php
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("db_game") or die (mysql_error());
// jumlah data yang akan ditampilkan
$dataPerPage = 50;
if(isset($_GET['page']))
{
$noPage = $_GET['page'];
}
else $noPage = 1;
$offset = ($noPage - 1) * $dataPerPage;
// membaca nomor halaman
$noPage = $_GET['page'];
// membuat nomor urut awal di setiap halaman berdasarkan formula di atas
$i = $noPage + ($noPage - 1) * ($dataPerPage - 1);
$result = mysql_query("SELECT * FROM t_user WHERE pv < 9 ORDER BY totalexp DESC LIMIT $offset, $dataPerPage")
or die(mysql_error());
echo "<table border='1'>";
echo "<tr>
<th>No.</th>
<th>Name</th>
<th>Level</th>
<th>Exp</th>
<th>Guild</th>
</tr>";
while($row = mysql_fetch_array($result))
{
echo "<tr><td>";
echo $i;
echo "</td><td>";
echo $row['name'];
echo "</td><td>";
echo $row['level'];
echo "</td><td>";
echo $row['totalexp'];
echo "</td><td>";
echo $row['guild'];
echo "</td></tr>";
$i++;
}
echo "</table>";
// tambahan
$query = "SELECT COUNT(*) AS jumData FROM t_user WHERE pv < 6 ORDER BY totalexp DESC";
$hasil = mysql_query($query);
$data = mysql_fetch_array($hasil);
$jumData = $data['jumData'];
$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>";
?>
thank's
WhatThePho
-> original sript http://forum.ragezone.com/f705/release-ranking-page-total-accounts-777354-post6521096/#post6521096