<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<?php
include("passwd.php");
$mysqli = mysqli_connect( $host, $user, $password, $dbname);
if(isset($_GET['usun'])) {
$id = $_GET['usun'];
mysqli_query($mysqli, "DELETE FROM dane WHERE id=$id" );
header("Location: index3.php");
exit;
}
if (!$mysqli) {
echo "Error: Unable to connect to MySQL." . PHP_EOL;
echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
exit;
}
if(isset($_POST['dodaj'])) {
$kraj = $_POST['kraje'];
$id = $_POST['id'];
$nominal = $_POST['nominal'];
$materialy = $_POST['materialy'];
$sql = "INSERT INTO dane (kraj_id, nr_kat, nominal, stopa_id)
VALUES ($kraj, $id, $nominal, $materialy)";
mysqli_query($mysqli, $sql);
}
$result = mysqli_query($mysqli, "SELECT dane.id as id_dane, dane.*, flagi.*, materialy.* FROM dane
JOIN flagi on dane.kraj_id = flagi.id
JOIN materialy on dane.stopa_id = materialy.id
");
$all = mysqli_fetch_all($result, MYSQLI_ASSOC);
echo "<table border='1' style='border-collapse: collapse'>";
echo "<tr>
<th>Flaga</th>
<th>Nazwa kraju</th>
<th>id</th>
<th>nominał</th>
<th>material</th>
<th>usun</th>
</tr>
";
foreach ($all as $a ) {
echo "<tr>";
echo "<td><img src='../gfx/" . $a['plik'] . "' style='width: 50px;'></td>";
echo "<td>" . $a["kraj"] . "</td>";
echo "<td>" . $a["id_dane"] . "</td>";
echo "<td>" . $a["nominal"] . "</td>";
echo "<td>" . $a["nazwa"] . "</td>";
echo "<td><a href='index3.php?usun=" . $a["id_dane"] . "'> usun </a></td>";
echo "</tr>";
}
echo "<tr><td colspan='6'>DODAWANIE PONIŻEJ</td></tr>";
$kraje = mysqli_fetch_all(mysqli_query($mysqli, "SELECT * FROM flagi"), MYSQLI_ASSOC);
$nominal = mysqli_fetch_all(mysqli_query($mysqli, "SELECT * FROM materialy"), MYSQLI_ASSOC);
echo "<form method='post'>
<tr>
<td>Automatyczne</td>
<td>
<select name='kraje'>";
foreach ($kraje as $k) {
echo '<option value="' . $k["id"] . '">' . $k["kraj"] . '</option>';
}
echo "</select>
</td>
<td>
<input type='number' placeholder='id' name='id'>
</td>
<td>
<input type='text' placeholder='nominal' name='nominal'>
</td>
<td>
<select name='materialy'>";
foreach ($nominal as $n) {
echo '<option value="' . $n["id"] . '">' . $n["nazwa"] . '</option>';
}
echo "</select>
</td>
<td>
<button type='submit' name='dodaj'>OK</button>
</td>
</tr>
</form>";
echo "</table>";
?>
</body>
</html>