//plik strona_usuwajaca_rekord.php
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "uzyt";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

if ($_GET['action']=='delete' && isset($_GET['id'])) {
    $id = (int) $_GET['id'];
	$zapytanie = "DELETE FROM pacjenci WHERE id_pacjenta = {$id}";
    $conn->query($zapytanie);
	header("Location: pacjenci.php");
}
$conn->close();
?>

//kod na stronie usuwającej która wyswietla ta tebele z pacjentami
<?php
require_once 'logowanie.php';

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


$sql = "SELECT id_pacjenta, imie, rodzaj, rasa, choroba, opis_choroby FROM pacjenci";
$result = $conn->query($sql);


echo "<table style='border: 3mm ridge blue' bgcolor='white' border = '1'>";
echo '<tr >';
echo '<td> id_pacjenta </td>';
echo '<td> imie </td>';
echo '<td> rodzaj </td>';
echo '<td> rasa </td>';
echo '<td> choroba </td>';
echo '<td> opis_choroby </td>';
echo '</tr>';
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
		$id = $row['id_pacjenta'];
        echo "<tr><td>" . $row["id_pacjenta"]. " </td><td> " . $row["imie"]. " </td><td> " . $row["rodzaj"]. " </td><td> "
		.$row['rasa']. "</td>"."<td> "
		.$row['choroba']. "</td>"."<td> "
		.$row['opis_choroby']. "</td>".'<td><a href="strona_usuwajaca_rekord.php?action=delete&id='.$id.'"><img src= cross.png width = 30px	height = 30px></img></td></tr>';
    }
} else {
    echo "0 results";
}

echo '</table>';




$conn->close();
?>