limit = 30;
}
function vypis()
{
$array = '';
$array = intval($_GET['kat']);
if(is_numeric( $_GET['pkat'] ))
$array .= ', ' . intval($_GET['pkat']);
$select = "SELECT nazev FROM kategori WHERE id_kategori IN (" . $array . ") ORDER BY id_kategori";
$data = mysql_query($select, $this->link );
if( @mysql_num_rows( $data) != 0 )
{
print '';
print @mysql_result($data, 0, 0);
if( @mysql_result($data, 1, 0) != NULL)
print '/' . @mysql_result($data, 1, 0);
print '
';
}
$select = "SELECT zb.id_zbozi, zb.nazev, zb.popis_z, zb.cena, zb.akce, zb.kod, dos.dostupnost, zb.img_1
FROM zbozi zb, zaruky za, vyrobci vy, dostupnost dos
WHERE (
zb.id_zaruka = za.id_zaruky
)
AND (
zb.id_vyrobci = vy.id_vyrobce
)
AND (
zb.skladem = dos.id_dostupnosti
)
AND(
" .
(($this->pkat == NULL) ? "id_kategori = '" . $this->kat . "'" : "id_podkategori = '" . $this->pkat . "'" ) . "
)
ORDER BY " . (($_SESSION['order'] == NULL) ? 'zb.akce, nazev' : $_SESSION['order']) . "
LIMIT " . ($this->od * $this->limit) . "," . $this->limit;
$select2 = "SELECT zb.id_zbozi, zb.nazev, zb.popis_z, zb.cena, zb.akce, zb.kod, dos.dostupnost, zb.img_1
FROM zbozi zb, zaruky za, vyrobci vy, dostupnost dos
WHERE (
zb.id_zaruka = za.id_zaruky
)
AND (
zb.id_vyrobci = vy.id_vyrobce
)
AND (
zb.skladem = dos.id_dostupnosti
)
AND(
" .
(($this->pkat == NULL) ? "id_kategori = '" . $this->kat . "'" : "id_podkategori = '" . $this->pkat . "'" ) . "
)";
if(($data = mysql_query($select, $this->link)) == 0)
{
self::error_msg('Chyba v dotazu.');
return 0;
}
if(($pocet = mysql_num_rows($data))== 0)
{
self::error_msg("V této kategorii neexistuje žádný produkt.");
return 0;
}
$celkem = mysql_num_rows(mysql_query($select2, $this->link));
$i = 1;
if($celkem > $pocet)
{
$pages = "Strana ";
for($j = 0; $j < ($celkem / $this->limit); $j++)
$pages .= (($j == $this->od) ? ($j + 1) : ' ' . ($j + 1) . ' ');
}
print 'Celkem bylo nalezeno ' . $celkem . ' produktů. Na stránce je zobrazeno ' . $pocet . '.
' . $pages;
print '
';
print "
\n";
if($_SESSION['razeni'] != 'katalog'):
print '';
$i = 1;
while($row = mysql_fetch_array($data))
{
print (($i++ % 2) ? '' : NULL);
print '' ;
print ' ';
print '
'
. $row['nazev'] . '
' . (($row['img_1']) ?' ' : NULL) . '
Kód: ' . $row['kod'] . '
' . (($row['popis_z']) ? $row['popis_z'] : $row['popis_z']) . '
Dostupnost: ' . $row['dostupnost'] . '
Cena: ' . $row['cena'] . '
';
print ' | ' . (($i % 2) ? '
' : NULL) ;
$j++;
}
if( $j % 2 )
print '';
print '
';
endif;
if($_SESSION['razeni'] == 'katalog'):
print '';
endif;
print '' . $pages . '
';
}
function error_msg($msg)
{
print '' . $msg . '';
}
}
require_once './head.php';
$use = new zbozi();
$use->kat = $_REQUEST['kat'];
$use->pkat = (isset($pkat) ? $_REQUEST['pkat'] : NULL);
$use->od = (isset($od) ? $_REQUEST['od'] : 0);
?>
vypis($kat, $pkat);
?>