<?
mysql_connect("db4free.net","username","passw") or die("dbcon");
mysql_select_db("datenbank") or die("db");

if (isset($_POST['new']) and $_POST['new'] != "")
{
$title = $_POST['title'];
$image = $_POST['image'];
$link = $_POST['videolink'];
mysql_query("INSERT INTO
				stream_link
					(
						ID,
						title,
						image
					)
				VALUES
					(
						NULL,
						'$title',
						'$image'
					)
			");
mysql_query("INSERT INTO
				stream_system
					(
						ID,
						link
					)
				VALUES
					(
						NULL,
						'$link'
					)
			");
echo "ERFOLGREICH ANGELEGT! <a href=\"".$_SERVER['PHP_SELF']."\">!weiter!</a>";
}
elseif (isset ($_POST['drop']) and $_POST['drop'] != "")
{
$dropid = $_POST['delete'];
	mysql_query("DELETE FROM stream_system WHERE ID = '$dropid'");
	mysql_query("DELETE FROM stream_link WHERE ID = '$dropid'");
	echo "ERFOLGREICH GEL&Ouml;! <a href=\"".$_SERVER['PHP_SELF']."\">!weiter!</a>";
}
else
{
?>
<h1>neuer Link</h1>
		<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST">
			Link: (der Link der in "video src" stehen soll)<br>
			<input type="text" name="videolink"><br>
			Titel (wie der link heissen soll)<br>
			<input type="text" name="title"><br>
			Bild (pfad komplett bsp.: http://beispieldomain.de/ordner/bild.png)<br>
			<input type="text" name="image"><br>
			<input type="submit" name="new" value="new">
		</form><br>
		
		<h1>Stream l&ouml;schen</h1>
		<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="POST">
			title:<br>
				<select name="delete" size="5">
				<optgroup label="Bitte den zu entfernenden stream anklicken.">
					<?
						$sql = mysql_query("SELECT * FROM stream_link");
						While ($row = mysql_fetch_assoc($sql))
						{
							echo "<option value=\"".$row['ID']."\">".$row['title']."</option>";
						}
					?>
					</optgroup>
				</select><br>
				<input type="submit" name="drop" value="drop">
		</form>
<?}?>