Search results for tag \"$tag\"
\n";
//escape from PHP mode.
echo "
|
Results $first - $last of $numrows
|
Page ".floor($current)." of $total
|
\n";
if ($page != 0) { // Don't show back link if current page is first page.
$back_page = $page - $limit;
echo "
back\n";}
for ($i=1; $i <= $pages; $i++) // loop through each page and give link to it.
{
$ppage = $limit*($i - 1);
if ($ppage == $page){
echo("
$i \n");} // If current page don't give link, just text.
else{
echo "
$i \n";}
}
if (!((($page+$limit) / $limit) >= $pages) && $pages != 1) { // If last page don't give next link.
$next_page = $page + $limit;
echo " [
next]\n";}
echo "
| Aria |
Opera |
Composer |
Preview |
Info |
\n";
// Now we can display results.
$query4 = "SET NAMES utf8";
mysql_query($query4);
$results = mysql_query("SELECT * FROM arie WHERE tag1='$tag' OR tag2='$tag' OR tag3='$tag' OR tag4='$tag' ORDER BY titolo LIMIT $page, $limit");
if (!$results) {
die('Invalid query: ' . mysql_error());
}
while ($data = mysql_fetch_array($results))
{
$compositore=$data["compositore"];
$titolo=$data["titolo"];
$link=$data["link"];
$opera=$data["opera"];
$personaggio=$data["personaggio"];
$comp_id=$data["comp_id"];
$aria_id=(integer)$data["aria_id"];
$video=$data['video'];
$row2 = get_compositore_details ($comp_id);
$comp_link=$row2["link"];
$keyword=$row2["keyword"];
$nome_comp=get_composer_nome($comp_id);
$clip_audio=$data["clip"];
$row3 = get_voce_details($voce_id);
$voce_desc=$row3["voce_desc"];
$voce_link=$row3["voce_link"];
$aria_link=get_aria_link($aria_id, $titolo, $keyword);
echo "\n";
if (strlen($tiolo) > 38) {
$data['titolo']=substr($titolo, 0, 36)."...";
}
echo " $titolo";
if ($massimo==$aria_id || $massimo==($aria_id-1) || $massimo==($aria_id-2) || $massimo==($aria_id-3)) {
echo " ";
}
if (strlen($opera) > 17) {
$opera=substr($opera, 0, 16)."...";
}
echo " | $opera | \n";
echo "$compositore | ";
$isiPad = (bool) strpos($_SERVER['HTTP_USER_AGENT'],'iPad');
if ($isiPad==False || strstr($_SERVER['HTTP_USER_AGENT'],'iPhone') || strstr($_SERVER['HTTP_USER_AGENT'],'iPod')) {
if ($video==1) {
echo "";
echo "
";
echo " | ";
$video_preview=get_aria_video_preview($aria_id);
/*echo "
| \n";*/
echo "
| ";
}
else {
echo "";
echo "
";
echo " | ";
}
}
else {
if ($video==1) {
echo "";
echo "
";
echo " | ";
/*echo "
| \n";*/
echo "
| \n";
}
else {
echo "";
echo "
";
echo " | ";
}
}
// echo "";
echo "Info / Buy | \n";
echo "
\n";
}
echo "
\n";
if ($page != 0) { // Don't show back link if current page is first page.
$back_page = $page - $limit;
echo "
back\n";}
for ($i=1; $i <= $pages; $i++) // loop through each page and give link to it.
{
$ppage = $limit*($i - 1);
if ($ppage == $page){
echo("
$i \n");} // If current page don't give link, just text.
else{
echo "
$i \n";}
}
if (!((($page+$limit) / $limit) >= $pages) && $pages != 1) { // If last page don't give next link.
$next_page = $page + $limit;
echo " [
next]\n";}
echo "";
?>
Browse by Tag \"$tag\" page ".floor($current)."