<?php
// Forbind til vores database
include('db.php');


if (isset($_POST['navn'])) {
	// Slet den gamle note
	$navn = trim($_POST['navn']);
	$db->query("DELETE FROM radar WHERE navn LIKE '$navn'");
	echo $db->error;

	// Opret nyt, hvis der er indtastet en lokation
	if (strlen($_POST['lokation']) > 2) {
		$navn = trim($_POST['navn']);
		$lokation = trim($_POST['lokation']);
		$tid = trim($_POST['tid']);
		$noter = trim($_POST['noter']);

		$db->query("INSERT INTO radar (navn, lokation, tid, noter) VALUES('$navn','$lokation','$tid','$noter')");
		echo $db->error;
		//header('Location: radar.php');
		//exit();
	}


}



// Start vores side.
$aktiv_menu = 'radar';
include('templates/side_start.php');

$resultat = $db->query("SELECT * FROM radar");
echo "<table><tr><td class='tabel-label'>Navn<td class='tabel-label'>Sted<td class='tabel-label'>Længde<td class='tabel-label'>Noter</tr>";
while ($radar = $resultat->fetch_array() ) {
	echo "<tr>";
	echo "<td class='tabel-felt'>" . $radar['navn'] . "</td>";
	echo "<td class='tabel-felt'>" . $radar['lokation'] . "</td>";
	echo "<td class='tabel-felt'>" . $radar['tid'] . "</td>";
	echo "<td class='tabel-felt'>" . $radar['noter'] . "</td>";
	echo "</tr>";
}

echo "</table>";
?>
<br />
<br />
<form action='radar.php' method='post'>
<table>

	<tr>
		<td class='tabel-label'>Navn:</td><td class='tabel-felt'><input type='text' name='navn' size='30'></td>
	</tr>
	<tr>
		<td class='tabel-label'>Lokation:</td><td class='tabel-felt'><input type='text' name='lokation' size='30'></td>
	</tr>
	<tr>
		<td class='tabel-label'>Varighed:</td><td class='tabel-felt'><input type='text' name='tid' size='30'></td>
	</tr>
	<tr>
		<td class='tabel-label'>Noter:</td><td class='tabel-felt'><textarea name='noter' rows='5' cols="40"></textarea></td>
	</tr>
	<tr>
		<td>&nbsp;</td><td class='tabel-felt'><input type='submit' value='gem'></td>
	</tr>
</table>
</form>

<?php
// Slut på vores side.
include('templates/side_slut.php');
?>