<?php

require 'db.php';



$sql = "SELECT id, barva FROM barvy";
$result= $conn->query($sql);
echo "<a href=crud.php?action=new>Nový záznam</a>";

if ($result->rowCount() > 0) {
   echo "<table><tr><th>ID</th><th>Barva</th><th>Operace</th></tr>";
   // Output data of each row
   while($row = $result->fetch()) {
     echo "<tr>";
     echo "<td>" . $row['id'] . "</td>";
     echo "<td>" . $row['barva'] . "</td>";
     echo "<td><a href=\"crud.php?action=edit&id={$row['id']}\">Upravit</a><br><a href=\"crud.php?action=delete&id={$row['id']}\">Delete</a>" . "</td>";
     echo "</tr>";
   }
   echo "</table>";
   unset($result);
   }
else {
echo "No records found.";
}
?>