Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once 'db.php';
- if(isset($_GET['url']) AND $_GET['url']!='')
- {
- $url = $_GET['url'];
- }
- //složí na zobrazování velikostí
- class velikost {
- static public $dam=array();
- static public $pan=array();
- public function nastav($string0,$string1) {
- //string 2 v db je unisex takže uložime do obou polí
- if ($string1==2) {
- array_push(self::$dam, $string0);
- array_push(self::$pan, $string0);
- } elseif ($string1==1) {
- array_push(self::$pan, $string0);
- } else {
- array_push(self::$dam, $string0);
- }
- }
- }
- if (!isset($url)) {
- echo
- '<!DOCTYPE html>
- <head>
- <title>Grandmaster.cz</title>
- <meta http-equiv="content-type" content="text/html;charset=utf-8">
- <meta name="description" content="Nejlepší trička s potiskem"/>
- <link href="style.css" rel="stylesheet" type="text/css">
- <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
- <script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.10.4/jquery-ui.min.js"></script>
- <script src="imod.js"></script>
- </head>
- <body>
- <div class="top">
- <div class="header">
- <a href="/"><img src="images/logo.png" alt="GrandMaster.cz" style="float: left"></a>
- </div>
- </div>
- <div id="filtr">
- <p id="in_filtr">Seřadit podle: Nejnovějších</p>
- <input type="radio" name="zobrazit" value="1" checked="checked">
- <p id="in_filtr">Nejlevnějších</p>
- <input type="radio" name="zobrazit" value="2">
- <select id="barva" name="barva">
- <option value="1">Všechny barvy</option>';
- //načtení všech barev z tabulky param
- $options = mysql_query("SELECT DISTINCT `hodnota` FROM `param` WHERE `parametr`='Barva'");
- while ($row=mysql_fetch_assoc($options)) {
- echo '<option value="'.$row['hodnota'].'">'.$row['hodnota'].'</option>';
- }
- echo '
- </select>
- <select id="velikost" name="velikost">
- <option value="1">Všechny velikosti</option>
- <option value="S">S</option>
- <option value="M">M</option>
- <option value="L">L</option>
- <option value="XL">XL</option>
- <option value="XXL">XXL</option>
- </select>
- </div>
- <div class="main">';
- //zobrazeni polozek
- $query = mysql_query("SELECT `url`,`jmeno`,`cena`,`puvodni_cena`,`img` FROM `polozky` LIMIT 0,40");
- while ($result=mysql_fetch_assoc($query)) {
- echo '
- <div id="polozka">
- <a href="'.$result['url'].'">
- <img src="thump.php?obrazek='.$result['img'].'" alt="'.$result['jmeno'].'" >
- <p id="jmeno">'.zkrattext($result['jmeno']).'</p>
- <p id="cena">'.$result['cena'].' Kč</p>';
- //pokud puvodni cena neni 0
- if ($result['puvodni_cena']!=0) {
- echo '<p id="orig_cena">'.$result['puvodni_cena'].' Kč</p>';
- }
- echo '
- </a>
- </div>'
- ;
- }
- echo'
- </div>
- </body>
- </html>';
- } else {
- //kontrola jestli url existuje v db
- if(mysql_result(mysql_query("SELECT COUNT(*) FROM `polozky` WHERE `url`='".mysql_real_escape_string($url)."'"), 0)) {
- $query = mysql_fetch_assoc(mysql_query("SELECT * FROM `polozky` WHERE `url`='".mysql_real_escape_string($url)."'"));
- echo
- '<!DOCTYPE html>
- <head>
- <title>'.$query['jmeno'].'</title>
- <meta http-equiv="content-type" content="text/html;charset=utf-8">
- <meta name="description" content="Nejlepší trička s potiskem"/>
- <link href="style.css" rel="stylesheet" type="text/css">
- <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
- <script src="imod.js"></script>
- </head>
- <body>
- <div class="top">
- <div class="header">
- <a href="/"><img src="images/logo.png" alt="GrandMaster.cz" style="float: left"></a>
- </div>
- </div>
- <div class="main">
- <div id="galery">
- <div id="main_photo">
- <img src="thump.php?type=big&obrazek='.$query['img'].'">
- </div>
- <div id="cont">
- <div id=minimg><img id="mini" src="thump.php?type=min&obrazek='.$query['img'].'"></div>';
- $query2= mysql_query("SELECT `url` FROM `image` WHERE `produkt`='".$query['id']."'");
- WHILE ($row=mysql_fetch_assoc($query2)) {
- echo '<div id=minimg><img id="mini" src="thump.php?type=min&obrazek='.$row['url'].'"></div>';
- }
- echo
- '</div>
- </div>
- <div class="right">
- <h1>'.$query['jmeno'].'</h1>
- <p id="popisek">';
- $query2= mysql_query("SELECT `parametr`,`hodnota` FROM `param` WHERE `produkt`='".$query['id']."'");
- WHILE ($row=mysql_fetch_assoc($query2)) {
- echo $row['parametr']." ".$row['hodnota'].", ";
- }
- echo '
- </p>';
- $query2=mysql_query("SELECT `velikost`,`sex` FROM `variant` WHERE `produkt`='".$query['id']."'");
- $obj = new velikost();
- WHILE ($row=mysql_fetch_assoc($query2)) {
- //uložime velikosti do array
- //dvojka rovna se unisex uložime do obou polí
- $obj->nastav($row['velikost'],$row['sex']);
- }
- // pokud existuje velikost v poli, tak ji zobrazíme
- if (count(velikost::$dam)>0) {
- echo'<p id="val">Dámské : ';
- foreach (velikost::$dam as &$val) {
- echo $val.", ";
- }
- echo '</p>';
- }
- if (count(velikost::$pan)>0) {
- echo'<p id="val">Pánské : ';
- foreach (velikost::$pan as &$val) {
- echo $val.", ";
- }
- echo '</p>';
- }
- echo '<p id="descrip">'.$query['popis'].'</p>
- <a id="buy" href="http://www.trikator.cz/'.$query['url'].'">Koupit</a>
- <p id="price">'.$query['cena'].' Kč</p>';
- //pokud cena neni nula tak zobrazime starou cenu
- if ($query['puvodni_cena']!=0) {
- echo '<p id="price_orig">'.$query['puvodni_cena'].' Kč</p>';
- }
- echo '
- </div>
- </body>
- </html>';
- } else {
- echo '<!DOCTYPE html>
- <head>
- <title>Požadovaná stránka nebyla nalezena</title>
- <meta http-equiv="content-type" content="text/html;charset=utf-8">
- </head>
- <body>
- <h1>Požadovaná stránka nebyla nalezena</h1>
- </body>
- </html>';
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement