function zobrazObsahDomu($spojeni) { $idlmenu = $_GET["lmenu"]; $index = $_GET["index"]; $iddum = $_GET["id"]; $idmenu = $_GET["menu"]; if (!$iddum) { $sql = "SELECT * from domy where id_lDolniMenu={$idlmenu} order by poradi asc limit 1"; $res = PrSql($spojeni, $sql); $pocet = mysqli_num_rows($res); if ($pocet > 0) { $zaznam = mysqli_fetch_array($res); $iddum = $zaznam["id_dum"]; } else { ZobrazUvod(); return; } } else { $sql = "SELECT nazev from domy where id_dum={$iddum}"; $res = PrSql($spojeni, $sql); $zaznam = mysqli_fetch_array($res); } $nazevdomu = $zaznam["nazev"]; setlocale(LC_ALL, 'czech'); $input = iconv('UTF-8', 'us-ascii//TRANSLIT', $nazevdomu); $input = preg_replace('/[^a-zA-Z0-9]/', '_', $input); $input = strtolower($input); $sql = "SELECT * FROM domy_Menu where id_dum={$iddum} order by poradi"; $res = PrSql($spojeni, $sql); $pocet = mysqli_num_rows($res); ?> <!-- obsah slideru - karty domu starrt --> <div class="index-1"> <div class="slider-wrapper"> <div class="slider-left"> <div class="slider-right"> <div id="slides"> <div id="karta-domu33"> <div class="house-name"><h2><?php echo $nazevdomu; ?> </h2></div> <div class="menukarta"> <nav id="main-menu-karta"> <div class="menuback-karta"> </div> <ul class="menu-karta responsive-menu"> <?php $i = 0; while ($zaznam = mysqli_fetch_array($res)) { if (!$idmenu && $i == 0 || $idmenu == $zaznam["id_domy_Menu"]) { $active = "class=\"active\""; $typmenu = $zaznam["typ"]; if (!$idmenu) { $idmenu = $zaznam["id_domy_Menu"]; } } else { $active = ""; } ?> <li> <a <?php echo $active; ?> href="maison-<?php echo $input; ?> -<?php echo $idlmenu; ?> -<?php echo $index; ?> -<?php echo $iddum; ?> -<?php echo $zaznam["id_domy_Menu"]; ?> .html<?php //echo $index ?> "> <?php echo $zaznam["nazev"]; ?> </a> </li> <?php $i = $i + 1; } ?> </ul> </nav> </div> <?php switch ($typmenu) { case "V": ?> <div class="slides_container"><?php $sql = "SELECT * FROM domy_Data where id_domy_Menu={$idmenu} order by poradi"; $res = PrSql($spojeni, $sql); $pocet = mysqli_num_rows($res); $i = 1; while ($zaznam = mysqli_fetch_array($res)) { ?> <div class="slide"> <a rel="example_group" id="example<?php echo $i; ?> " href="<?php echo $zaznam["soubor"]; ?> " > <img src="<?php echo $zaznam["nahled"]; ?> " alt="chalet, maison, fer forge"/> </a> </div> <?php $i = $i + 1; } ?> </div><?php break; case "P": ?> <div id="karta-tabulka"> <?php $sql = "SELECT * FROM domy_Data where id_domy_Menu={$idmenu} and typ='T' order by poradi"; $res = PrSql($spojeni, $sql); $pocet = mysqli_num_rows($res); if ($pocet) { $zaznam = mysqli_fetch_array($res); $text = $zaznam["text"]; echo $text; } ?> </div> <div class="slides_container pudorys"><?php $sql = "SELECT * FROM domy_Data where id_domy_Menu={$idmenu} and typ='O' order by poradi"; $res = PrSql($spojeni, $sql); $pocet = mysqli_num_rows($res); $i = 1; while ($zaznam = mysqli_fetch_array($res)) { ?> <div class="slide"> <a rel="example_group" id="example<?php echo $i; ?> " href="<?php echo $zaznam["soubor"]; ?> " > <img src="<?php echo $zaznam["nahled"]; ?> " alt="chalet, maison, fer forge" /> </a> </div> <?php $i = $i + 1; } ?> </div><?php break; case "D": ?> <div id="text-v-karte"><?php $sql = "SELECT * FROM domy_Data where id_domy_Menu={$idmenu} and typ='T' order by poradi"; $res = PrSql($spojeni, $sql); $pocet = mysqli_num_rows($res); if ($pocet) { $zaznam = mysqli_fetch_array($res); $text = $zaznam["text"]; echo $text; } ?> </div> <div class="slides_container"> <div class="slide"><img src="images/white.jpg" alt="chalet, maison, fer forge" /></div> </div> <?php break; case "K": ?> <div id="text-v-karte"><?php $sql = "SELECT * FROM domy_Data where id_domy_Menu={$idmenu} and typ='T' order by poradi"; $res = PrSql($spojeni, $sql); $pocet = mysqli_num_rows($res); if ($pocet) { $zaznam = mysqli_fetch_array($res); $text = $zaznam["text"]; echo $text; } $sql = "SELECT * FROM domy_Data where id_domy_Menu={$idmenu} and typ='S' order by poradi"; $res = PrSql($spojeni, $sql); $pocet = mysqli_num_rows($res); if ($pocet > 0) { ?> <br><ul class="soubory"><?php $i = 1; while ($zaznam = mysqli_fetch_array($res)) { ?> <li><img alt="chalet, maison, fer forge" src="images/file.png" height="25"/> <a target="_new" href="<?php echo $zaznam["soubor"]; ?> " ><?php echo $zaznam["text"]; ?> </a> </li> <?php $i = $i + 1; } } ?> </ul> </div> <div class="slides_container"> <div class="slide"><img src="images/white.jpg" alt="" /></div> </div> <?php break; default: ?> <div class="slides_container"> <div class="slide"><img src="images/white.jpg" alt="" /></div> </div> <?php } ?> </div> </div> </div> </div> </div> </div> <!-- obsah slideru karty domu konec --> <?php }
case "zobrazKontakt": zobrazKontakt($spojeni); break; case "zobrazGalerie": zobrazGalerie($spojeni); break; case "zobrazContentMenu": zobrazContentMenu($spojeni); break; case "zobrazdum": zobrazObsahDomu($spojeni); break; case "zobrazkontakt": ZobrazKontakt($spojeni); break; case "zobrazVzkazy": ZobrazVzkazy($spojeni); break; default: ZobrazUvod($spojeni); } ?> <div id="strdole"> <div class="strana"> <div class="footpage"><p><strong> (c)Rekreační stáje Řídeč - www.koneridec.cz - výlety na koních, +420 604 307 804<span style="float:right"> Vyrobil: Ctibor Venus - <a href="http://www.ctiborvenus.eu">www.ctiborvenus.eu</a></strong></span></p></div> </div> </div> </body></html>
function zobrazHlavni_Menu($spojeni) { ZobrazUvod($spojeni, 0, 2); $sql = "SELECT * FROM hlavni_Menu order by poradi"; $res = PrSql($spojeni, $sql); $pocet = mysqli_num_rows($res); ?> <table border="1" width="500"> <tr> <th>Názvy</th> <th>Typ</th> <th>Přidat údaje</th> </tr> <script language="JavaScript"> function KontrolaNazvu(id) { var nazevform = "content_Menu" + id; var nazevpole = "nazev" + id; var text_jmena = document.forms[nazevform][nazevpole].value; var je_ok = text_jmena != ""; if (je_ok == false) alert('Nebyl zadán název menu!'); return je_ok; } </script> <?php if ($pocet > 0) { $i = 0; while ($zaznam = mysqli_fetch_array($res)) { $poradi = $zaznam["poradi"]; ?> <tr> <td> <?php echo $zaznam["nazevvetsi"] . " " . $zaznam["nazevmensi"]; ?> </td> <td> <?php echo $zaznam["typ"]; ?> </td> <td> <?php switch ($zaznam["typ"]) { case "M": ?> <a href="?cmd=zobrazcontent_Menu&idm=<?php echo $zaznam["id_hlavni_Menu"]; ?> ">Editovat submenu</a><?php break; case "G": ?> <a href="?cmd=zobrazcontent_Menu&idm=<?php echo $zaznam["id_hlavni_Menu"]; ?> ">Editovat submenu</a> , <?php ?> <a href="../galerie/admin.php">Editovat galerii</a><?php break; case "T": ?> <a href="?cmd=edithlavni_Data&idm=<?php echo $zaznam["id_hlavni_Menu"]; ?> ">Editovat text</a><?php break; case "K": break; } ?> </td> </form> </tr> <?php $i = $i + 1; } } // END function ZobrazPrilohy ?> </table> <?php }