1

Temat: `firma1` kasowanie rekordu

https://ti.dxe.pl/files2/baza2.jpg


Baza danych: `firma1`

Baza do pobrania:
https://ti.dxe.pl/files2/baza.sql

Proszę zrobić usuwanie wybranego rekordu.

<?php
  if (isset($_POST["q"])) $q=(int)$_POST["q"]; else $q="rok";
  if (empty($q)) $q="rok";
?>
<form action="" method="post">
  Rok: <input type="text" name="q" value="<?php echo $q; ?>">
  <input type="submit" value="Szukaj">
</form>
<hr>
<?php
  echo "<table border=1>";
  echo "<tr>";
  echo "<td bgcolor=yellow>`id`</td>";
  echo "<td bgcolor=yellow>`imie`</td>";
  echo "<td bgcolor=yellow>`nazwisko`</td>";
  echo "<td bgcolor=yellow>`stanowisko`</td>";
  echo "<td bgcolor=yellow>`rok`</td>";
  echo "</tr>";
  if ($_POST)
  {
    echo "<form>";
    $co=mysqli_connect("localhost", "root", "", "firma1");
    $qu=mysqli_query($co, "SELECT * FROM baza WHERE rok=".$q.";");
    $i=0;
    while ($re=mysqli_fetch_array($qu))
    {
      if ($i%2==0) $b="#e3e7e6"; else $b="#ffffff";
      $r='<input type="radio" name="del" value="'.($re["id"]).'">'."\n";
      echo "<tr>";
      echo "<td bgcolor=".$b.">".$r.($re["id"])."</td>";
      echo "<td bgcolor=".$b.">".($re["imie"])."</td>";
      echo "<td bgcolor=".$b.">".($re["nazwisko"])."</td>";
      echo "<td bgcolor=".$b.">".($re["stanowisko"])."</td>";
      echo "<td bgcolor=".$b.">".($re["rok"])."</td>";
      echo "</tr>";
      $i++;
    }
    echo '<p><input type="button" value="Usuń"></p>'."\n";
    echo "</form>";
    mysqli_close($co);
  }
  else echo "<tr><td>-</td><td>-</td><td>-</td><td>-</td><td>-</td></tr>";
  echo "</table>";
?>