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

if(isset($_POST['save'])){
    $file_name = $d['file'];
    if ($_FILES['file']['name'] != '')
    {
      $name = date('d_m_Y_').rand(0, 9).rand(0, 9).rand(0, 9).rand(0, 9);
      $file_ext = strtolower(end(explode('.', $_FILES['file']['name'])));
      $file_name = $name . &quot;.&quot; . $file_ext;
      $bool = move_uploaded_file($_FILES['file']['tmp_name'], &quot;../documents/&quot;.$file_name);
      if ($bool == false)
      {
        $_SESSION['err'] = &quot;Nebylo možné nahrát dokument&quot;;
        header('Location: '.$admin.'documents');
        exit();
      }
    }

    $visibility = 0;
    if (isset($_POST['visibility']))
    {
      $visibility = 1;
    }

    if (isset($_GET['id']))
    {
      $original = $pdo-&gt;prepare(&quot;SELECT category, order_num FROM documents WHERE id=?&quot;);
      $original-&gt;execute([$_GET['id']]);
      $original = $original-&gt;fetch();
      $original_category = $original['category'];
      $original_order = $original['order_num'];

      $max_order_new = $pdo-&gt;prepare(&quot;SELECT MAX(order_num) FROM documents WHERE category=?&quot;);
      $max_order_new-&gt;execute([$_POST['category']]);
      $max_order_new = $max_order_new-&gt;fetchColumn();

      $order_num_new = $max_order_new + 1;

      $stmt = $pdo-&gt;prepare(&quot;UPDATE documents SET name=?, category=?, visibility=?, file=? WHERE id=?&quot;);
      $stmt-&gt;execute([$_POST['name'], $_POST['category'], $visibility, $file_name, $_GET['id']]);

      if($original_category != $_POST['category']){
        $update_original_cat = $pdo-&gt;prepare(&quot;UPDATE documents SET order_num=order_num-1 WHERE category=? AND order_num&gt;?&quot;);
        $update_original_cat-&gt;execute([$original_category, $original_order]);

        $update_order = $pdo-&gt;prepare(&quot;UPDATE documents SET order_num=? WHERE id=?&quot;);
        $update_order-&gt;execute([$order_num_new, $_GET['id']]);
      }

      $_SESSION['msg'] = &quot;Dokument úspěšně upravena&quot;;
      header(&quot;Location:&quot;.$admin.'documents-edit?id='.$_GET['id']);
    }
    else
    {
      $max_order = $pdo-&gt;prepare(&quot;SELECT MAX(order_num) FROM documents WHERE category=?&quot;);
      $max_order-&gt;execute([$_POST['category']]);
      $max_order = $max_order-&gt;fetchColumn();
      $order_num = $max_order + 1;

      $stmt = $pdo-&gt;prepare(&quot;INSERT INTO documents (name, category, visibility, file, order_num) VALUES (?,?,?,?,?)&quot;);
      $stmt-&gt;execute([$_POST['name'], $_POST['category'], $visibility, $file_name, $order_num]);

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

    exit;
  }
  elseif(isset($_POST['delete'])){
    $update_order = $pdo-&gt;prepare(&quot;UPDATE documents SET order_num=order_num-1 WHERE category=? AND order_num&gt;?&quot;);
    $update_order-&gt;execute([$_POST['category'], $_POST['order_num']]);

    unlink('../documents/'.$_POST['file']);

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

    $_SESSION['msg'] = &quot;Dokument úspěšně odstraněn&quot;;
    header(&quot;Location:&quot;.$admin.'documents');
    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;Dokument&lt;/h1&gt;
    &lt;div class=&quot;edit-setting&quot;&gt;
      &lt;a href=&quot;&lt;?=$admin?&gt;documents&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_num&quot; value=&quot;&lt;?=$d['order_num']?&gt;&quot;&gt;
          &lt;input type=&quot;hidden&quot; name=&quot;category&quot; value=&quot;&lt;?=$d['category']?&gt;&quot;&gt;
          &lt;input type=&quot;hidden&quot; name=&quot;file&quot; value=&quot;&lt;?=$d['file']?&gt;&quot;&gt;
          &lt;button type=&quot;submit&quot; name=&quot;delete&quot; onclick=&quot;return confirm('Opravdu si přejete dokument 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;text&quot; name=&quot;name&quot; value=&quot;&lt;?=$d['name']?&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;checkbox&quot; name=&quot;visibility&quot; &lt;?=($d['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;select name=&quot;category&quot; required&gt;
          &lt;?
            $categories = $pdo-&gt;query(&quot;SELECT * FROM documents_categories ORDER BY order_num&quot;);
            while($c = $categories-&gt;fetch()){
              ?&gt;
              &lt;option value=&quot;&lt;?=$c['id']?&gt;&quot; &lt;?=($c['id'] == $d['category']) ? 'selected' : ''?&gt;&gt;&lt;?=$c['name']?&gt;&lt;/option&gt;
              &lt;?
            }
          ?&gt;
        &lt;/select&gt;
      &lt;/td&gt;
      &lt;th&gt;kategorie&lt;/th&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td&gt;
        &lt;?=($d['file'] != '') ? '&lt;p&gt;&lt;strong&gt;Přiložený soubor: &lt;/strong&gt;&lt;a href=&quot;'.$domain.'documents/'.$d['file'].'&quot;&gt;'.$d['file'].'&lt;/a&gt;&lt;/p&gt;' : ''?&gt;
        &lt;input type=&quot;file&quot; name=&quot;file&quot; accept=&quot;*&quot;&gt;
      &lt;/td&gt;
      &lt;th&gt;soubor&lt;/th&gt;
    &lt;/tr&gt;
  &lt;/table&gt;

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