Stránkování seznamu

<?
   $pocet=10;
if ($_GET[stranka]) $stranka=$_GET[stranka];
else $stranka=1;
$page=($stranka-1)*$pocet;
const pzn=33;
               
$sql=new mysql();


$c_arr = array();
$c_buf = '';

$c_zak = $sql->arrays("SELECT * from vz WHERE vlozeno > DATE(NOW()) ORDER BY ID DESC LIMIT $page,$pocet");
$c_pop = $sql->arrays("SELECT * from poptavky WHERE zalozeno > DATE(NOW()) ORDER BY ID DESC LIMIT $page,$pocet");


if ($c_zak) {
    $c_format = '%s, za %s&nbspKÄŤ - %s';

    foreach ($c_zak as $key => $value) {
        array_push($c_arr,
            sprintf($c_format, c_strip_str_len($value[nazev], pzn),
                c_nf($value[cena]),
                $value[mesto]
            )
        );
    }

   
}

if ($c_pop) {
    $c_format = '%s, za %s&nbspKÄŤ';

    foreach ($c_pop as $key => $value) {
        array_push($c_arr,
            sprintf($c_format, c_strip_str_len($value[label], pzn),
                c_nf($value[cena])
            )
        );
    }
}

shuffle($c_arr);

$c_format = '<a href="/poptavky/">%s...</a>&nbsp;&nbsp;';

foreach ($c_arr as $key => $value) {
        $c_buf .= sprintf($c_format, $value);
}

$fce[c_banner_poptavky] = $c_buf;

// BANNER ---

//$q=$sql->arrays("SELECT * from vz ORDER BY ID DESC LIMIT $page,$pocet");
$q=$sql->arrays("SELECT * from vz WHERE vlozeno < DATE(NOW()) ORDER BY ID DESC LIMIT $page,$pocet");
if ($q) foreach ($q as $res){

if (date ("d.m.Y")==date("d.m.Y",strtotime("$res[vlozeno]"))) $dat="dnes";
elseif (date ("d.m.Y", strtotime("-1 day"))==date("d.m.Y",strtotime("$res[vlozeno]"))) $dat="vÄŤera";
else $dat=date("d.m.Y", strtotime("$res[vlozeno]"));

if (strlen($res[nazev]) > pzn) $nazev=substr($res[nazev],0,pzn).'...'; else $nazev=$res[nazev];

$c_format = '%s, za %s&nbspKÄŤ - %s';
$anw.="<TR ROWSPAN=\"2\"><TD class=\"podtrh\"><A HREF = \"/poptavky/\">".
c_strip_str_len(sprintf($c_format, $res[nazev], c_nf($res[cena]), $res[mesto]), 120, '...')
."</A><TD class=\"datum\">$dat</TR>";
}
$fce[zakazky]=$anw;

$anw="";



$q=$sql->arrays("SELECT * from vz WHERE vlozeno > DATE_SUB(NOW(), INTERVAL 120 DAY) ORDER BY ID DESC LIMIT $page,$pocet");
if ($q) foreach ($q as $res){

if (date ("d.m.Y")==date("d.m.Y",strtotime("$res[vlozeno]"))) $dat="dnes";
elseif (date ("d.m.Y", strtotime("-1 day"))==date("d.m.Y",strtotime("$res[vlozeno]"))) $dat="vÄŤera";
else $dat=date("d.m.Y", strtotime("$res[vlozeno]"));

$anw.="<TR><TD class=\"podtrh\"><A HREF = \"/zakazka-detail-$res[ID]/\">$res[nazev], za ".c_nf($res[cena])."&nbspKÄŤ<BR>$res[mesto]</A><TD class=\"datum\">$dat</TR>";
}
$fce[zakazky2]=$anw;

// ZAKÁZKY ---


$q=$sql->arrays("SELECT * from poptavky WHERE zalozeno > DATE_SUB(NOW(), INTERVAL 120 DAY) ORDER BY ID DESC LIMIT $page,$pocet");
if ($q) foreach ($q as $res){

if (date ("d.m.Y")==date("d.m.Y",strtotime("$res[zalozeno]"))) $dat="dnes";
elseif (date ("d.m.Y", strtotime("-1 day"))==date("d.m.Y",strtotime("$res[zalozeno]"))) $dat="vÄŤera";
else $dat=date("d.m.Y", strtotime("$res[zalozeno]"));
if ($res[cena]=="0") $cena = "";
  else $cena = ", za ".c_nf($res[cena])."&nbspKÄŤ";

$pop.="<TR><TD class=\"datum\">$dat<TD class=\"podtrh\"><A HREF = \"/poptavka-detail-$res[ID]/\">$res[label]$cena</A></TR>";
}

$fce[poptavky2]=$pop;

$pop="";

//$q=$sql->arrays("SELECT * from poptavky ORDER BY ID DESC LIMIT $page,$pocet");
$q=$sql->arrays("SELECT * from poptavky WHERE zalozeno < DATE(NOW()) ORDER BY ID DESC LIMIT $page,$pocet");
if ($q) foreach ($q as $res){

if (date ("d.m.Y")==date("d.m.Y",strtotime("$res[zalozeno]"))) $dat="dnes";
elseif (date ("d.m.Y", strtotime("-1 day"))==date("d.m.Y",strtotime("$res[zalozeno]"))) $dat="vÄŤera";
else $dat=date("d.m.Y", strtotime("$res[zalozeno]"));
  if ($res[cena]=="0") $cena = "";
  else $cena = ", za ".c_nf($res[cena])."&nbspKÄŤ";

if (strlen($res[label]) > pzn) $nazev=substr($res[label],0,pzn).'...'; else $nazev=$res[label];

$c_format = '%s%s';
$pop.="<TR><TD class=\"datum\">$dat<TD class=\"podtrh\"><A HREF = \"/poptavky/\">".
c_strip_str_len(sprintf($c_format, $nazev, $cena), 120, '...')
."</A></TR>";
}

return $pop;



// POPTÁVKY ----



?>

$qp = new pager("SELECT * FROM poptavky ORDER BY ID DESC",'stranka',$this->sql->sql_connect);
$qp->PageSize = $pocet;
$qp->PagerAlign = "center";
$qp->DataBind();
echo $qp->DrawPager();