rendered paste body<html>
<head>
<title>Albums</title>
</head>
<body>
<?php
include_once("connect.php");
$album=$_GET['id'];
$query=mysql_query("SELECT * FROM albums WHERE id=$album");
$albums=mysql_fetch_array($query);
printf("Title: %s<br/><br/>", $albums[2]);
printf("Tracks(%d):<br/>", $albums[3]);
$nquery=mysql_query("SELECT * FROM tracks WHERE albumid=$album");
$i=0;
while($tracky=mysql_fetch_array($nquery)) {
++$i;
printf("Song %d: <a href=\"lyrics.php?trackid=%d\">%s</a><br/>", $i, $tracky[0], $tracky[1]);
}
?>
</body>
</html>
<html>
<head>
<title>Add Music</title>
</head>
<body>
Add music
<br/><br/>
<form method="GET" action="add.php">
Album: <input type="text" name="album"> <br/>
Title: <input type="text" name="title"> <br/>
Art: <input type="text" name="art"> <br/>
Tracks: <input type="text" name="tracks"> <br/>
Year: <input type="text" name="year"> <br/>
<input type="submit" value="add">
</form>
</body>
</html>
<?php
include_once("connect.php");
$tracks=$_GET['tracks'];
$album=$_GET['album'];
$title=$_GET['title'];
$art=$_GET['art'];
$year=$_GET['year'];
$query=mysql_query("INSERT INTO albums (id, year, title, tracks, art) VALUES ('', '$year', '$title', '$tracks', '$art')");
$albumid_query=mysql_query("SELECT * FROM albums");
$albumid=mysql_num_rows($albumid_query);
print "<form method=\"POST\" action=\"addt.php?albumid=$albumid\">";
for($i=0; $i<$tracks; ++$i) {
print "Song name: <input type=\"text\" name=\"song$i\"><br/>";
print "Lyrics: <br/> <textarea name=\"lyric$i\" rows=\"20\" cols=\"50\"></textarea><br/>";
}
?>
<input type="submit" value="add the songs and lyrics">
</form>
<?php
?>
<?php
include_once("connect.php");
$i=0;
$albumid=$_GET['albumid'];
print $albumid;
print $_POST["song$i"];
while(isset($_POST["song$i"])) {
$songy=$_POST["song$i"];
$lyrics=$_POST["lyric$i"];
print $lyrics;
$qu=mysql_query("INSERT INTO tracks (id, song, albumid) VALUES ('', '$songy', '$albumid')");
$qul=mysql_query("INSERT INTO lyrics (id, lyric, lyricid) VALUES ('', '$lyrics', '')");
$i++;
}
?>
<html>
<head>
<title>Admin</title>
</head>
<body>
<?php
include_once("connect.php");
$query=mysql_query("SELECT * FROM albums");
$albumsnum=mysql_num_rows($query);
print "Albums($albumsnum)<br/><br/>";
if($albumsnum==0) {
print "There are no albums";
}
else {
while($albums=mysql_fetch_array($query)) {
print "<a href=\"delete.php?album=$albums[0]\">Delete</a> ";
print "<a href=\"edit.php?album=$albums[0]\">Edit</a> ";
print "<a href=\"add.html\">Add</a><br/>";
printf("<a href=\"album.php?id=%d\">%s</a>#%d<br/>", $albums[0], $albums[2], $albums[3]);
printf(" Art: <img src=\"%s\"><br/>", $albums[4]);
printf(" Year: %d<br/>", $albums[1]);
//printf(" Tracks: %d<br/>", $albums[3]);
printf("<br/>");
}
}
?>
</body>
</html>
<html>
<head>
<title>Albums</title>
</head>
<body>
<?php
include_once("connect.php");
$query=mysql_query("SELECT * FROM albums");
$albumsnum=mysql_num_rows($query);
print "Albums($albumsnum)<br/><br/>";
if($albumsnum==0) {
print "There are no albums";
}
else {
while($albums=mysql_fetch_array($query)) {
printf("<a href=\"album.php?id=%d\">%s</a>#%d<br/>", $albums[0], $albums[2], $albums[3]);
printf(" Art: <img src=\"%s\"><br/>", $albums[4]);
printf(" Year: %d<br/>", $albums[1]);
//printf(" Tracks: %d<br/>", $albums[3]);
printf("<br/>");
}
}
?>
</body>
</html>
<?php
include_once("connect.php");
$album=$_GET['album'];
echo $album;
$delquery=mysql_query("DELETE FROM albums WHERE id='$album'");
if($delquery) {
echo "The album was sucesfully deleted";
}
else {
echo "There was an error by deleting. Please try again";
}
?>
<?php
include_once("connect.php");
$album=$_GET['album'];
echo $album;
$delquery=mysql_query("DELETE FROM albums WHERE id='$album'");
if($delquery) {
echo "The album was sucesfully deleted";
}
else {
echo "There was an error by deleting. Please try again";
}
?>
<html>
<head>
<title>Lyrics</title>
</head>
<body>
<?php
include_once("connect.php");
$track=$_GET['trackid'];
$query=mysql_query("SELECT * FROM lyrics WHERE id=$track");
$lyrics=mysql_fetch_array($query);
printf("%s<br/>", $lyrics[1]);
?>
</body>
</html>