<?php
echo "Flugmanager Control<br>\n";
echo "<style>html,body {color:white;}</style>";
$db=mysqli_connect("localhost","user","passwd_which_you_really_dont_know");
mysqli_set_charset($db,"utf8");
mysqli_select_db($db,"flugmanager");
$sql = "SELECT * FROM flugmanager.fluege WHERE 1";
$result = mysqli_query($db,$sql);
while ($row = mysqli_fetch_assoc($result)){
	echo "Flug $row[id]: Von $row[von] nach $row[nach] um $row[mni]:$row[std]<br/>Status: $row[status]<br/>\n";
}
mysqli_close($db);
?>
<form action="update.php" method="post">
Der Status vom Flug mit der id <input type="text" name="id"/> wird auf <input type="text" name="sql" maxlength="15" size="15"/> geändert.<br/>
<input type="submit" id="submit" name="submit"/>
</form>
<?php
if(!empty($_POST['submit'])){
	$id=$_POST['id'];
	$sql=$_POST['sql'];
	$db=mysqli_connect("localhost","user","passwd_which_you_really_dont_know");
	mysqli_set_charset($db,"utf8");
	mysqli_select_db($db,"flugmanager");
	$sql = "UPDATE fluege SET status='$sql' WHERE id='$id';";
	echo $sql;
	$result = mysqli_query($db,$sql);
	mysqli_close($db);
}
?>