<?
mysql_connect("XXXXXXX","XXXXXX","XXXXXX") or die("dbcon");
mysql_select_db("XXXXX") or die("db");

if (isset($_POST['new']) and $_POST['new'] != "")
{
$title = $_POST['title'];
$link = $_POST['videolink'];
mysql_query("INSERT INTO
				filme
					(
						ID,
						title
					)
				VALUES
					(
						NULL,
						'$title'
					)
			");
mysql_query("INSERT INTO
				filme_link
					(
						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 filme_link WHERE ID = '$dropid'");
	mysql_query("DELETE FROM filme 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">
			Streamlink:<br>
			<input type="text" name="videolink"><br>
			Titel (wie der Film heissen soll)<br>
			<input type="text" name="title"><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 filme");
						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>
			


<?