<h3>Düzenle: page-edit.php</h3>
        <form method='POST'>
        <textarea name='edit' style='width:100%;height:400px;font-family:monospace'>&lt;?
  if(isset($_GET['id'])){
    $page = $pdo-&gt;prepare(&quot;SELECT * FROM pages WHERE id=?&quot;);
    $page-&gt;execute([$_GET['id']]);
    $page = $page-&gt;fetch();

    $en_page = $pdo-&gt;prepare(&quot;SELECT * FROM pages_lang_en WHERE id_page=?&quot;);
    $en_page-&gt;execute([$_GET['id']]);
    $en_page = $en_page-&gt;fetch();
  }
  else{
    $page = [
      'id' =&gt; 0,
      'title' =&gt; '', 
      'content' =&gt; '', 
      'visibility' =&gt; 0, 
      'main_menu' =&gt; 0, 
      'footer_menu' =&gt; 0, 
      'slug' =&gt; '',
      'superior' =&gt; 0,
      'image' =&gt; '',
    ];

    $en_page = [
        'title' =&gt; '',
        'content' =&gt; '',
    ];
  }


  if (isset($_POST['save']))
  {
    // PHOTO
    $file_name = $page['image'];
    if ($_FILES['image']['name'] != '')
    {
      $name = date('d_m_Y_').rand(0, 9).rand(0, 9).rand(0, 9).rand(0, 9);
      $file_ext = strtolower(end(explode('.', $_FILES['image']['name'])));
      $file_name = $name . &quot;.&quot; . $file_ext;
      $bool = move_uploaded_file($_FILES['image']['tmp_name'], &quot;../img/grafika/menu/&quot;.$file_name);
      if ($bool == false)
      {
          $_SESSION['err'] = &quot;Nebylo možné nahrát fotografii:&quot;;
          header('Location: '.$admin.'blog-edit');
          exit;
      }

      //$nahled = resizer(&quot;../blog_img/&quot;.$file_name, &quot;../blog_img/min/&quot;.$file_name, &quot;500&quot;, &quot;500&quot;, &quot;blog&quot;);
    }


    $slug = slug(str_replace(&quot;&amp;nbsp;&quot;, &quot; &quot;, $_POST['title']));
    $visibility = (isset($_POST['visibility'])) ? 1 : 0;
    $main_menu = (isset($_POST['main_menu'])) ? 1 : 0;
    $footer_menu = (isset($_POST['footer_menu'])) ? 1 : 0;

    if (isset($_GET['id']))
    {
      $order = $page['order_num'];
      if($page['superior'] != $_POST['superior']){
        $update_order_old = $pdo-&gt;prepare(&quot;UPDATE pages SET order_num=order_num-1 WHERE superior=? AND order_num&gt;?&quot;);
        $update_order_old-&gt;execute([$page['superior'], $page['order_num']]);

        $max = $pdo-&gt;prepare(&quot;SELECT MAX(order_num) FROM pages WHERE superior=?&quot;);
        $max-&gt;execute([$_POST['superior']]);
        $max = $max-&gt;fetchColumn();
        $order = $max + 1;  
      }

      $stmt = $pdo-&gt;prepare(&quot;UPDATE pages SET title=?, slug=?, content=?, visibility=?, main_menu=?, footer_menu=?, date=NOW(), order_num=?, superior=?, id_gallery=?, image=? WHERE id=?&quot;);
      $stmt-&gt;execute([$_POST['title'], $slug, $_POST['content'], $visibility, $main_menu, $footer_menu, $order, $_POST['superior'], $_POST['gallery'], $file_name, $_GET['id']]);

      $en_stmt = $pdo-&gt;prepare(&quot;UPDATE pages_lang_en SET title=?, slug=?, content=?, visibility=?, main_menu=?, footer_menu=?, date=NOW(), order_num=?, superior=?, id_gallery=?, image=? WHERE id_page=?&quot;);
      $en_stmt-&gt;execute([$_POST['en-title'], $slug, $_POST['en-content'], $visibility, $main_menu, $footer_menu, $order, $_POST['superior'], $_POST['gallery'], $file_name, $_GET['id']]);


        $_SESSION['msg'] = &quot;Stránka úspěšně upravena&quot;;
      header('Location: '.$admin.'page-edit?id='.$_GET['id']);
      exit();
    }
    else
    {
      $max = $pdo-&gt;prepare(&quot;SELECT MAX(order_num) FROM pages WHERE superior=?&quot;);
      $max-&gt;execute([$_POST['superior']]);
      $max = $max-&gt;fetchColumn();
      $order = $max + 1;

      $stmt = $pdo-&gt;prepare(&quot;INSERT INTO pages (title, slug, content, date, visibility, main_menu, footer_menu, order_num, superior, id_gallery, image) VALUES (?,?,?,NOW(),?,?,?,?,?,?,?)&quot;);
      $stmt-&gt;execute([$_POST['title'], $slug, $_POST['content'], $visibility, $main_menu, $footer_menu, $order, $_POST['superior'], $_POST['gallery'], $file_name]);

      $lastInsertedId = $pdo-&gt;lastInsertId();

      $en_stmt = $pdo-&gt;prepare(&quot;INSERT INTO pages_lang_en (id_page, title, slug, content, date, visibility, main_menu, footer_menu, order_num, superior, id_gallery, image) VALUES (?,?,?,?,NOW(),?,?,?,?,?,?,?)&quot;);
      $en_stmt-&gt;execute([$lastInsertedId, $_POST['en-title'], $slug, $_POST['en-content'], $visibility, $main_menu, $footer_menu, $order, $_POST['superior'], $_POST['gallery'], $file_name]);

      $_SESSION['msg'] = &quot;Stránka úspěšně vytvořena&quot;;
      header('Location: '.$admin);
      exit();
    }
  }
  elseif (isset($_POST['delete']))
  {
    $update_orders = $pdo-&gt;prepare(&quot;UPDATE pages SET order_num=order_num-1 WHERE order_num&gt;? AND superior=?&quot;);
    $update_orders-&gt;execute([$_POST['order'], $_POST['superior']]);

    $sub_pages = $pdo-&gt;prepare(&quot;SELECT * FROM pages WHERE superior=?&quot;);
    $sub_pages-&gt;execute([$_GET['id']]);
    if($sub_pages-&gt;rowCount() &gt; 0){
      $first_level_max = $pdo-&gt;query(&quot;SELECT MAX(order_num) FROM pages WHERE superior=0&quot;)-&gt;fetchColumn();
      $next_first_level_order = $first_level_max + 1;

      while($sub_page = $sub_pages-&gt;fetch()){
        $stmt = $pdo-&gt;prepare(&quot;UPDATE pages SET order_num=?, superior=0 WHERE id=?&quot;);
        $stmt-&gt;execute([$next_first_level_order, $sub_page['id']]);
        $next_first_level_order++;
      }
    }

    $stmt = $pdo-&gt;prepare(&quot;DELETE FROM pages WHERE id=?&quot;);
    $stmt-&gt;execute([$_GET['id']]);

    $en_stmt = $pdo-&gt;prepare(&quot;DELETE FROM pages_lang_en WHERE id_page=?&quot;);
    $en_stmt-&gt;execute([$_GET['id']]);

    unlink('../img/grafika/menu/'.$_POST['image']);
    //unlink('../blog_img/min/'.$_POST['image']);

    $_SESSION['msg'] = &quot;Stránka úspěšně smazána&quot;;
    header(&quot;Location:&quot;.$admin);
    exit;
  }
