logo
Katalog | Košík | Jak objednat

"; include('vts.php'); print "
"; } elseif ((isset($_GET['clanek'])) And ($_GET['clanek']=='udrzba')) { print "
"; include('udrzba.php'); } elseif ((isset($_GET['clanek'])) And ($_GET['clanek']=='cisteni')) { print "
"; include('cisteni.php'); } elseif ((isset($_GET['clanek'])) And ($_GET['clanek']=='jak_na_to')) { print "
"; include('jak_na_to.php'); } else { $limit = ""; $where = " where (katalog.kod_prod like 't%') "; if (isset($_GET['kat'])) {$where = " where (katalog.kod_prod like 't%') and kategorie='".$_GET['kat']."' ";} if ((isset($_GET['vyraz']))AND ($_GET['vyraz']!='')) {$where = " where katalog.kod_prod like 't%' and ((katalog.kod_prod like 't%".$_GET['vyraz']."%') OR (katalog.nazev like '%".$_GET['vyraz']."%') OR (katalog.text like '%".$_GET['vyraz']."%')) group by katalog.kod_prod ";} if ((isset($_GET['kod']))AND ($_GET['kod']!='')) {$where = " where (katalog.kod_prod='".$_GET['kod']."') group by katalog.kod_prod ";} if (isset($_GET['offset'])){$offset = $_GET['offset'];} else {$offset=0;} print "
"; $limit = " limit ".$offset.",7;"; $order = " order by id asc "; $dotaz = "Select * from katalog" ; $vysledek = mysql_query( $dotaz.$where.$order.$limit ) or die( mysql_error() ); $vysledek2 = mysql_query( $dotaz.$where ); $celkem = mysql_num_rows($vysledek2); $poc_str = ceil( ($celkem/7)); $off = 0; $page = ceil(($offset/7)); print "
"; if ($offset!=0) {print "<<<< ";} else {print "<<<< ";} print " ".($page+1)." "; if (($offset+7) <= $celkem) {print " >>>>"; } else {print " >>>>";} print "

"; print "
"; for ($i=0; $i < $poc_str; $i++) { print " "; if ($i == $page) { print "";} print ($i+1); if ($i == $page) { print "";} print ""; $off = $off+7; } print "

"; while ($zaznam = MySQL_Fetch_object($vysledek)) { $kod_prod = ''; $kod_prod = $zaznam -> kod_prod; $kod_prod = "$kod_prod"; $nazev = $zaznam -> nazev; $mekky= $zaznam -> mekky; $stredni= $zaznam -> stredni; $tvrdy= $zaznam ->tvrdy; $vlakno= $zaznam ->vlakno; $kartac= $zaznam ->kartac; $nasada= $zaznam ->nasada; $rozmer= $zaznam ->rozmer; $hmotnost= $zaznam ->hmotnost; $teplota= $zaznam ->teplota; $material= $zaznam ->material; $text= $zaznam ->text; $tm_modra= $zaznam ->tm_modra; $zelena= $zaznam ->zelena; $sv_modra= $zaznam ->sv_modra; $cervena= $zaznam ->cervena; $bila= $zaznam ->bila; $zluta = $zaznam ->zluta; $oranzova= $zaznam ->oranzova; $cerna= $zaznam ->cerna; $kategorie= $zaznam ->kategorie; $cena= $zaznam -> cena; print ""; print ""; print "";} if ($stredni == 'x') {print "";} if ($tvrdy == 'x') {print "";} print "";} if ($kartac != '') {print "
".number_format($kartac, 0,',',' ')."";} if ($nasada != '') {print "
$nasada";} print "";} print ""; print "";} print "";} print "";} print " "; print ""; print " print "
$nazev
$cena Kč*

".substr($kod_prod,1,10)."
"; if ($mekky == 'x') {print ""; if ($vlakno != '') {print "
".number_format($vlakno, 0,',',' ')."
"; if ($rozmer != '') {print "
$rozmer
"; if ($hmotnost!='') {print "
$hmotnost kg
"; if ($teplota!='') {print "
$teplota
"; if ($material!='') {print "
$material
$text
 
"; print "
"; if ($tm_modra == 'x') {print "";} if ($zelena == 'x') {print " ";} if ($sv_modra == 'x') {print " ";} if ($cervena == 'x') {print " ";} if ($bila == 'x') {print " ";} if ($zluta == 'x') {print " ";} if ($oranzova == 'x') {print " ";} if ($cerna == 'x') {print " ";} if (($tm_modra =='') and ($zelena == '') and ($sv_modra == '') and ($cervena == '') and ($bila == '') and ($zluta == '') and ($oranzova == '') and ($cerna == '')) {print " ";} print "
"; print "
"; //
$kategorie
$cena

"; } print "
* uvedené ceny jsou bez DPH 21%
"; print ""; print "

"; $off = 0; for ($i=0; $i < $poc_str; $i++) { print " "; if ($i == $page) { print "";} print ($i+1); if ($i == $page) { print "";} print ""; $off = $off+7; } print "

"; if ($offset!=0) {print "<<<< ";} else {print "<<<< ";} print " ".($page+1)." "; if (($offset+7) <= $celkem) {print " >>>>"; } else {print " >>>>";} if ((isset($_GET['vyraz']))AND ($_GET['vyraz']!='')) {print "

";} print "

"; include('akce_katalog.php'); print "
"; } print "
"; ?>