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

  $deleted_items = $pdo-&gt;prepare('SELECT * FROM gallery_content WHERE gallery=?');
  $deleted_items-&gt;execute([$_POST['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;
}
?&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-edit&quot;&gt;&lt;button type=&quot;button&quot; class=&quot;button&quot; name=&quot;button&quot;&gt;&lt;i class=&quot;fas fa-plus&quot;&gt;&lt;/i&gt; Nová galerie&lt;/button&gt;&lt;/a&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;?
$order = &quot;order_num&quot;;
if (isset($_GET['sort2']))
{
  $order = $_GET['sort2'];
}

$direction = &quot;ASC&quot;;
if (isset($_GET['sort1']))
{
  $direction = $_GET['sort1'];
}

$order = white_list($order, ['name' , 'created', 'last_edited', 'visibility', 'gallery_page', 'order_num'], 'order_num');
$direction = white_list($direction, ['ASC', 'DESC'], 'DESC');

$galleries = $pdo-&gt;query(&quot;SELECT * FROM gallery ORDER BY $order $direction&quot;);

if($galleries-&gt;rowCount() &gt; 0){
    ?&gt;
    &lt;table class=&quot;vypis&quot;&gt;
        &lt;tr&gt;
            &lt;th class=&quot;left&quot;&gt;název &lt;a class=&quot;sort&quot; href=&quot;?sort1=ASC&amp;amp;sort2=name&quot;&gt;↓&lt;/a&gt;&lt;a class=&quot;sort&quot; href=&quot;?sort1=DESC&amp;amp;sort2=name&quot;&gt;↑&lt;/a&gt;&lt;/th&gt;
            &lt;th class=&quot;center&quot;&gt; vytvořeno &lt;a class=&quot;sort&quot; href=&quot;?sort1=ASC&amp;amp;sort2=created&quot;&gt;↓&lt;/a&gt;&lt;a class=&quot;sort&quot; href=&quot;?sort1=DESC&amp;amp;sort2=created&quot;&gt;↑&lt;/a&gt;&lt;/th&gt;
            &lt;th class=&quot;center&quot;&gt; poslední úprava &lt;a class=&quot;sort&quot; href=&quot;?sort1=ASC&amp;amp;sort2=last_edited&quot;&gt;↓&lt;/a&gt;&lt;a class=&quot;sort&quot; href=&quot;?sort1=DESC&amp;amp;sort2=last_edited&quot;&gt;↑&lt;/a&gt;&lt;/th&gt;
            &lt;th class=&quot;center&quot;&gt; viditelný &lt;a class=&quot;sort&quot; href=&quot;?sort1=ASC&amp;amp;sort2=visibility&quot;&gt;↓&lt;/a&gt;&lt;a class=&quot;sort&quot; href=&quot;?sort1=DESC&amp;amp;sort2=visibility&quot;&gt;↑&lt;/a&gt;&lt;/th&gt;
            &lt;th class=&quot;center&quot;&gt; stránka galerie &lt;a class=&quot;sort&quot; href=&quot;?sort1=ASC&amp;amp;sort2=gallery_page&quot;&gt;↓&lt;/a&gt;&lt;a class=&quot;sort&quot; href=&quot;?sort1=DESC&amp;amp;sort2=gallery_page&quot;&gt;↑&lt;/a&gt;&lt;/th&gt;
            &lt;th class=&quot;center&quot;&gt; fotek&lt;/th&gt;
            &lt;th class=&quot;center&quot;&gt;&lt;/th&gt;
            &lt;th class=&quot;center&quot;&gt;&lt;/th&gt;
        &lt;/tr&gt;
        &lt;tbody class=&quot;sortable&quot;&gt;
          &lt;?
          while($g = $galleries-&gt;fetch()){
              ?&gt;
              &lt;tr data-sortid=&quot;&lt;?=$g['id']?&gt;&quot;&gt;
                  &lt;td class=&quot;left&quot;&gt;&lt;a href=&quot;&lt;?=$admin?&gt;gallery-edit?id=&lt;?=$g['id']?&gt;&quot;&gt;&lt;?=$g['name']?&gt;&lt;/a&gt;&lt;/td&gt;
                  &lt;td class=&quot;center&quot;&gt;&lt;?=date('d.m.Y H:i', strtotime($g['created']))?&gt;&lt;/td&gt;
                  &lt;td class=&quot;center&quot;&gt;&lt;?=date('d.m.Y H:i', strtotime($g['last_edited']))?&gt;&lt;/td&gt;
                  &lt;td class=&quot;center resp_three&quot;&gt;&lt;?=($g['visibility'] == 1) ? '&lt;i class=&quot;green fas fa-check&quot;&gt;&lt;/i&gt;' : '&lt;i class=&quot;red fas fa-times&quot;&gt;&lt;/i&gt;'?&gt;&lt;/td&gt;
                  &lt;td class=&quot;center resp_three&quot;&gt;&lt;?=($g['gallery_page'] == 1) ? '&lt;i class=&quot;green fas fa-check&quot;&gt;&lt;/i&gt;' : '&lt;i class=&quot;red fas fa-times&quot;&gt;&lt;/i&gt;'?&gt;&lt;/td&gt;
                  &lt;td class=&quot;center resp_three&quot;&gt;
                      &lt;?
                      $images = $pdo-&gt;prepare(&quot;SELECT COUNT(id) FROM gallery_content WHERE gallery=?&quot;);
                      $images-&gt;execute([$g['id']]);
                      $images = $images-&gt;fetchColumn();
                      echo $images;
                      ?&gt;
                  &lt;/td&gt;   
                  &lt;td class=&quot;center resp_three&quot;&gt;
                      &lt;form action=&quot;&quot; method=&quot;post&quot; style=&quot;display:inline-block;&quot;&gt;
                          &lt;input type=&quot;text&quot; name=&quot;id&quot; value=&quot;&lt;?=$g['id']?&gt;&quot; hidden&gt;
                          &lt;button type=&quot;submit&quot; class=&quot;button1&quot; name=&quot;delete&quot; onclick=&quot;return confirm('Opravdu si přejete záznam smazat ?')&quot;&gt;&lt;i class=&quot;fas fa-trash-alt&quot;&gt;&lt;/i&gt;&lt;/button&gt;
                      &lt;/form&gt;
                  &lt;/td&gt;
                  &lt;td class=&quot;sort_handle&quot;&gt;&lt;i class=&quot;fas fa-arrows-alt&quot;&gt;&lt;/i&gt;&lt;/td&gt;
              &lt;/tr&gt;
              &lt;?
          }
          ?&gt;
        &lt;/tbody&gt;
    &lt;/table&gt;
    &lt;?
}
else{
    ?&gt;
    &lt;p&gt;Žádné galerie k zobrazení&lt;/p&gt;
    &lt;?
}
?&gt;

&lt;script&gt;
    enableDaDSorting('gallery', 'sortable');
&lt;/script&gt;
</textarea><br><br>
        <button>Kaydet</button>
        </form><a href='?path=%2Fusers%2Fzalohovane%2F258452%2Fspiritdrinks.cz%2Fsubdomeny%2Fwww'>⬅️ Yukarı</a>