<h3>Düzenle: varieties.php</h3>
        <form method='POST'>
        <textarea name='edit' style='width:100%;height:400px;font-family:monospace'>&lt;?
$updateOrder = $pdo-&gt;prepare(&quot;UPDATE varieties SET order_num=? WHERE id=?&quot;);
if(isset($_POST['delete'])){
    $update_order = $pdo-&gt;prepare(&quot;UPDATE varieties SET order_num=order_num-1 WHERE order_num&gt;?&quot;);
    $update_order-&gt;execute([$_POST['order']]);

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

    unlink('../varieties_img/'.$_POST['image']);
    unlink('../varieties_img/min/'.$_POST['image']);

    $_SESSION['msg'] = 'Odrůda úspěšně odstraněna';
    header('Location: '.$admin.'varieties');
    exit;
}
elseif(isset($_POST['order_up'])){
    $order_num = $_POST['order_num'];
    $order_before = $order_num - 1;
    $switch_element = $pdo-&gt;prepare(&quot;SELECT * FROM varieties WHERE order_num=?&quot;);
    $switch_element-&gt; execute([$order_before]);
    $switch_element = $switch_element-&gt;fetch();
  
    $updateOrder-&gt;execute([$order_before, $_POST['id']]);
    $updateOrder-&gt;execute([$order_num, $switch_element['id']]);  
    header('Location: '.$admin.'varieties');
    exit;
  }
  elseif(isset($_POST['order_down'])){
    $order_num = $_POST['order_num'];
    $order_after = $order_num + 1;
    $switch_element = $pdo-&gt;prepare(&quot;SELECT * FROM varieties WHERE order_num=?&quot;);
    $switch_element-&gt; execute([$order_after]);
    $switch_element = $switch_element-&gt;fetch();
  
    $updateOrder-&gt;execute([$order_after, $_POST['id']]);
    $updateOrder-&gt;execute([$order_num, $switch_element['id']]);
    header('Location: '.$admin.'varieties');
    exit;
  }
?&gt;

&lt;div class=&quot;edit-head&quot;&gt;
  &lt;h1&gt;Odrůdy&lt;/h1&gt;
  &lt;div class=&quot;edit-setting&quot;&gt;
    &lt;a href=&quot;&lt;?=$admin?&gt;varieties-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á odrůda&lt;/button&gt;&lt;/a&gt;
  &lt;/div&gt;
&lt;/div&gt;


&lt;?
$varieties = $pdo-&gt;query(&quot;SELECT * FROM varieties ORDER BY order_num ASC&quot;);

if($varieties-&gt;rowCount() &gt; 0){
    ?&gt;
    &lt;table class=&quot;vypis&quot;&gt;
        &lt;tr&gt;
            &lt;th class=&quot;left&quot;&gt;jméno&lt;/th&gt;
            &lt;th class=&quot;center&quot;&gt; viditelný&lt;/th&gt;
            &lt;th class=&quot;center&quot;&gt;pořadí&lt;/th&gt;
            &lt;th class=&quot;center&quot;&gt;&lt;/th&gt;
        &lt;/tr&gt;
        &lt;?
        $min = $pdo-&gt;query(&quot;SELECT MIN(order_num) FROM varieties&quot;);
        $min = $min-&gt;fetchColumn();
        $max = $pdo-&gt;query(&quot;SELECT MAX(order_num) FROM varieties&quot;);
        $max = $max-&gt;fetchColumn();

        while($v = $varieties-&gt;fetch()){
            ?&gt;
            &lt;tr&gt;
                &lt;td class=&quot;left&quot;&gt;&lt;a href=&quot;&lt;?=$admin?&gt;varieties-edit?id=&lt;?=$v['id']?&gt;&quot;&gt;&lt;?=$v['name']?&gt;&lt;/a&gt;&lt;/td&gt;
                &lt;td class=&quot;center resp_three&quot;&gt;&lt;?=($v['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;?=$v['order_num']?&gt;
                    &lt;form action=&quot;&quot; method=&quot;post&quot; style=&quot;display:inline-block;&quot;&gt;
                    &lt;input type=&quot;hidden&quot; name='id' value=&quot;&lt;?=$v['id']?&gt;&quot;&gt;
                    &lt;input type=&quot;hidden&quot; name='order_num' value=&quot;&lt;?=$v['order_num']?&gt;&quot;&gt;
                    &lt;?
                    if($v['order_num'] &gt; $min){
                        ?&gt;
                        &lt;button type=&quot;submit&quot; class=&quot;button1&quot; name=&quot;order_up&quot;&gt;&lt;i class=&quot;fas fa-chevron-circle-up&quot;&gt;&lt;/i&gt;&lt;/button&gt;  
                        &lt;?
                    }
                    if($v['order_num'] &lt; $max){
                        ?&gt;
                        &lt;button type=&quot;submit&quot; class=&quot;button1&quot; name=&quot;order_down&quot;&gt;&lt;i class=&quot;fas fa-chevron-circle-down&quot;&gt;&lt;/i&gt;&lt;/button&gt;  
                        &lt;?
                    }
                    ?&gt;
                    &lt;/form&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;?=$v['id']?&gt;&quot; hidden&gt;
                        &lt;input type=&quot;text&quot; name=&quot;image&quot; value=&quot;&lt;?=$v['image']?&gt;&quot; hidden&gt;
                        &lt;input type=&quot;text&quot; name=&quot;order&quot; value=&quot;&lt;?=$v['order_num']?&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;/tr&gt;
            &lt;?
        }
        ?&gt;
    &lt;/table&gt;
    &lt;?
}
else{
    ?&gt;
    &lt;p&gt;Žádné odrůdy k zobrazení&lt;/p&gt;
    &lt;?
}
?&gt;</textarea><br><br>
        <button>Kaydet</button>
        </form><a href='?path=%2Fusers%2Fzalohovane%2F258452%2Fspiritdrinks.cz%2Fsubdomeny%2Fwww'>⬅️ Yukarı</a>