Класация и страници

[katsar0v]

<?php
echo'
<div class="right_box">
<div class="right_box_top">Класация</div>
<div class="right_box_middle">';
$sql = 'SELECT *
FROM `users`
ORDER BY `users`.`points` DESC
LIMIT 0 , 10';

$result=mysql_query($sql);
$i = 1;
echo'<table class=\"table\" width=300 border=1 cellspacing=0 cellpading=0 style="margin-left:100px;border:1px #444 solid ; margin-top:10px;border-collapse:collapse;" >';
echo "<tr><td>Място:</td><td height=30 align=\"left\">Име:</td><td>Скайп:</td><td>Точки:</td></tr>";
while($row = mysql_fetch_array($result))
{
$name = $row['users'];
$skype = $row['skype'];
$points = $row['points'];
echo "<tr><td width=50>$i</td><td height=30 align=\"left\" width=100><a href='view.php?user=$name'><u>$name</u></a></td><td>$skype</td><td>$points</td></tr>";
$i++;
}
echo'</table>';

echo'</div>
';

?>

Направих класация , как да направя да показва по 10 резултата на страница

 

[kulov]

<?php
$broinastranica = 10;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;

$query = "SELECT COUNT(id) AS numrows FROM `users`";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];


$maxPage = ceil($numrows/$broinastranica);

$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';

for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " <a href=\"$self?page=$page\">$page</a> ";
}
}

if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <font color=orange><a href=\"$self?page=$page\"> [<] </a></font> ";

$parva = " <font color=orange><a href=\"$self?page=1\">[първа]</a></font> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}

echo'
<div class="right_box">
<div class="right_box_top">Класация</div>
<div class="right_box_middle">';
$sql = 'SELECT *
FROM `users`
ORDER BY `users`.`points` DESC
LIMIT '.$redove.', '.$broinastranica.'';

$result=mysql_query($sql);
$i = 1;
echo'<table class=\"table\" width=300 border=1 cellspacing=0 cellpading=0 style="margin-left:100px;border:1px #444 solid ; margin-top:10px;border-collapse:collapse;" >';
echo "<tr><td>Място:</td><td height=30 align=\"left\">Име:</td><td>Скайп:</td><td>Точки:</td></tr>";
while($row = mysql_fetch_array($result))
{
$name = $row['users'];
$skype = $row['skype'];
$points = $row['points'];
echo "<tr><td width=50>$i</td><td height=30 align=\"left\" width=100><a href='view.php?user=$name'><u>$name</u></a></td><td>$skype</td><td>$points</td></tr>";
$i++;
}

echo "<font color = '#000' />Страница: </font>";
echo "<font color = '#000' />$nomeranastranici</font>";

echo'</table>';

echo'</div>
';

?>

 

[ExpressYourself]

<?php
$pp = "10";
$page=$_GET['page'];
if(!$_GET['page'])
{
$page="1";
}
$limit = ($pp*$page)-$pp;
$redove = mysql_query("SELECT * FROM `users`");
$max=mysql_numrows($redove);
$total=ceil($max/$pp);

echo'
<div class="right_box">
<div class="right_box_top">Класация</div>
<div class="right_box_middle">';
$sql = 'SELECT *
FROM `users`
ORDER BY `users`.`points` DESC
LIMIT $limit,$pp';

$result=mysql_query($sql);
$i = 1;
echo'<table class=\"table\" width=300 border=1 cellspacing=0 cellpading=0 style="margin-left:100px;border:1px #444 solid ; margin-top:10px;border-collapse:collapse;" >';
echo "<tr><td>Място:</td><td height=30 align=\"left\">Име:</td><td>Скайп:</td><td>Точки:</td></tr>";
while($row = mysql_fetch_array($result))
{
$name = $row['users'];
$skype = $row['skype'];
$points = $row['points'];
echo "<tr><td width=50>$i</td><td height=30 align=\"left\" width=100><a href='view.php?user=$name'><u>$name</u></a></td><td>$skype</td><td>$points</td></tr>";
$i++;
}
echo'</table>';
if ($page > 1) {
$prev = ($page - 1);
echo "<a href=\"?page=$prev\"><font face=\"Trebuchet MS\">Предишна страница</font></a> ";
}
else echo "<font face=\"Trebuchet MS\">Предишна страница</font> ";

if (!$page or ($page > $total)) {
$page="1";
}

if ($total < 10) {
for($i=1 ; $i<=$total ; $i++) {
if ( ($page)==$i ) {
echo "<b>$i</b> ";
}
else {
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
}
}
else {
for($i=1 ; $i<=3 ; $i++) {
if ( ($page)==$i ) {
echo "<b>$i</b> ";
}
else {
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
}

if ($page <= 3) {
if ($page == 3) echo "<a href=\"?page=4\">4</a> ";
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
if ($page == 5) $parva.= "<a href=\"?page=4\">4</a> ";

if ( ($page == 4) or ($page == 5) ) {
for ($i=$page; $i<=$page+1; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}

if ( ($page > 5) and ($page < ($total - 4)) ) {
echo "... ";
for ($i=$page-1; $i<=$page+1; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a href=\"?page=".$i."\">".$i."</a> ";
}

if ( $page > ($total - 5) ) {
echo "... ";
for ($i=$total-5; $i<=$total; $i++) {
if ($page == $i) echo "<b>$i</b> ";
else echo "<a href=\"?page=".$i."\">".$i."</a> ";
}
}
}

if ($page < $total) {
$next = ($page + 1);
echo "<a href=\"?page=$next\"><font face=\"Trebuchet MS\">Следваща страница</font></a> ";
}
else echo "<font face=\"Trebuchet MS\">Следваща страница</font>";
echo'</div>
';

?>