|
DISCOTHEQUES NIGHTCLUBS BORDEAUX : Help you to find a good place to dance in Bordeaux
|
|
|
People here are for nightclubbers, who like dancing all night long on fury rhythms, salsa, techno, trance, rnb, hip-hop, rock... It is the moment to move your body, to find the discotheque of Bordeaux that will be convenient for you at best, you can also leave your comment on a night club of Bordeaux, to find the plan to go has your discotheque... Here is the guide of night clubs and discotheques of Bordeaux.
// NOMBRE DE RESULTATS PAR PAGE
$limit=20;
// NOM DE CE SCRIPT
$script_name="nightclub.php";
include("../../moteur/admin/configmot.php");
// RECHERCHE AVEC TOUS LES MOTS : METTEZ "and"
// RECHERCHER LES PAGES QUI CONTIENNENT AU MOINS UN MOT : METTEZ "or"
$et_ou="and";
$db_link = mysql_connect("$sql_serveur","$sql_user","$sql_passwd");
$mot="disco";
$mots=split(" ",$mot);
$nombre_mots=count($mots);
$z=1;
$texte=" "Bars and Pub"";
$phrase="'%$mots[0]%'";
while($z<$nombre_mots)
{
$phrase.=" ".$et_ou." mots like '%$mots[$z]%'";
$texte.=" ";
if($et_ou=="and"){$texte.="et";}else{$texte.="ou";}
$texte.=" "$mots[$z]"";
$z++;
}
if($debut==""){$debut=0;}
$debut=$page*$limit;
// NOMBRE TOTAL D'ENREGISTREMENTS REPONDANT A LA REQUETE
$requete=mysql_db_query("$sql_bdd","select count(*) from recherche where mots like $phrase order by id",$db_link);
$nb_total=mysql_result($requete,0,"count(*)");
$requete=mysql_db_query("$sql_bdd","select * from recherche where mots like $phrase limit $debut,$limit",$db_link);
$num=mysql_num_rows($requete);
// DEFINITION DU MESSAGE A AFFICHER
if ($num==0) {echo "We're sorry ; no page of this website with $texte...";}
else if ($mot=="") {echo "Put one ore two words before 'OK' !";}
else if (strlen($mot)<2) {echo "Please min 2 characters.";}
// AFFICHAGE DES RESULTATS
else {
echo " | ";
$i=0;
while($i<$num)
{
$largefile=mysql_result($requete,$i,"largefile");
$url1=mysql_result($requete,$i,"url1");
$description=mysql_result($requete,$i,"descuk");
$titre=mysql_result($requete,$i,"titre");
$urlperso=mysql_result($requete,$i,"urlperso");
if ($url1=="" and $urlperso=="") {echo " ."\") | ";}
else if ($url1=="") {echo " ."\") | ";}
else if ($urlperso=="") {echo " ."\") | ";}
else echo " ."\") | ";
echo "$titre
$description ";
if ($url1=="" and $urlperso=="") {echo "
NO LINKS FOR THE MOMENT
| ";}
else if ($url1=="") {echo "
";}
else if ($urlperso=="") {echo "
";}
else echo "
INFOS : $titreWeb Site : $urlperso
";
$i++;
}
echo "
";
// AFFICHAGE DU LIEN PRECEDENT SI BESOIN EST
// (LA PREMIERE PAGES EST 0)
if ($page>0)
{
$precedent=$page-1;
print "ANTERIOR \n";
}
// AFFICHAGE DES NUMEROS DE PAGE
$i=0;$j=1;
if($nb_total>$limit)
{
while($i<($nb_total/$limit))
{
if($i!=$page){echo "($j) ";}
else {echo "($j) ";}
$i++;$j++;
}
}
// AFFICHAGE DU LIEN SUIVANT SI BESOIN EST
if($debut+$limit<$nb_total)
{
$suivant=$page+1;
echo "SIGUIENTE";
}
}
// DECONNEXION DE LA BASE DE DONNEE
mysql_close($db_link);
?>
|
|