";
//www.phpdebutant
$db = mysql_connect("$host", "$user", "$password");
mysql_select_db("$base",$db);
if($limit==''){ $limit = 0; }
//Elagage chaîne request
$request=trim($request);
$count_req = mysql_query("SELECT * FROM data WHERE etat=1 AND souscat LIKE '%$request%'");
$count = mysql_num_rows($count_req);
$comptage_req = mysql_query("SELECT * FROM data WHERE etat=1 AND souscat LIKE '%$request%' ORDER BY numero DESC LIMIT $limit, 10");
$comptage = mysql_num_rows($comptage_req);
echo "$count site(s) trouvé(s) | ";
echo "Proposer un site | ";
echo "Contacter le Webmaster\n";
echo "
\n";
$i=0;
$a=0; // compteur => numéroteur de site
WHILE($i!=$comptage)
{
//$numero = mysql_result($comptage_req,$i,"numero");
$url = mysql_result($comptage_req,$i,"url");
$titre = mysql_result($comptage_req,$i,"titre");
$description = mysql_result($comptage_req,$i,"description");
$date = mysql_result($comptage_req,$i,"date");
$time = mysql_result($comptage_req,$i,"time");
// nettoyage
$description = stripslashes(stripslashes($description));
$titre = stripslashes(stripslashes($titre));
$etat = stripslashes(stripslashes($etat));
$a++;
echo "\n";
echo "
\n";
echo "| $titre |
\n";
echo "| $description |
\n";
//echo " | $url>\'> |
\n";
echo "| $url |
\n";
echo "
\n\n";
$i++;
}
// gestion des liens pages ----------------------------
$pages = $count / 10;
$pages = floor($pages);
if($count>10)
{
$footer = "Pages: index\n";
//echo"Les 10 résultats suivants >>";
if($count==40){ $i = 1; }else{ $i = 0; }
$comptage = 10;
$page_num = 2;
WHILE($i!=$pages)
{
if($limit==$comptage)
{
$footer .= " | $page_num\n";
$comptage += 10;
$page_num++;
$i++;
}
else
{
$footer .= " | $page_num\n";
$comptage += 10;
$page_num++;
$i++;
}
}
}
$reste = $count - $limit - 10;
$reste_limit = $limit + 10;
if($reste<=0)
{
$reste = "Fin de la liste";
$avant = "";
$apres = "";
}
else
{
$reste = "10 affichés - Reste ";
$reste .= $count - $limit - 10;
$avant = "";
$apres = "";
}
if($count==0)
{
$reste = "Aucun site ne correspond à votre recherche";
$avant = "";
$apres = "";
}
echo "[$avant"."$reste"."$apres]
\n";
echo "$footer\n";
echo "
\n";
echo "(c)2001 MiniClic, L'Univers des Enfants\n";
mysql_close();
//}
?>