query('SELECT * FROM umelci WHERE id=:id'); $database->bind(':id', $id_cloveka); $vyberumelce2 = $database->single(); $umelci[$vyberumelce2["id"]]["jmeno"] = $vyberumelce2["jmeno"]; $umelci[$vyberumelce2["id"]]["prijmeni"] = $vyberumelce2["prijmeni"]; $umelci[$vyberumelce2["id"]]["odkaz"] = $vyberumelce2["odkaz"]; $umelci[$vyberumelce2["id"]]["dodatek"] = $vyberumelce2["dodatek"]; echo "

" . $umelci[$id_cloveka]["jmeno"] . " " . $umelci[$id_cloveka]["prijmeni"] . " " . $umelci[$id_cloveka]["dodatek"] . "

"; $database->query('SELECT p.id,p.terminy,p.nazev,p.popisek,p.nazev_seo FROM porad p, akce a,cast c WHERE a.id_porad=p.id AND c.id_show=p.id AND a.datum>:datum AND c.id_actor=:id_actor AND p.id!=0 AND p.zobrazit=1 group by p.id ORDER BY INSTR(\'AÁaáBbCČcčDĎdďEÉeéFfGgHhIÍiíJjKkLlMmNnOoÓóPpQqRrŘřSsŠšTtŤťUÚŮuúůVvWwXxYyÝýZzŽž\',SUBSTRING(p.nazev,1,1)) ASC, SUBSTRING(p.nazev,2) ASC'); $database->bind(':datum',$dnesnidatum); $database->bind(':id_actor',$id_cloveka); $vyberporad = $database->resultset(); foreach ($vyberporad as $vyberporad2){ $database->query('SELECT d.mesto,d.nazev, (select datum from akce where id_porad=:id_porad2 AND datum>:datum2 and id_vstupne=v.id order by datum ASC limit 0,1) as datum1, (select datum from akce where id_porad=:id_porad3 AND datum>:datum3 and id_vstupne=v.id order by datum ASC limit 1,1) as datum2, (select datum from akce where id_porad=:id_porad4 AND datum>:datum4 and id_vstupne=v.id order by datum ASC limit 2,1) as datum3 FROM akce a,vstupne v,sal s,divadlo d WHERE d.id=s.id_divadlo AND v.id_sal=s.id AND a.id_vstupne=v.id AND a.id_porad=:id_porad AND a.datum>:datum group by s.id order by a.datum ASC LIMIT 3'); $database->bind(':id_porad2',$vyberporad2["id"] ); $database->bind(':id_porad3',$vyberporad2["id"] ); $database->bind(':id_porad4',$vyberporad2["id"] ); $database->bind(':id_porad',$vyberporad2["id"] ); $database->bind(':datum',$dnesnidatum); $database->bind(':datum2',$dnesnidatum); $database->bind(':datum3',$dnesnidatum); $database->bind(':datum4',$dnesnidatum); $blizkeakce = $database->resultset(); $zobrazit = "ano"; echo "
"; $obrazek = get_headers("https://" . $_SERVER['HTTP_HOST'] . "/fotky/" . $vyberporad2["id"] . "/nahled.jpg"); if ($obrazek[0] == "HTTP/1.1 200 OK") { echo "
\""
"; } else { echo "
\""
"; } echo "

" . $vyberporad2["nazev"] . "
" . $vyberporad2["popisek"] . "
"; $database->query('SELECT u.prijmeni,u.jmeno FROM cast c,umelci u WHERE c.id_actor=u.id AND c.id_show=:showid AND c.id_role=1 ORDER BY c.position ASC LIMIT 3'); $database->bind(':showid', $vyberporad2['id']); $actors = $database->resultset(); if (!empty($actors)) { echo 'Hrají: '; $counter = 0; foreach ($actors as $actor) { if ($counter > 0) { echo ', '; } echo $actor['jmeno'] . ' ' . $actor['prijmeni']; $counter++; } echo '
'; } $pocitadlo = 0; foreach ($blizkeakce as $blizkeakce2){ if ($pocitadlo != 0) { echo "
"; } echo "" . $blizkeakce2["mesto"] . ", " . $blizkeakce2["nazev"] . " "; if (!empty($vyberporad2["terminy"])) { echo $vyberporad2["terminy"]; } else { if ($blizkeakce2["datum1"] != "") { echo substr($blizkeakce2["datum1"], 6, 2) . "." . substr($blizkeakce2["datum1"], 4, 2) . "."; } if ($blizkeakce2["datum2"] != "") { echo ", " . substr($blizkeakce2["datum2"], 6, 2) . "." . substr($blizkeakce2["datum2"], 4, 2) . "."; } if ($blizkeakce2["datum3"] != "") { echo ", " . substr($blizkeakce2["datum3"], 6, 2) . "." . substr($blizkeakce2["datum3"], 4, 2) . "."; } echo ""; } $pocitadlo = 1; } echo "

"; } echo "
"; if (!empty($umelci[$id_cloveka]["odkaz"])) { echo "

Bližší informace o tomto umělci naleznete na: " . $umelci[$id_cloveka]["odkaz"] . "

"; } // echo "
vytisknout     poslat e-mailem
"; ?> Bookmark and Share
TOPlist