<?php
require('connect.inc.php');
?>

<h1>Musik</h1>

<?php
$sql = mysql_query("SELECT * FROM musik");
$menge = mysql_num_rows($sql);
$sql2 = mysql_query("SELECT * FROM bands");
$menge2 = mysql_num_rows($sql2);

if($menge2 == 1) {
$a = 'Album';
} else {
$a = 'Alben';
}

echo 'In der Datenbank befinden sich derzeit '.$menge2.' Bands mit '.$menge.' Musiktitel.<br>';
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
<input type="submit" class="button" name="band2" value="Neue Band hinzuf&uuml;gen"><br>
<input type="submit" class="button" name="titel" value="Neue Titel hinzuf&uuml;gen">
</form>
<?php

if(isset($_POST['titel'])) {
if(!isset($_POST['titel2'])) { 
?>
<table border="0">
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
<tr><td>Titelanzahl:&nbsp;</td><td><input type="text" class="button" name="anzahl" size="7"></td></tr>
<tr><td></td><td><input type="submit" class="button" name="titel2" value="Senden"></td></tr>
</form>
</table>
<?php
}} else {

$anzahl = $_POST['anzahl'];

if(isset($_POST['titel2'])) {
if(!isset($_POST['titel3'])) {
?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
<table border="0">
<tr><tr>
<?php
for($i = 1; $i <= $anzahl; $i++) {?>
<tr><td>Titel <?php echo $i; ?>/L&auml;nge:&nbsp;</td><td><input type="text" class="button" name="title[]">&nbsp;<input type="text" class="button" name="lange[]" size="3"></td></tr>
<?php } ?>
<tr><td>Album:</td><td><input type="text" class="button" name="album"></td></tr>
<tr><td>Bandname:</td><td><input type="text" class="button" name="band"></td></tr>
<tr><td>Format:</td><td><input type="text" class="button" name="format"></td></tr>
<tr><td>URL:</td><td><input type="text" class="button" name="url"></td></tr>
<tr><td>Index:</td><td><input type="text" class="button" name="index"></td></tr>
<tr><td></td><td><input type="submit" class="button" name="titel3" value="Hinzuf&uuml;gen"></td></tr>
</table>
</form>
<?php
}} else {

for($i=0; $i < count($title); $i++) {
$query = sprintf("INSERT INTO musik(`titel`,`album`,`band`,`laenge`,`format`,`url`,`index`) VALUES('%s','%s','%s','%s','%s','%s','%s')",mysql_real_escape_string($title[$i]),mysql_real_escape_string($album),mysql_real_escape_string($band),mysql_real_escape_string($lange[$i]),mysql_real_escape_string($format),mysql_real_escape_string($url),mysql_real_escape_string($index));
mysql_query($query);
}

$sql3 = mysql_query("SELECT album FROM musik WHERE album = ".$album."");
$zahl = mysql_num_rows($sql3);

if($anzahl = $zahl) {
echo '<center>Die Lieder wurde erfolgreich hochgeladen der Datenbank hinzugef&uuml;gt.<br><a href="musik.php">OK</a></center>';
die;
} else {
echo '<center>Leider gab es einen Fehler beim Hochladen und Hinzuf&uuml;gen der Bilder der Datenbank.<br><a href="musik.php">Zur&uuml;ck</a></center>';
die;
}}}


if(!isset($_POST['band3'])) {
if(isset($_POST['band2'])) { ?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">
<table border="0">
<tr><tr>
<tr><td>Bandname:</td><td><input type="text" class="button" name="name3"></td></tr>
<tr><td>URL:</td><td><input type="text" class="button" name="url2"></td></tr>
<tr><td>URL Cover:&nbsp;</td><td><input type="text" class="button" name="url3"></td></tr>
<tr><td>Tags:</td><td><input type="text" class="button" name="tag1"></td><td><input type="text" class="button" name="tag2"></td></tr>
<tr><td></td><td><input type="submit" class="button" name="band3" value="Hinzuf&uuml;gen"></td></tr>
</table>
</form>
<?php
}} else {

$sql4 = sprintf("INSERT INTO bands(`name`,`url`,`url-pic`,`tag1`,`tag2`) VALUES('%s','%s','%s','%s','%s')",mysql_real_escape_string($name2),mysql_real_escape_string($url2),mysql_real_escape_string($url3),mysql_real_escape_string($tag1),mysql_real_escape_string($tag2));

if($sql4) {
echo "<center>Die Band wurde erfolgreich der Datenbank hinzugef&uuml;gt.<br><a href='musik.php'>OK</a></center>";
} else {
echo "<center>Leider gab es beim Hinzuf&uuml;gen der Band einen Fehler.<br><a href='musik.php'>Zur&uuml;ck</a></center>";
}}
?>