" . $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 "" . $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 "
Bližší informace o tomto umělci naleznete na: " . $umelci[$id_cloveka]["odkaz"] . "
"; } // echo ""; ?>![](\"https://".$_SERVER['HTTP_HOST']."/design/tisk.gif\")
vytisknout![](\"https://".$_SERVER['HTTP_HOST']."/design/email.gif\")
poslat e-mailem
