Относно странициране

kitchenbg

Registered
Здравейте, имам следния код
Код:
<?php
$currentPage = $_SERVER["PHP_SELF"];

$maxRows_Search = 15;
$pageNum_Search = 0;
if (isset($_GET['pageNum_Search'])) {
  $pageNum_Search = $_GET['pageNum_Search'];
}
$startRow_Search = $pageNum_Search * $maxRows_Search;

mysql_select_db($database_bg, $bg);
$query_Search = "SELECT * FROM face WHERE wait = '0' ORDER BY `date` DESC";
$query_limit_Search = sprintf("%s LIMIT %d, %d", $query_Search, $startRow_Search, $maxRows_Search);
$Search = mysql_query($query_limit_Search, $bg) or die(mysql_error());
$row_Search = mysql_fetch_assoc($Search);

if (isset($_GET['totalRows_Search'])) {
  $totalRows_Search = $_GET['totalRows_Search'];
} else {
  $all_Search = mysql_query($query_Search);
  $totalRows_Search = mysql_num_rows($all_Search);
}
$totalPages_Search = ceil($totalRows_Search/$maxRows_Search);

$queryString_Search = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_Search") == false && 
        stristr($param, "totalRows_Search") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_Search = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_Search = sprintf("&totalRows_Search=%d%s", $totalRows_Search, $queryString_Search);
?>
Показвам си резултатите в таблица и искам да ги страницирам като ползвам този код
Код:
 <? 						  
if (!$pageNum_Search or ($totalRows_Search > $totalPages_Search)) {
$pageNum_Search="1";
}

if ($totalPages_Search < 15) {
for($i=1 ; $i<=$totalPages_Search ; $i++) {
if ( ($pageNum_Search)==$i ) {
echo "<div><b>$i</b></div> ";
}
else {
echo "<a href=\"?pageNum_Search=".$i."\">".$i." </a>";
}
}
}
else {
for($i=1 ; $i<=3 ; $i++) {
if ( ($pageNum_Search)==$i ) {
echo "<div><b>$i</b></div> ";
}
else {
echo "<a href=\"?pageNum_Search=".$i."\">".$i." </a> ";
}
}

if ($pageNum_Search <= 3) {
if ($pageNum_Search == 3) echo "<a href=\"?pageNum_Search=4\">4</a> ";
echo "<span class=\"tochki\">...</span> ";
for ($i=$totalPages_Search-2; $i<=$totalPages_Search; $i++)
echo "<a href=\"?pageNum_Search=".$i."\">".$i." </a> ";
}
if ($pageNum_Search == 5) $parva.= "<a href=\"?pageNum_Search=4\">4</a> ";

if ( ($pageNum_Search == 4) or ($pageNum_Search == 5) ) {
for ($i=$totalPages_Search; $i<=$totalPages_Search+1; $i++) {
if ($pageNum_Search == $i) echo "<div><b>$i</b></div> ";
else echo "<a href=\"?pageNum_Search=".$i."\">".$i." </a> ";
}
echo "<span class=\"tochki\">...</span> ";
for ($i=$totalPages_Search-2; $i<=$totalPages_Search; $i++)
echo "<a href=\"?pageNum_Search=".$i."\">".$i." </a> ";
}

if ( ($pageNum_Search > 5) and ($pageNum_Search < ($totalPages_Search - 4)) ) {
echo "<span class=\"tochki\">...</span> ";
for ($i=$totalPages_Search-1; $i<=$totalPages_Search+1; $i++) {
if ($pageNum_Search == $i) echo "<div><b>$i</b></div> ";
else echo "<a href=\"?pageNum_Search=".$i."\">".$i." </a> ";
}
echo "<span class=\"tochki\">...</span> ";
for ($i=$totalPages_Search-2; $i<=$totalPages_Search; $i++)
echo "<a href=\"?pageNum_Search=".$i."\">".$i." </a> ";
}

if ( $pageNum_Search > ($totalPages_Search - 5) ) {
echo "<span class=\"tochki\">...</span> ";
for ($i=$totalPages_Search-5; $i<=$totalPages_Search; $i++) {
if ($pageNum_Search == $i) echo "<div><b>$i</b></div> ";
else echo "<a href=\"?pageNum_Search=".$i."\">".$i." </a> ";
}
}
} 
?>

Обаче не се получава, ето - резултата

Къде бъркам ?
 

Back
Горе