Имам следния проблем вместо да ми вади броя на игрите от таблицата files ми вади потребителите от таблицата users .... например правя страницирането по 1 игра на страница и аз имам 3 игри ми вади 8 тоест колкото потребителя имам 8 а не ми вади 3 страници ... :/
Код:
<?php
echo "<div class='gm-listen-header'><span class='gm-ls-link-selected'>Секция Игри</span><div class='clear'></div></div>";
require "functions.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?a=profile&id";
$battle = "index.php?a=battle&id";
$path = $url.$vote;
$broinastranica = 1;
$pageNum = 1;
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$redove = ($pageNum - 1) * $broinastranica;
$query = "SELECT * FROM files ORDER BY id DESC LIMIT $redove, $broinastranica";
$result = mysql_query($query) or die('Error, query failed');
$i = $redove + 1;
while($row = mysql_fetch_array($result))
{
if($row['namepro'] == '1'){$prouser = ' <span style="padding: 0px 3px; color: white; background-color: red; font-weight: bolder; font-size: 11px;">PRO</span>';}else{$prouser = ' ';}
?>
<?php
$file = $row['file'];
$subject = $row['subject'];
$description = $row['description'];
?>
<?php
echo "<table border=\"0\" align=\"center\" valign=\"top\">\n";
{
$size = resize($row['pic']);
echo "
<div class='gm-listen-box'>
<img src=\"".$row['pic']."\" width=\"".$size['width']."\" height=\"".$size['height']."\" border=\"0\" class='gm-m-imga'>
<div class='gm-m-body'>
<a class='gm-lt'><span valign=\"top\">".sakra6tenie($row['subject'])."</span></a>
<div class='gm-ltb'><span valign=\"top\">".sakra6tenie($row['description'])."</span></div>
<div class='gm-3b'>
<div class='gm-play'>Играна <span>0</span></div>
</div>
<div class='clear'></div>
</div>
<div class='clear'></div>
</div> ";
}
echo "</table>";
?>
</tbody>
<? $i++; } ?>
</table>
<?
$query = "SELECT COUNT(name) 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 .= "<a href=\"\" class='text_border'> $page</a>";
}
else
{
$nomeranastranici .= " <a href=\"?a=games2&page=$page\" class='g3link_border'>$page</a> ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " <a href=\"?a=games2&page=$page\" class='glink'> « </a> ";
$parva = " <a href=\"?a=games2&page=1\"></a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " <a href=\"?a=games2&page=$page\" class='glink'> » </a> ";
$posledna = " <a href=\"?a=games2&page=$maxPage\"></a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
echo "<center>$parva $predishna $nomeranastranici $sledvashta $posledna</center>";
?>