UltimateToTaL
Registered
Добър вечер искам да попитам как ще стане това да вади потребителите примерно
1.
2.
3.
4.
Мислих че е на този принцип но $i винаги е 1 :X Моля ви помогнете ми
1.
2.
3.
4.
Код:
<?php
include("config.php");
function selfURL() {
$s = empty($_SERVER["HTTPS"]) ? ''
: ($_SERVER["HTTPS"] == "on") ? "s"
: "";
preg_match_all('/(.*)\//',$_SERVER['SCRIPT_NAME'],$lq);
$protocol = strleft(strtolower($_SERVER["SERVER_PROTOCOL"]), "/").$s;
$port = ($_SERVER["SERVER_PORT"] == "80") ? ""
: (":".$_SERVER["SERVER_PORT"]);
return $protocol."://".$_SERVER['SERVER_NAME'].$port.$lq[0][0];
}
function strleft($s1, $s2) {
return substr($s1, 0, strpos($s1, $s2));
}
$url = selfURL();
$vote = "index.php?l=vote&id";
$path = $url.$vote;
$broinastranica = 10;
$pageNum = 1;
$start = ($page * 10);
$i = ($start + 1);
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$query = " SELECT * FROM users ORDER BY points DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
while($row = mysql_fetch_array($result))
{
echo "
<div class=member_top>
<div class=number_top>
<div class=num_top>".$i."</div>
</div>
<div class=avatar_top><img src=".$avatar." alt=Avatar width=28 height=28></div>
<div class=name_top>".$ime." ".$status." ".$ls." ".$edit."
<div class=points_top>".$row['points']." точки</div>
</div>
<div class=vote_top>
<div class=vote_top_in><a href=".$row['username']." class=vote_top_in>Глас</a></div>
</div>
</div>
";
}
$query = "SELECT COUNT(username) 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=\"?l=ranking&page=$page\">$page</a> ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href=\"?l=ranking&page=$page\"> << </a> ";
$parva = " <a href=\"?l=ranking&page=1\">първа</a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"?l=ranking&page=$page\"> >> </a> ";
$posledna = " <a href=\"?l=ranking&page=$maxPage\">последна</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo "<center>Страница: $parva $predishna $nomeranastranici $sledvashta $posledna</center>";
?>Мислих че е на този принцип но $i винаги е 1 :X Моля ви помогнете ми
