SELECT * FROM zamestnanci

SELECT * FROM zamestnanci ORDER BY prijmeni

SELECT * FROM zamestnanci WHERE id > 2

SELECT * FROM zamestnanci WHERE id > 2 ORDER BY prijmeni

SELECT * FROM jidlo 
INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id
ORDER BY cena

SELECT jidlo.nazev, cena, kategorie.nazev FROM jidlo 
INNER JOIN kategorie ON jidlo.id_kategorie = kategorie.id
ORDER BY cena

SELECT * FROM jidlo
WHERE nazev LIKE '%pizza%'


    <script src="https://cdn.jsdelivr.net/npm/@fancyapps/ui@5.0/dist/fancybox/fancybox.umd.js"></script>
    <link
    rel="stylesheet"
    href="https://cdn.jsdelivr.net/npm/@fancyapps/ui@5.0/dist/fancybox/fancybox.css"
    />

    <script>
        Fancybox.bind('[data-fancybox="gallery"]', {
            });
    </script>

            echo "<a
                    data-fancybox='gallery'
                    data-src='{$data["url"]}'
                    data-caption='{$data["nazev"]}'
                    >";
            echo "</a>";