Untitled

<html>
<head>
	<link rel="stylesheet" type="text/css" href="db_linkcss.css">

<script type="text/javascript">
function send(ak, id)
{
	if(ak==0)
		document.f.ak.value = "in";
	else if(ak==1)
		document.f.ak.value = "up";
	else if(ak==2)
	{
		if (confirm("Datensatz mit id " + id + " löschen?"))
			document.f.ak.value = "de";
		else
			return;
	}
	document.f.id.value = id;
	document.f.submit();
}
</script>
</head>

<body>
<?php
	// MySQL Zugangsdaten
	$database="usr_web279_1";
	$host="localhost";
	$user="web279";
	$password="ZQ3OXcOU";
	$table="personen02";

	// Verbindung zur Datenbank herstellen
	mysql_connect($host,$user,$password);
	mysql_select_db($database) or die( "Unable to select database");

	/* Aktion ausführen */
	if(isset($_POST["ak"]))
	{
		/* neu eintragen */
		if($_POST["ak"]=="in")
		{
			$sqlab = "insert personen02"
			. "(name, vorname, personalnummer,"
			. " gehalt, geburtstag) values ('"
			. $_POST["na"][0] . "', '"
			. $_POST["vo"][0] . "', '"
			. $_POST["pn"][0] . "', '"
			. $_POST["gh"][0] . "', '"
			. $_POST["gb"][0] . "')";
			mysql_query($sqlab);
		}

		/* ändern */
		else if($_POST["ak"]=="up")
		{
			$id = $_POST["id"];
			$sqlab = "update personen02 set "
			. "name = '" . $_POST["na"][$id] . "', "
			. "vorname = '" . $_POST["vo"][$id] . "', "
			. "personalnummer = '" . $_POST["pn"][$id] . "', "
			. "gehalt = '" . $_POST["gh"][$id] . "'. "
			. "geburtstag = '" . $_POST["gb"][$id] . "'"
			. " where personalnummer = $id";
			mysql_query($sqlab);
		}

		/* löschen */
		else if($_POST["ak"]=="de")
		{
			$sqlab = "delete from personen02 where personalnummer = " . $_POST["id"];
			mysql_query($sqlab);
		}
	}

	/* Formular-Beginn */
	echo "<form name='f' action='db_linkcss.php' method='post'>";
	echo "<input name='ak' type='hidden' />";
	echo "<input name='id' type='hidden' />";

	/* Tabellen-beginn */
	echo "\n\n<table border>"
		. "<tr>"
		. "<td>Name</td>"
		. "<td>Vorname</td>"
		. "<td>Pnr</td>"
		. "<td>Gehalt</td>"
		. "<td>Geb.</td>"
		. "<td>Aktion</td>"
		. "</tr>";

	/* Neuer Eintrag */
	echo "\n\n<tr>"
		. "<td><input name='na[0]' size='8' /></td>"
		. "<td><input name='vo[0]' size='6' /></td>"
		. "<td><input name='pn[0]' size='6' /></td>"
		. "<td><input name='gh[0]' size='6' /></td>"
		. "<td><input name='gb[0]' size='8' /></td>"
		. "<td><a href='javascript:send(0,0);'>
			neu eintragen</a></td>"
		. "</tr>";

	/* Anzeigen */
	$res = mysql_query("select * from personen02");

	/* Alle vorhandenen Datensätze */
	while ($dsatz = mysql_fetch_assoc($res))
	{
		$id = $dsatz["personalnummer"];
		echo "\n\n<tr>"
			. "<td><input name='na[$id]' value='"
			. $dsatz["name"] . "' size='8' /></td>"
			. "<td><input name='vo[$id]' value='"
			. $dsatz["vorname"] . "' size='6' /></td>"
			. "<td><input name='pn[$id]' value='"
			. $dsatz["personalnummer"] . "' size='6' /></td>"
			. "<td><input name='gh[$id]' value='"
			. $dsatz["gehalt"] . "' size='6' /></td>"
			. "<td><input name='gb[$id]' value='"
			. $dsatz["geburtstag"] . "' size='8' /></td>"
			. "<td><a href='javascript:send(1,$id);'>ändern</a>"
			. " <a href='javascript:send(2,$id);'>"
			. " löschen</a></td>"
			. "</tr>";
		}
	echo "</table>";
	echo "</form>";
?>
</body>
</html>