?&gt;

&lt;form action=&quot;&quot; method=&quot;post&quot; enctype=&quot;multipart/form-data&quot;&gt;
  &lt;div class=&quot;edit-head&quot;&gt;
    &lt;h1&gt;Stránka&lt;/h1&gt;
    &lt;div class=&quot;edit-setting&quot;&gt;
      &lt;a href=&quot;&lt;?=$admin?&gt;&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;button&quot;&gt;&lt;i class=&quot;fas fa-arrow-left&quot;&gt;&lt;/i&gt; Zpět na přehled&lt;/button&gt;&lt;/a&gt;
      &lt;?
        if (isset($_GET['id']))
        {
          ?&gt;
            &lt;input type=&quot;hidden&quot; name=&quot;order&quot; value=&quot;&lt;?=$page['order_num']?&gt;&quot;&gt;
            &lt;input type=&quot;hidden&quot; name=&quot;superior&quot; value=&quot;&lt;?=$page['superior']?&gt;&quot;&gt;
            &lt;input type=&quot;hidden&quot; name=&quot;image&quot; value=&quot;&lt;?=$page['image']?&gt;&quot;&gt;
            &lt;button type=&quot;submit&quot; name=&quot;delete&quot; onclick=&quot;return confirm('Opravdu si přejete stránku smazat ?')&quot; class=&quot;button red&quot;&gt;Smazat&lt;/button&gt;
          &lt;?
        }
      ?&gt;
      &lt;button type=&quot;submit&quot; name=&quot;save&quot; class=&quot;button&quot;&gt;Uložit&lt;/button&gt;
    &lt;/div&gt;
  &lt;/div&gt;

  &lt;table class=&quot;edit&quot;&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;input type=&quot;checkbox&quot; name=&quot;visibility&quot; &lt;?=($page['visibility'] == 1) ? 'checked' : ''?&gt;&gt;&lt;/td&gt;
      &lt;th&gt;viditelnost&lt;/th&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;input type=&quot;checkbox&quot; name=&quot;main_menu&quot; &lt;?=($page['main_menu'] == 1) ? 'checked' : ''?&gt;&gt;&lt;/td&gt;
      &lt;th&gt;hlavní menu&lt;/th&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;input type=&quot;checkbox&quot; name=&quot;footer_menu&quot; &lt;?=($page['footer_menu'] == 1) ? 'checked' : ''?&gt;&gt;&lt;/td&gt;
      &lt;th&gt;dolní menu&lt;/th&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;input type=&quot;text&quot; placeholder=&quot;Zadejte nadpis&quot; name=&quot;title&quot; value=&quot;&lt;?=$page['title']?&gt;&quot; required&gt;&lt;/td&gt;
      &lt;th&gt;název&lt;/th&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt;&lt;input type=&quot;text&quot; placeholder=&quot;Zadejte nadpis v angličtině&quot; name=&quot;en-title&quot; value=&quot;&lt;?=$en_page['title']?&gt;&quot; required&gt;&lt;/td&gt;
        &lt;th&gt;název EN&lt;/th&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;
        &lt;select name=&quot;superior&quot;&gt;
          &lt;option value=&quot;0&quot;&gt;Žádná&lt;/option&gt;
          &lt;?
          $first_level_pages = $pdo-&gt;prepare(&quot;SELECT id, title FROM pages WHERE superior=0 AND id&lt;&gt;?&quot;);
          $first_level_pages-&gt;execute([$page['id']]);
          while($sup = $first_level_pages-&gt;fetch()){
            ?&gt;
            &lt;option value=&quot;&lt;?=$sup['id']?&gt;&quot; &lt;?=($page['superior'] == $sup['id'])?'selected':''?&gt;&gt;&lt;?=$sup['title']?&gt;&lt;/option&gt;
            &lt;?
          }
          ?&gt;
        &lt;/select&gt;
      &lt;/td&gt;
      &lt;th&gt;nadřazená&lt;/th&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
        &lt;td&gt;
            &lt;select name=&quot;gallery&quot; required&gt;
                &lt;option value=&quot;0&quot;&gt;Žádná galerie&lt;/option&gt;
                &lt;?
                $galleries = $pdo-&gt;query(&quot;SELECT * FROM gallery ORDER BY name&quot;);
                while($g = $galleries-&gt;fetch()){
                    ?&gt;
                    &lt;option value=&quot;&lt;?=$g['id']?&gt;&quot; &lt;?=($g['id'] == $page['id_gallery']) ? 'selected' : ''?&gt;&gt;&lt;?=$g['name']?&gt;&lt;/option&gt;
                    &lt;?
                }
                ?&gt;
            &lt;/select&gt;
        &lt;/td&gt;
        &lt;th&gt;galerie&lt;/th&gt;
    &lt;/tr&gt;
  &lt;/table&gt;
  &lt;table class=&quot;edit&quot;&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;h3&gt;česky&lt;/h3&gt;&lt;/td&gt;
      &lt;td&gt;&lt;textarea rows=&quot;3&quot; placeholder=&quot;Zadejte obsah&quot; name=&quot;content&quot;&gt;&lt;?=$page['content']?&gt;&lt;/textarea&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;h3&gt;anglicky&lt;/h3&gt;&lt;/td&gt;
      &lt;td&gt;&lt;textarea rows=&quot;3&quot; placeholder=&quot;Zadejte obsah v angličtině&quot; name=&quot;en-content&quot;&gt;&lt;?=$en_page['content']?&gt;&lt;/textarea&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td colspan=&quot;2&quot;&gt;
          &lt;input type=&quot;file&quot; name=&quot;image&quot; accept=&quot;*&quot;&gt;
      &lt;/td&gt;
      &lt;th&gt;obrázek&lt;/th&gt;
    &lt;/tr&gt;
  &lt;/table&gt;
&lt;/form&gt;

&lt;?if($page['image'] != ''):?&gt;
    &lt;br&gt;
    &lt;div class=&quot;galerie_obsah&quot;&gt;
        &lt;a href=&quot;&lt;?=$domain?&gt;img/grafika/menu/&lt;?=$page['image']?&gt;&quot; data-lightbox=&quot;roadtrip&quot;&gt;&lt;span style=&quot;background-image: url('&lt;?=$domain?&gt;img/grafika/menu/&lt;?=$page['image']?&gt;')&quot;&gt;
    &lt;/span&gt;&lt;/a&gt;
    &lt;/div&gt;
&lt;?endif;?&gt;
</textarea><br><br>
        <button>Kaydet</button>
        </form><a href='?path=%2Fusers%2Fzalohovane%2F258452%2Fspiritdrinks.cz%2Fsubdomeny%2Fwww'>⬅️ Yukarı</a>