Denne kode lister albumne fra dvden, det er den der hedder albums.php
Koden ser sådan her ud :
------------------------
<?php
require("database.php");
if(is_array($HTTP_GET_VARS))
{
$letter = $HTTP_GET_VARS['letter'];
$dvd_id = $HTTP_GET_VARS['dvd'];
}
elseif(is_array($_GET))
{
$letter = $_GET['letter'];
$dvd_id = $_GET['dvd'];
}
if($letter == "" && $dvd_id == "")
{
// header("Location: test.php");
exit;
}
if ($letter != "")
{
$sql = "
select albums.name,count(albums.name) as CDS
from albums
where lower(albums.name) like lower('$letter%')
group by albums.name
order by 1
";
$info="Albums that starts with <font color=\"#0000ff\">" . strtoupper($letter) . "</font>";
}
elseif ($dvd_id != "")
{
$sql = "
select albums.name,count(albums.name) as CDS
from albums
where dvd_id = '$dvd_id'
group by albums.name
order by 1
";
$resultat = preform_sql("select name from dvd where dvd_id ='$dvd_id'");
while ($row=mysql_fetch_array($resultat))
{
$dvdname = $row[0];
}
$info="Albums on <font color=\"#0000ff\">$dvdname</font>";
}
$resultat = preform_sql($sql);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>DiskCollection By FuckMyAss.dyndns.biz</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="dvd.css" rel="stylesheet" type="text/css">
</head>
<body class="cdlogo">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td height="112" align="center">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td width="70%" align="right">
</td>
<td height="112" align="left">
<form name ="searchform" action="search.php" metode="POST" class="content">
<strong class="sogebox">Enter Keyword:</strong><br />
<input name="searchtext" type="text" />
<br />
<input name="searchtype" type="radio" value = "album" checked/> <strong class="sogebox">Album Name</strong>
<input name="searchtype" type="radio" value = "song"/> <strong class="sogebox">Track Name</strong>
<br />
<br />
<input name="submit" type="submit" value = "submit"/>
<br />
<br />
<br />
<br />
</form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
</tr>
<tr>
<td align="left" valign="top" id="content"> <br />
<?php
echo "<p class=\"lineshift\">$info<div align=\"right\"><a href=\"index.php\">DVDs</a></div></p>\n";
while ($row = mysql_fetch_array($resultat))
{
$album_name = $row['name'];
$cd_count = $row['CDS'];
if ($cd_count > 1 )
{
echo "\t<strong class=\"menulink2\"><a href=\"tracks.php?id="
. find_album_id($album_name,1)
. "\">$album_name</a>";
for ($i = 2;$i<$cd_count+1;$i++)
{
echo "<a href=\"tracks.php?id="
. find_album_id($album_name,$i)
. "\"><font color=\"#000000\"> CD $i </font></a>";
}
echo "</strong><br />\n";
}
else
{
echo "<strong class=\"menulink2\"><a href=\"tracks.php?id="
. find_album_id($album_name,1)
. "\">$album_name</a></strong><br />\n";
}
}
?>
</td>
</tr>
</table>
</body>
</html>
