|
echo $nadpis; ?>
|
Filtr:
echo "";
/*
echo " ";
echo "kategorie=".$kategorie;
echo " ";
echo "vybraná kategorie=".$vybrano_kategorie;
echo " ";
echo "podmínka=".$podminka;
echo " ";
echo "adr1=".$_SERVER['PHP_SELF'];
echo " ";
echo "adr2=".basename($_SERVER['REQUEST_URI']);
*/
//echo $podminka;
echo " ";
?>
$dnes = date("Y.m.d");
$rowsPerPage = 10;
$pageNum = 1;
if(isset($_GET['StranaForm']))
{
$pageNum = $_GET['StranaForm'];
if($pageNum=='') $pageNum=1;
}
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$pageNum10=($pageNum*10)-10;
$sSQL = "SELECT id,datum,nebezpecny_vyrobek,nadpis,cesta,img,obsah,datum_do,klicove_slovo FROM 01_uredni_deska_nv $podminka ORDER BY datum DESC LIMIT $pageNum10,$rowsPerPage;";
//print $sSQL;
$rs = mysql_query($sSQL) or die (mysql_error());
while ($row = mysql_fetch_array($rs)):
print "";
endwhile;
mysql_free_result($rs);
$query1 = "SELECT COUNT(id) AS numrows1 FROM 01_uredni_deska_nv $podminka";
$result1 = mysql_query($query1) or die('Error, query failed1');
$row1 = mysql_fetch_array($result1, MYSQL_ASSOC);
$query = "SELECT COUNT(id) AS numrows FROM 01_uredni_deska_nv $podminka;";
$result = mysql_query($query) or die('Error, query failed2');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row1['numrows1'];
$maxPage = ceil($numrows/$rowsPerPage);
if($maxPage==0) $maxPage=1;
$cely_odkaz=basename($_SERVER['REQUEST_URI']);
/*
echo " ";
if($_GET['page'])
{
echo "page: ".$page;
}
else
{
echo "page: nic";
}
echo " ";
echo " ";
if($_GET['odeslat'])
{
echo "odeslat: ".$odeslat;
}
else
{
echo "odeslat: nic";
}
echo " ";
echo " ";
if($_GET['StranaForm'])
{
echo "StranaForm: ".$StranaForm;
}
else
{
echo "StranaForm: nic";
}
echo " ";
*/
if ($pageNum > 1)
{
$page = $pageNum-1;
if (empty($_GET['page']) AND empty($_GET['odeslat']) AND empty($_GET['StranaForm']))
{
$prev = " [Předchozí] ";
$first = " [První] ";
}
else
{
$prev = " [Předchozí] ";
$first = " [První] ";
}
}
else
{
$prev = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
if (empty($_GET['page']) AND empty($_GET['odeslat']) AND empty($_GET['StranaForm']))
{
$next = " [Další] ";
$last = " [Poslední] ";
}
else
{
$next = " [Další] ";
$last = " [Poslední] ";
}
}
else
{
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}
echo " ";
echo "".$first . $prev ." Strana $pageNum z $maxPage " . $next . $last."";
?>
/*
|
|
|
|
|
|
 |