type and setup sql statement
switch ($field === 0 ? '': $field) {
case 'artist':
if ($type === 'fuzzy') {
$sql = "SELECT id FROM artist WHERE name LIKE '%$string%'";
}
else {
$sql = "SELECT id FROM artist WHERE name ='$string'";
}
$artists = get_artists($sql, 'format');
if ($artists) {
show_artists($artists);
}
else {
echo "" . _("No Results Found") . "
";
}
break;
case 'album':
if ($type === 'fuzzy') {
$sql = "SELECT id FROM album WHERE name LIKE '%$string%'";
}
else {
$sql = "SELECT id FROM album WHERE name='$string'";
}
$albums = get_albums($sql);
if (count($albums)) {
show_albums($albums);
}
else {
echo "" . _("No Results Found") . "
";
}
break;
case 'song_title':
if ($type === 'fuzzy') {
$sql = "SELECT id FROM song WHERE title LIKE '%$string%'";
}
else {
$sql = "SELECT id FROM song WHERE title = '$string'";
}
$song_ids = get_songs($sql, 'format');
if ($song_ids) {
show_songs($song_ids);
}
else {
echo "" . _("No Results Found") . "
";
}
break;
case 'song_genre':
if ($type === 'fuzzy') {
$sql = "SELECT song.id FROM song,genre WHERE song.genre=genre.id AND genre.name LIKE '%$string%'";
}
else {
$sql = "SELECT song.id FROM song,genre WHERE song.genre=genre.id AND genre.name='$string'";
}
$song_ids = get_songs($sql, 'format');
if ($song_ids) {
show_songs($song_ids);
}
else {
echo "" . _("No Results Found") . "
";
}
break;
case 'song_year':
if ($type === 'fuzzy') {
$sql = "SELECT song.id FROM song WHERE song.year LIKE '%$string%'";
}
else {
$sql = "SELECT song.id FROM song WHERE song.year='$string'";
}
$song_ids = get_songs($sql, 'format');
if ($song_ids) {
show_songs($song_ids);
}
else {
echo "" . _("No Results Found") . "
";
}
break;
case 'song_length':
case 'song_bitrate':
if ($type === 'fuzzy') {
$sql = "SELECT song.id FROM song WHERE song.bitrate LIKE '%$string%'";
}
else {
$sql = "SELECT song.id FROM song WHERE song.bitrate='$string'";
}
$song_ids = get_songs($sql, 'format');
if ($song_ids) {
show_songs($song_ids);
}
else {
echo "" . _("No Results Found") . "
";
}
break;
case 'song_min_bitrate':
$string = $string * 1000;
$sql = "SELECT song.id FROM song WHERE song.bitrate >= '$string'";
$song_ids = get_songs($sql, 'format');
if ($song_ids) {
show_songs($song_ids);
}
else {
echo "" . _("No Results Found") . "
";
}
break;
case 'song_comment':
if ($type === 'fuzzy') {
$sql = "SELECT song.id FROM song WHERE song.comment LIKE '%$string%'";
}
else {
$sql = "SELECT song.id FROM song WHERE song.comment='$string'";
}
$song_ids = get_songs($sql, 'format');
if ($song_ids) {
show_songs($song_ids);
}
else {
echo "" . _("No Results Found") . "
";
}
break;
case 'song_filename':
if ($type === 'fuzzy') {
$sql = "SELECT song.id FROM song WHERE song.file LIKE '%$string%'";
}
else {
$sql = "SELECT song.id FROM song WHERE song.file='$string'";
}
$song_ids = get_songs($sql, 'format');
if ($song_ids) {
show_songs($song_ids);
}
else {
echo "" . _("No Results Found") . "
";
}
break;
} // end switch
} // run_search
?>