stránkovanie

<?php
    // zadefinovanie pocet zaznamov na jednu stranku
    $pocet = 5;
   
    // prevezme z GET cislo strany
    $pg = 0;
    if (isset($_GET['pg'])) $pg = abs(intval($_GET['pg']));
   
    // nadviazanie spojenia s databazou
    $db = pg_connect("host=localhost dbname=databaza user=ondrej password=xyz123") or die('Nepodarilo sa spojit s databazou!');
   
    $res_pocet = pg_query($db, "SELECT ceil(count(*) / ".$pocet.".0) FROM zaznamy") or die('Chyba dotazu (pocet)!');
    $pocetstran = pg_fetch_result($res_pocet, 0, 0) - 1;
    if ($pg > $pocetstran) $pg = 0;
   
    $res_zaznamy = pg_query($db, "SELECT * FROM zaznamy LIMIT ".$pocet." OFFSET ".($pg * $pocet)) or die('Chyba dotazu (zaznamy)!');
?>
<?php
    if (pg_num_rows($res_zaznamy) == 0) {
        echo '<div>Databaza neobsahuje ziadny zaznam.</div>';
    }
   
    while ($zaznam = pg_fetch_array($res_zaznamy)) {
        echo '<div>'.htmlspecialchars($zaznam['obsah']).'</div>';
    }
?>

function strankovanie($select_mysql, $url, $pages) {
 
$result=mysql_query($select_mysql);   
$num=mysql_num_rows($result);

if (!isset($_GET['strana'])){
$strana = 1;
}else{
$strana = ($_GET['strana']);
}

$limit = $pages;   
$celkovy_pocet=$num;   
$pocet_stran=ceil($celkovy_pocet/$limit);   
$pociatok=($strana*$limit)-$limit;   

for ($i=1; $i<=$pocet_stran; $i++)   
{   
    if ($i<>$strana)   
    {   
        echo "<a href=\"".$url."&strana=".$i."\">".$i."</a> | ";   
    }   
    else   
    {   
        echo "<font color=\"#FF0000\">".$i."</font> | ";   
    }
}
echo "</p>";

$result = mysql_query("".$select_mysql." LIMIT $pociatok, $limit");
return ($result);
}

// Strankovanie
$vyber_mysql = "SELECT * FROM ...";
$url_adresa = "sranka.php?nieco=nic";
$pocet_vysledkov = 5; // zobrazenia na stranu
$result = strankovanie($vyber_mysql, $url_adresa, $pocet_vysledkov);
// Zobrazenie vysledkov
for($count = 0; $count < mysql_numrows($result); $count++)
{
$obrazok = mysql_result($result, $count, "obrazok");

echo "<img src="...$obrazok ...">"; // tam das proste ten obrazok zobazit

}

   <?php
function strankovanie($select_mysql, $url, $pages) {
 
$result=mysql_query($select_mysql);   
$num=mysql_num_rows($result);

if (!isset($_GET['strana'])){
$strana = 1;
}else{
$strana = ($_GET['strana']);
}

$limit = $pages;   
$celkovy_pocet=$num;   
$pocet_stran=ceil($celkovy_pocet/$limit);   
$pociatok=($strana*$limit)-$limit;   

for ($i=1; $i<=$pocet_stran; $i++)   
{   
    if ($i<>$strana)   
    {   
        echo "<a href=\"".$url."&strana=".$i."\">".$i."</a> | ";   
    }   
    else   
    {   
        echo "<font color=\"#FF0000\">".$i."</font> | ";   
    }
}
echo "</p>";

$result = mysql_query("".$select_mysql." LIMIT $pociatok, $limit");
return ($result);
}   ?>
  <?php
// Strankovanie
$vyber_mysql = "SELECT * FROM ...";
$url_adresa = "sranka.php?nieco=nic";
$pocet_vysledkov = 5; // zobrazenia na stranu
$result = strankovanie($vyber_mysql, $url_adresa, $pocet_vysledkov);
// Zobrazenie vysledkov
for($count = 0; $count < mysql_numrows($result); $count++)
{
$obrazok = mysql_result($result, $count, "obrazok");

echo "<img src="/forum/texyla/icons/silk/bold.png">";
echo "<img src="/forum/texyla/icons/silk/h1.png">";
echo "<img src="/forum/texyla/icons/silk/img.png">";
echo "<img src="/forum/texyla/icons/silk/italic.png">";
echo "<img src="/forum/texyla/icons/silk/ol.png">";
echo "<img src="/forum/texyla/icons/silk/right.png">";
echo "<img src="/forum/texyla/icons/silk/sup.png">";
echo "<img src="/forum/texyla/icons/silk/sub.png">";
echo "<img src="/forum/texyla/icons/silk/ol.png">";
echo "<img src="/forum/texyla/icons/silk/right.png>";
     }
   ?>

echo "<img src=[b]'[/b]/forum/texyla/icons/silk/bold.png[b]'[/b]>";