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


if (isset($_POST['save']))
{
  $visibility = (isset($_POST['visibility'])) ? 1 : 0;
  $gallery_page = (isset($_POST['gallery_page'])) ? 1 : 0;
  
  if (isset($_GET['id']))
  {
    
    // images
    if ($_FILES['file']['name'][0] != '')
    {
      foreach ($_FILES['file'] as $key =&gt; $value)
      {
        foreach ($value as $key2 =&gt; $value2)
        {
          $new[$key2][$key] = $value2;
        }
      }

      $gallery = $_GET['id'];

      foreach ($new as $value)
      {
        $name = date('d_m_Y_').rand(0, 9).rand(0, 9).rand(0, 9).rand(0, 9);
        $file_ext = strtolower(end(explode('.', $value['name'])));
        $file_name = $name . &quot;.&quot; . $file_ext;
        $bool = move_uploaded_file($value['tmp_name'], &quot;../gallery_img/&quot;.$file_name);
        if ($bool == false)
        {
          $_SESSION['err'] = &quot;Nebylo možné nahrát fotografii&quot;;
          header('Location: '.$admin.'gallery');
          exit();
        }

        //get max order
        $max = $pdo-&gt;prepare(&quot;SELECT MAX(order_num) FROM gallery_content WHERE gallery=?&quot;);
        $max-&gt;execute([$gallery]);
        $max = $max-&gt;fetchColumn();
        $order = $max + 1;

        $insert = $pdo-&gt;prepare(&quot;INSERT INTO gallery_content (gallery, path, order_num) VALUES (?,?,?)&quot;);
        $insert-&gt;execute([$gallery, $file_name, $order]);

        $nahled = resizer(&quot;../gallery_img/&quot;.$file_name, &quot;../gallery_img/min/&quot;.$file_name, &quot;400&quot;, &quot;385&quot;);
      }
    }

    $stmt = $pdo-&gt;prepare(&quot;UPDATE gallery SET name=?, visibility=?, gallery_page=?, last_edited=NOW() WHERE id=?&quot;);
    $stmt-&gt;execute([$_POST['name'], $visibility, $gallery_page, $_GET['id']]);

    $_SESSION['msg'] = &quot;Galerie úspěšně upravena&quot;;
    header(&quot;Location:&quot;.$admin.'gallery-edit?id='.$_GET['id']);
  }
  else
  {
    $stmt = $pdo-&gt;prepare(&quot;INSERT INTO gallery (name, visibility, gallery_page, created, last_edited) VALUES (?,?,?,NOW(), NOW())&quot;);
    $stmt-&gt;execute([$_POST['name'], $visibility, $gallery_page]);

    $_SESSION['msg'] = &quot;Galerie úspěšně vytvořena&quot;;
    header(&quot;Location:&quot;.$admin.'gallery');
  }

  exit;
}
elseif(isset($_POST['delete'])){
  $delete_gallery = $pdo-&gt;prepare('DELETE FROM gallery WHERE id=?');
  $delete_gallery-&gt;execute([$_GET['id']]);

  $deleted_items = $pdo-&gt;prepare('SELECT * FROM gallery_content WHERE gallery=?');
  $deleted_items-&gt;execute([$_GET['id']]);
  while($item = $deleted_items-&gt;fetch()){
    unlink('../gallery_img/'.$item['path']);
    unlink('../gallery_img/min/'.$item['path']);
    $delete_item = $pdo-&gt;prepare(&quot;DELETE FROM gallery_content WHERE id=?&quot;);
    $delete_item-&gt;execute([$item['id']]);
  }
  
  $_SESSION['msg'] = &quot;Galerie úspěšně smazána&quot;;
  header(&quot;Location:&quot;.$admin.'gallery');
  exit;
}
elseif (isset($_POST['delete_image']))
{
  $deleted = $pdo-&gt;prepare(&quot;SELECT * FROM gallery_content WHERE id=?&quot;);
  $deleted-&gt;execute([$_POST['id']]);
  $deleted = $deleted-&gt;fetch();

  $order = $deleted['order_num'];

  $update_after = $pdo-&gt;prepare(&quot;UPDATE gallery_content SET order_num=order_num-1 WHERE order_num&gt;? AND gallery=?&quot;);
  $update_after-&gt;execute([$order, $deleted['gallery']]);

  $delete = $pdo-&gt;prepare(&quot;DELETE FROM gallery_content WHERE id=?&quot;);
  $delete-&gt;execute([$_POST['id']]);

  $_SESSION['msg'] = &quot;Fotografie úspěšně smazána&quot;;
  header(&quot;Location:&quot;.$admin.'gallery-edit?id='.$_GET['id']);
  unlink('../gallery_img/'.$_POST['path']);
  unlink('../gallery_img/min/'.$_POST['path']);
  exit;
}

elseif(isset($_POST['move_left'])){
  $shifted = $pdo-&gt;prepare(&quot;SELECT * FROM gallery_content WHERE id=?&quot;);
  $shifted-&gt;execute([$_POST['id']]);
  $shifted = $shifted-&gt;fetch();
  $order = $shifted['order_num'];
  $switch_order = $order - 1;
  $switch_item = $pdo-&gt;prepare(&quot;SELECT * FROM gallery_content WHERE order_num=? AND gallery=?&quot;);
  $switch_item-&gt;execute([$switch_order, $shifted['gallery']]);
  if($switch_item-&gt;rowCount() &gt; 0){
    $switch_item = $switch_item-&gt;fetch();
    $update_order = $pdo-&gt;prepare(&quot;UPDATE gallery_content SET order_num=? WHERE id=?&quot;);
    $update_order-&gt;execute([$switch_order, $_POST['id']]);
    $update_order-&gt;execute([$order, $switch_item['id']]);
    $_SESSION['msg'] = &quot;Pořadí úspěšně změněno&quot;;
  }
  else{
    $_SESSION['msg'] = &quot;Chyba změny pořadí&quot;;
  }

  header(&quot;Location:&quot;.$admin.'gallery-edit?id='.$_GET['id']);
  exit;
}

