View file lospaciprian/muzica/cauta.php

<?php

include("meniu_sus.php");
$actiune = htmlspecialchars($_GET["actiune"]);
if($actiune=="rezultate") {
$pagina = (int)$_GET["pagina"];
$cuvant = htmlspecialchars($_GET["cuvant"]);
echo '<title>Rezultate Gasite</title>
<div class="titlu"><b>Rezultate Gasite</b></div>';
$exista_cuvant = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fisiere WHERE `nume` LIKE '%".$cuvant."%'"));
if($exista_cuvant[0]==0||$cuvant=="") {
echo '<center>Eroare in cautare!</center><div class="wap"></div>';
}else{
echo "<center><form action=\"http://".$_SERVER["SERVER_NAME"]."/cauta.php\" method=\"get\">
Numele Melodiei:<br/><input type=\"text\" name=\"cuvant\" value=\"$cuvant\" maxlength=\"100\"><br/>
<input type=\"hidden\" name=\"actiune\" value=\"$actiune\">
<input type=\"submit\" value=\"Cauta\"></form></center><div class=\"wap\"></div>";
if($pagina==""||$pagina<=0) $pagina=1;
$nr = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM fisiere WHERE `nume` LIKE '%".$cuvant."%'"));
$optiune = mysql_fetch_array(mysql_query("SELECT * FROM optiuni_site WHERE nume='pe_pagina'"));
$pe_pagina = $optiune[valoare];
$nr_pagini = ceil($nr[0]/$pe_pagina);
if(($pagina>$nr_pagini)&&$pagina!=1) $pagina = $nr_pagini;
$limita = ($pagina-1)*$pe_pagina;
$cate = $limita;
$files = mysql_query("SELECT * FROM fisiere WHERE `nume` LIKE '%".$cuvant."%' ORDER BY id DESC LIMIT $limita, $pe_pagina");
while($file=mysql_fetch_array($files)) {
$cate++;
$time = time()-(24*60*60);
echo "<font color=\"#FF8040\"><b>$cate</b></font>. <img src=\"http://".$_SERVER["SERVER_NAME"]."/imagini/fisier.gif\" alt=\"*\"><b><a href=\"http://".$_SERVER["SERVER_NAME"]."/index.php?actiune=fisier&id=$file[id]\" title=\"$file[nume]\">$file[nume]</a></b>";
if($file[data]>$time) { echo " <img src=\"http://".$_SERVER["SERVER_NAME"]."/imagini/new.gif\" alt=\"*\">"; }
$categ = mysql_fetch_array(mysql_query("SELECT * FROM categorii WHERE id='$file[cid]'"));
echo "<br/>[<a href=\"http://".$_SERVER["SERVER_NAME"]."/index.php?actiune=categ&id=$categ[id]\">$categ[nume]</a>] - [Hits: <font color=\"yellow\">".afla_nr($file[hits])."</font>]<div class=\"wap\"></div>"; }
if($nr_pagini==0) {}else{
if($pagina>1) {
$inapoi = $pagina-1;
echo "<table width=\"100%\" bgcolor=\"#084B8A\" cellpadding=\"0\" cellspacing=\"0\"><tr><td>
<a href=\"http://".$_SERVER["SERVER_NAME"]."".$_SERVER["SCRIPT_NAME"]."?actiune=$actiune&cuvant=$cuvant&pagina=$inapoi\"><font color=\"white\"><b>&#171;pagina anterioara</b></font></a><br/></td></tr></table>"; }
if($pagina<$nr_pagini) {
$inainte = $pagina+1;
echo "<table width=\"100%\" bgcolor=\"#084B8A\" cellpadding=\"0\" cellspacing=\"0\"><tr><td>
<a href=\"http://".$_SERVER["SERVER_NAME"]."".$_SERVER["SCRIPT_NAME"]."?actiune=$actiune&cuvant=$cuvant&pagina=$inainte\"><font color=\"white\"><b>&#187;pagina urmatoare</b></font></a></td></tr></table>"; }
echo "<br/>Pagina <b>$pagina</b> din <b>$nr_pagini</b><br/>";
if($nr_pagini>2) {
echo "<form action=\"http://".$_SERVER["SERVER_NAME"]."/cauta.php\" method=\"get\">
<input type=\"hidden\" name=\"actiune\" value=\"$actiune\">
Du-te la pagina Nr: <input name=\"pagina\" size=\"3\" value=\"$pagina\">
<input type=\"hidden\" name=\"cuvant\" value=\"$cuvant\">
<input type=\"submit\" value=\"Trimite\"></form>"; }}}
echo "<center><img src=\"http://".$_SERVER["SERVER_NAME"]."/imagini/home.gif\" alt=\"*\"><b><a href=\"http://".$_SERVER["SERVER_NAME"]."/cauta.php\" title=\"Meniu Cautare\">Meniu Cautare</a></b></center>";
}else{
echo '<title>Cautare</title>
<div class="titlu"><b>Cautare</b></div>';
echo "<center><form action=\"http://".$_SERVER["SERVER_NAME"]."/cauta.php\" method=\"get\">
Numele Melodiei:<br/><input type=\"text\" name=\"cuvant\" value=\"$cuvant\" maxlength=\"100\"><br/>
<input type=\"hidden\" name=\"actiune\" value=\"rezultate\">
<input type=\"submit\" value=\"Cauta\"></form><div class=\"wap\"></div>
<img src=\"http://".$_SERVER["SERVER_NAME"]."/imagini/home.gif\" alt=\"*\"><b><a href=\"http://".$_SERVER["SERVER_NAME"]."/index.php\" title=\"Meniu Prim\">Meniu Prim</a></b></center>"; }
include("meniu_jos.php");

?>