talevtehnology
Registered
Здравейте ка да направя страницирането да е като на туриста
тоест да не ми показва всички страници
Ето го и кода помагайте :?
тоест да не ми показва всички страници
Ето го и кода помагайте :?
Код:
<?php
include ('configprodukti.php');
$snimka = $snimka['snimka'];
$vip = $_GET['vip'];
$category = $_GET['category'];
$category = htmlspecialchars($category);
$category = strip_tags($category);
$category = get($category);
$snimka = $obavi['snimka'];
//nachalo na stranicirane
$redove = ($pageNum - 1) * $broinastranica; ;
$broinastranica = "4";
$pageNum = "1";
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
$pageNum = htmlspecialchars($pageNum);
$pageNum = strip_tags($pageNum);
$pageNum = get($pageNum);
}
$redove = ($pageNum - 1) * $broinastranica;
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$cat = (isset($_GET["category"])) ? "&category=" . $_GET["category"] : "";
$nomeranastranici .= " <a href=\"$self?page=$page$cat$izberi\">$page</a> ";
}
}
if (isset($_GET['izberi'])){ $zapisi = "SELECT * FROM obqvi WHERE izberi='$izberi' ORDER BY id DESC LIMIT $redove, $broinastranica"; }
elseif (isset($_GET['category'])){ $zapisi = "SELECT * FROM obqvi WHERE category='$category' ORDER BY id DESC LIMIT $redove, $broinastranica"; }
elseif (!isset($_GET['izberi']) and !isset($_GET['category']) ){ $zapisi = "SELECT * FROM obqvi ORDER BY vip DESC, id DESC LIMIT $redove, $broinastranica"; }
$results = mysql_query($zapisi)or die (mysql_error());
while($row = mysql_fetch_array($results)){
echo "
<TABLE $row[vip] align='center' border='0' bgcolor='#FFac34' cellpadding='3px' cellspacing='3px' width='550px'>
<tr>
<td width=155 height=115 rowspan=2><img src=\"$row[snimka]\" width=\"200px\" height=\"160px\" alt=\"\" border=\"0\" /><br /><span class=\"postdetails\"><a target=_blank href=\"http://talevtehnology.com/$row[snimka]\"><b>Виж изображението</b></a><br>
<a target=_blank href=\"http://talevtehnology.com/shemi/$row[downloads].pdf\"><b>Свали PDF</b><img src=\"pdf.jpg\"border=\"0\"</a></td>
<td height=28 colspan=4 align=left class='style25' valign=top>$row[ime]</td>
</tr>
<tr>
<td colspan=4 align=left valign=top>$row[opisanie]</td>
</tr>
<tr>
<td height=29><a target=_blank href=\"http://talevtehnology.com/shemi/$row[downloads].pdf\"><b>Свали описание</b><img src=\"pdf.jpg\"border=\"0\"</a></td>
<td width=58>Дата:</td>
<td width=140>$row[date]</td>
<td width=26>Цена:</td>
<td width=97>$row[cena]</td>
</tr>
</table><br>";
}
// създаване на ликовете [предишна] [следваща]
// както и линковете [първа] и [последна]
if(isset($_GET['izberi'])){
$query = "SELECT COUNT(id) AS numrows FROM obqvi WHERE izberi='$izberi'";
}
elseif(isset($_GET['category'])){
$query = "SELECT COUNT(id) AS numrows FROM obqvi WHERE category='$category'";
}
elseif(!isset($_GET['izberi']) && !isset($_GET['category'])){
$query = "SELECT COUNT(id) AS numrows FROM obqvi";
}
$result = mysql_query($query) or die(mysql_error());
$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
{
$cat = (isset ($_GET["category"])) ? "&category=" . $_GET["category"] : "";
$izberi = (isset ($_GET["izberi"])) ? "&izberi=" . $_GET["izberi"] : "";
$nomeranastranici .= " <a href=\"$self?page=$page$cat$izberi\">$page</a> ";
}
}
if ($pageNum > 1)
{
$cat = (isset($_GET["category"])) ? "&category=" . $_GET["category"] : "";
$izberi = (isset($_GET["izberi"])) ? "&izberi=" . $_GET["izberi"] : "";
$page = $pageNum - 1;
$predishna = " <a href=\"$self?page=$page$cat$izberi\"> [<<<<<] </a> ";
$parva = " <a href=\"$self?page=1$cat$izberi\">[първа]</a> ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$cat = (isset($_GET["category"])) ? "&category=" . $_GET["category"] : "";
$izberi = (isset($_GET["izberi"])) ? "&izberi=" . $_GET["izberi"] : "";
$page = $pageNum + 1;
$sledvashta = " <a href=\"$self?page=$page&$cat&$izberi\"> [>>>>>] </a> ";
$posledna = " <a href=\"$self?page=$maxPage&$cat&$izberi\">[последна]</a> ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
// показваме
echo "<div align='center'>$parva $predishna $nomeranastranici $sledvashta $posledna</div>";
?>