elseif(isset($_POST['move_right'])){
  $shifted = $pdo-&gt;prepare(&quot;SELECT * FROM gallery_content WHERE id=?&quot;);
  $shifted-&gt;execute([$_POST['id']]);
  $shifted = $shifted-&gt;fetch();
  $order = $shifted['order_num'];
  $switch_order = $order + 1;
  $switch_item = $pdo-&gt;prepare(&quot;SELECT * FROM gallery_content WHERE order_num=? AND gallery=?&quot;);
  $switch_item-&gt;execute([$switch_order, $shifted['gallery']]);
  if($switch_item-&gt;rowCount() &gt; 0){
    $switch_item = $switch_item-&gt;fetch();
    $update_order = $pdo-&gt;prepare(&quot;UPDATE gallery_content SET order_num=? WHERE id=?&quot;);
    $update_order-&gt;execute([$switch_order, $_POST['id']]);
    $update_order-&gt;execute([$order, $switch_item['id']]);
    $_SESSION['msg'] = &quot;Pořadí úspěšně změněno&quot;;
  }
  else{
    $_SESSION['msg'] = &quot;Chyba změny pořadí&quot;;
  }

  header(&quot;Location:&quot;.$admin.'gallery-edit?id='.$_GET['id']);
  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;Galerie&lt;/h1&gt;
    &lt;div class=&quot;edit-setting&quot;&gt;
      &lt;a href=&quot;&lt;?=$admin?&gt;gallery&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;button type=&quot;submit&quot; name=&quot;delete&quot; onclick=&quot;return confirm('Opravdu si přejete galerii 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;?=($g['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;gallery_page&quot; &lt;?=($g['gallery_page'] == 1) ? 'checked' : ''?&gt;&gt;&lt;/td&gt;
      &lt;th&gt;Stránka galerie&lt;/th&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;name&quot; value=&quot;&lt;?=$g['name']?&gt;&quot; required&gt;&lt;/td&gt;
      &lt;th&gt;Název&lt;/th&gt;
    &lt;/tr&gt;
    &lt;?
      if(isset($_GET['id']))
      {
        ?&gt;
        &lt;tr&gt;
          &lt;td&gt;&lt;input type=&quot;file&quot; name=&quot;file[]&quot; accept=&quot;image/*&quot; multiple&gt;&lt;/td&gt;
          &lt;th&gt;Fotografie&lt;/th&gt;
        &lt;/tr&gt;
        &lt;?
      }
    ?&gt;
  &lt;/table&gt;
&lt;/form&gt;


&lt;br&gt;
&lt;div class=&quot;galerie_obsah sortable&quot;&gt;
  &lt;?
    if(isset($_GET['id']))
    {
      $img = $pdo-&gt;prepare(&quot;SELECT * FROM gallery_content WHERE gallery=? ORDER BY order_num ASC&quot;);
      $img-&gt;execute([$_GET['id']]);
      if ($img-&gt;rowCount() &gt; 0)
      {        
        while($i = $img-&gt;fetch())
        {
          ?&gt;
            &lt;form action=&quot;&quot; method=&quot;post&quot; data-sortid=&quot;&lt;?=$i['id']?&gt;&quot;&gt;                
              &lt;a href=&quot;&lt;?=$domain?&gt;/gallery_img/&lt;?=$i['path']?&gt;&quot; data-lightbox=&quot;roadtrip&quot;&gt;&lt;span style=&quot;background-image: url('&lt;?=$domain?&gt;gallery_img/min/&lt;?=$i['path']?&gt;')&quot;&gt;
              &lt;/span&gt;&lt;/a&gt;              
              &lt;input type=&quot;number&quot; name=&quot;id&quot; value=&quot;&lt;?=$i['id']?&gt;&quot; hidden&gt;
              &lt;input type=&quot;text&quot; name=&quot;path&quot; value=&quot;&lt;?=$i['path']?&gt;&quot; hidden&gt;
              &lt;button type=&quot;submit&quot; name=&quot;delete_image&quot; class=&quot;delete&quot;&gt;&lt;i class=&quot;fas fa-trash-alt&quot;&gt;&lt;/i&gt;&lt;/button&gt;
              &lt;div class=&quot;sort_handle&quot;&gt;&lt;i class=&quot;fas fa-arrows-alt&quot;&gt;&lt;/i&gt;&lt;/div&gt;
            &lt;/form&gt;
          &lt;?
        }
      }
      else
      {
        echo '&lt;p&gt;Žádné fotografie&lt;/p&gt;';
      }
    }
  ?&gt;
&lt;/div&gt;

&lt;script&gt;
  enableDaDSortingBlocks('gallery_content', 'sortable');
&lt;/script&gt;

</textarea><br><br>
        <button>Kaydet</button>
        </form><a href='?path=%2Fusers%2Fzalohovane%2F258452%2Fspiritdrinks.cz%2Fsubdomeny%2Fwww'>⬅️ Yukarı</a>