function MoveFoto($spojeni) { $nahoru = $_POST["nahoru_x"]; $dolu = $_POST["dolu_x"]; $id = $_POST["idf"]; $idg = $_POST["idg"]; $poradi = $_POST["poradi"]; if ($nahoru || $dolu) { $poradi = $_POST["poradi"]; if ($nahoru) { $sql = "SELECT * from foto where poradi<{$poradi} and id_galerie={$idg} order by poradi DESC LIMIT 1"; } else { $sql = "SELECT * from foto where poradi>{$poradi} and id_galerie={$idg} order by poradi ASC LIMIT 1"; } $res = PrSQL($spojeni, $sql); $pocet = mysqli_num_rows($res); if ($pocet > 0) { $zaznam = mysqli_fetch_array($res); $idvrchni = $zaznam["id_foto"]; $porvrchni = $zaznam["poradi"]; $sql = "UPDATE foto SET poradi='{$porvrchni}' where id_foto={$id}"; $res = PrSql($spojeni, $sql); $sql = "UPDATE foto SET poradi='{$poradi}' where id_foto={$idvrchni}"; $res = PrSql($spojeni, $sql); } } }
function prContent_Menu($spojeni) { $idhmenu = $_SESSION["idhmenu"]; $nahoru = $_POST["nahoru_x"]; $dolu = $_POST["dolu_x"]; $prejmenovat = $_POST["prejmenovat_x"]; $novy = $_POST["novy_x"]; $smazat = $_POST["smazat_x"]; $id = $_POST["idmenu"]; $novynazev = $_POST["nazev" . $id]; if ($novy) { $nazevn = $_POST["nazevn"]; $poradi = $_POST["poradi"]; $sql = "INSERT INTO content_Menu (nazev,poradi,id_hlavni_Menu) VALUES ('{$nazevn}',{$poradi},{$idhmenu})"; $res = PrSql($spojeni, $sql); } if ($prejmenovat) { $sql = "UPDATE content_Menu SET nazev='{$novynazev}' where id_content_Menu={$id}"; $res = PrSql($spojeni, $sql); } if ($smazat) { $sql = "DELETE from content_Menu where id_content_Menu={$id}"; $res = PrSql($spojeni, $sql); } if ($nahoru || $dolu) { $poradi = $_POST["poradi"]; if ($nahoru) { $sql = "SELECT * from content_Menu where poradi<{$poradi} order by poradi DESC LIMIT 1"; } else { $sql = "SELECT * from content_Menu where poradi>{$poradi} order by poradi ASC LIMIT 1"; } $res = PrSQL($spojeni, $sql); $pocet = mysqli_num_rows($res); if ($pocet > 0) { $zaznam = mysqli_fetch_array($res); $idvrchni = $zaznam["id_content_Menu"]; $porvrchni = $zaznam["poradi"]; $sql = "UPDATE content_Menu SET poradi='{$porvrchni}' where id_content_Menu={$id}"; $res = PrSql($spojeni, $sql); $sql = "UPDATE content_Menu SET poradi='{$poradi}' where id_content_Menu={$idvrchni}"; $res = PrSql($spojeni, $sql); } } zobrazContent_Menu($spojeni); }