|
|
|
|
Free!Music project
Музыка по артистам
|
query($sql);
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
if(($i > 30*($page-1)) && ($i <= 30*$page)) {
if($i == 16 + 30*($page-1)) {print ' | ';}
print "$i. ".trim($row['name_real'])."
";
}
$i++;
}
}elseif($type == 'albums') {
$sql = "SELECT id, title, year, public_date, singer_id from albums WHERE";
if(($letter != '0-9') && ($letter != 'любые')) {
$sql.= " title like '".$letter."%'";
}elseif($letter = '0-9') {
$sql.= " title like '0%' OR title like '1%' OR title like '2%' OR title like '3%' OR title like '4%' OR title like '5%' OR title like '6%' OR title like '7%' OR title like '8%' OR title like '9%' OR title like '!%' OR title like '\"%' OR title like '#%' OR title like '$%' OR title like '&%' OR title like '(%' OR title like ')%' OR title like '*%' OR title like '+%' OR title like '-%' OR title like '.%'";
//}else{
// $sql.= " title like '%'";
}
$sql.=" ORDER BY id";
$i = 1;
if(!isset($page)) {$page = 1;}
$result = $mysqli->query($sql);
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
if(($i > 30*($page-1)) && ($i <= 30*$page)) {
if($i == 16 + 30*($page-1)) {print ' | ';}
print "$i. ".trim($row['title'])."
";
}
$i++;
}
}
$n = $i - 1;
print " |
Другие страницы:";
for($str = 1; $str-1 < $i/30; $str++) {
if($str != $page) {print "$str ";}
else{print "".$str." ";}
}
print "
По данному запросу";
if($i!=0) {print " найдено $n записей.";}else{print " ничего не найдено.";}
?>
|
Исполнитель - ".$more."
| ";
print " ";
print " | Альбомы:
";
$sql = "SELECT id, title, year, public_date FROM albums WHERE singer_id=$artists ORDER BY year";
$i = 1;
$result = $mysqli->query($sql);
print "| № | Название | Год | Скачать | ";
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
print "| ";
print $i;
print ". | ";
print "".$row['title']."
";
print " | ";
print $row['year'];
print " | ";
print "->
";
$i++;
print " | ";
}
print "
";
}
?>
|
Исполнитель - ".$more."
Альбом - ".$title."
Скачать весь альбом
| ";
print " ";
print " | Песни:
";
$sql = "SELECT id, cd_order, title, bitrate, size, length FROM songs WHERE cd_id=$ti ORDER BY id";
$i = 1;
$result = $mysqli->query($sql);
print "| № | Название | Битрейт
/размер | Слушать
/скачать | ";
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
print "| ";
print $row['cd_order'];
print ". | ";
print $row['title'];
print " | ";
print $row['bitrate']."
".round($row['bitrate']/1024/1024,1)."Мб";
print " | ";
print "->
";
$i++;
print " | ";
}
print "
";
}
?>
|
|
|
