Commune sans webcommandes
include ("connex281.inc");
$result=mysql_db_query("$db", "SELECT * FROM $tab WHERE numcom281='$numcom'")
or die("xxx");
while($ligne=mysql_fetch_object($result))
{
$comvil=$ligne->vil281;
if($comvil>0)
{ $titrecom="Ville"; }
else
{ $titrecom="Commune"; }
$nomcom=$ligne->nomcom281;
/* ajout variable de session */
session_start();
$_SESSION['sessionnomcom']=$nomcom;
/* fin encodage variable de session */
/* donnée province wal/bx pour annuaire 2 */
$provcom=$ligne->prov281;
$nomcom=$ligne->nomcom281;
/* commune en utf */
$nomcom=utf8_encode($nomcom);
/* commune sans accent */
$avant=$nomcom;
$avant=str_replace("à","a",$avant);
$avant=str_replace("â","a",$avant);
$avant=str_replace("ç","c",$avant);
$avant=str_replace("é","e",$avant);
$avant=str_replace("è","e",$avant);
$avant=str_replace("ê","e",$avant);
$avant=str_replace("ë","e",$avant);
$avant=str_replace("î","i",$avant);
$avant=str_replace("ô","o",$avant);
$avant=str_replace("ü","u",$avant);
$apres=str_replace("û","u",$avant);
$nomcom=$apres;
/* préposition de ou d' */
$char=$nomcom[0];
switch($char)
{
case A:
$prep=" d' ";
break;
case E:
$prep=" d' ";
break;
case I:
$prep=" d' ";
break;
case O:
$prep=" d' ";
break;
case U:
$prep=" d' ";
break;
case Y:
$prep=" d' ";
break;
default:
$prep=" de ";
}
echo "".$titrecom.$prep.strtoupper($nomcom)."
";
}
include ("deconnex.inc");
?>
"; } include ("deconnex.inc"); ?>
include ("connex16.inc");
$result=mysql_db_query("$db", "SELECT * FROM $tab WHERE numcom16='$numcom' ORDER BY 'nomvil16' ASC")
or die("xxx");
while($ligne=mysql_fetch_object($result))
{
$nomvil=$ligne->nomvil16;
$nomvil=utf8_encode($nomvil);
echo "• ".$nomvil." ";
}
echo "
"; include ("deconnex.inc"); ?>
"; include ("deconnex.inc"); ?>
Commerces d'alimentation
livrant dans toute ou partie de l'entité
include ("connex1.inc");
$result=mysql_db_query("$db", "SELECT * FROM $tab WHERE numcom1='$numcom' AND star1<3 ORDER BY star1 ASC")
or die("xxx");
while($ligne=mysql_fetch_object($result))
{
$num=$ligne->num1;
$type=$ligne->type1;
$statut=$ligne->statut1;
$nom=$ligne->nom1;
$star=$ligne->star1;
SWITCH($star)
{
case 0:
$star=" ";
break;
case 1:
$star="*";
break;
case 2:
$star="**";
break;
case 3:
$star="***";
break;
case 4:
$star="****";
break;
case 5:
$star="*****";
break;
default:
$star="";
break;
}
$activite=$ligne->activite1;
$activite=utf8_encode($activite);
$flashinfo=$ligne->flashinfo1;
$rueno=$ligne->rueno1;
$rueno=utf8_encode($rueno);
$cpost=$ligne->cpost1;
$localite=$ligne->localite1;
$localite=utf8_encode($localite);
$tel=$ligne->tel1;
$email=$ligne->email1;
$facebook=$ligne->facebook1;
$facebook=utf8_encode($facebook);
$web=$ligne->web1;
$dateconnex=$ligne->dateconnex1;
$zdif=$ligne->zdif1;
echo "".$nom." ".$star."
"; echo "".$rueno.", ".$cpost." ".$localite."
"; echo "".$activite."
"; echo ""."Pour livraison à domicile, contactez le ".$tel."
"; $webnom=$web; $http="http://www."; $https="https://www."; $blanc=""; $webnom=str_replace($http,$blanc,$webnom); $webnom=str_replace($https,$blanc,$webnom); echo ""."Site internet : ".$webnom."
"; echo ""."Facebook : ".$facebook."
"; /* echo ""."Réf. ".$num." - "; echo "Mis à jour le "; echo substr($dateconnex,8,2); echo "/"; echo substr($dateconnex,5,2); echo "/"; echo substr($dateconnex,0,4); echo "
"; */ } include ("deconnex.inc"); ?>
"; echo "".$rueno.", ".$cpost." ".$localite."
"; echo "".$activite."
"; echo ""."Pour livraison à domicile, contactez le ".$tel."
"; $webnom=$web; $http="http://www."; $https="https://www."; $blanc=""; $webnom=str_replace($http,$blanc,$webnom); $webnom=str_replace($https,$blanc,$webnom); echo ""."Site internet : ".$webnom."
"; echo ""."Facebook : ".$facebook."
"; /* echo ""."Réf. ".$num." - "; echo "Mis à jour le "; echo substr($dateconnex,8,2); echo "/"; echo substr($dateconnex,5,2); echo "/"; echo substr($dateconnex,0,4); echo "
"; */ } include ("deconnex.inc"); ?>
/* 1er encodage de variable de session dans PAGECOMENTETE */
session_start();
$_SESSION['sessionnumnom']=$numcom;
?>
/* affichage des commerçants avec 3,4 ou 5 étoiles (si zdif1=ht,bw,lg,nam,lux ou br) */
include ("connex1.inc");
$result=mysql_db_query("$db", "SELECT * FROM $tab WHERE zdif1='$provcom' AND star1>2 ORDER BY star1 ASC")
or die("xxx");
while($ligne=mysql_fetch_object($result))
{
$num=$ligne->num1;
$type=$ligne->type1;
$statut=$ligne->statut1;
$nom=$ligne->nom1;
$star=$ligne->star1;
SWITCH($star)
{
case 0:
$star=" ";
break;
case 1:
$star="*";
break;
case 2:
$star="**";
break;
case 3:
$star="***";
break;
case 4:
$star="****";
break;
case 5:
$star="*****";
break;
default:
$star="";
break;
}
$activite=$ligne->activite1;
$activite=utf8_encode($activite);
$flashinfo=$ligne->flashinfo1;
$rueno=$ligne->rueno1;
$rueno=utf8_encode($rueno);
$cpost=$ligne->cpost1;
$localite=$ligne->localite1;
$localite=utf8_encode($localite);
$tel=$ligne->tel1;
$email=$ligne->email1;
$facebook=$ligne->facebook1;
$facebook=utf8_encode($facebook);
$web=$ligne->web1;
$dateconnex=$ligne->dateconnex1;
echo "".$nom." ".$star."
"; echo "".$rueno.", ".$cpost." ".$localite."
"; echo "".$activite."
"; echo ""."Pour livraison à domicile, contactez le ".$tel."
"; $webnom=$web; $http="http://www."; $https="https://www."; $blanc=""; $webnom=str_replace($http,$blanc,$webnom); $webnom=str_replace($https,$blanc,$webnom); echo ""."Site internet : ".$webnom."
"; echo ""."Facebook : ".$facebook."
"; /* echo ""."Réf. ".$num." - "; echo "Mis à jour le "; echo substr($dateconnex,8,2); echo "/"; echo substr($dateconnex,5,2); echo "/"; echo substr($dateconnex,0,4); echo "
"; */ } include ("deconnex.inc"); ?>
"; echo "".$rueno.", ".$cpost." ".$localite."
"; echo "".$activite."
"; echo ""."Pour livraison à domicile, contactez le ".$tel."
"; $webnom=$web; $http="http://www."; $https="https://www."; $blanc=""; $webnom=str_replace($http,$blanc,$webnom); $webnom=str_replace($https,$blanc,$webnom); echo ""."Site internet : ".$webnom."
"; echo ""."Facebook : ".$facebook."
"; /* echo ""."Réf. ".$num." - "; echo "Mis à jour le "; echo substr($dateconnex,8,2); echo "/"; echo substr($dateconnex,5,2); echo "/"; echo substr($dateconnex,0,4); echo "
"; */ } include ("deconnex.inc"); ?>
$jour=date("z");
/* echo "Jour n° ".$jour."
"; */ include ("connex99.inc"); $result=mysql_db_query("$db", "SELECT * FROM $tab WHERE jour99='$jour'") or die("xxx"); while($ligne=mysql_fetch_object($result)) { $nbre=$ligne->nbre99; echo "Nbre de pages visualisées ce jour : ".$nbre; } /* mettre à jour le compteur */ $nbre=$nbre+1; $result=mysql_db_query("$db", "UPDATE $tab SET nbre99='$nbre' WHERE jour99='$jour'") or die("xxx"); include ("deconnex.inc"); ?>
"; */ include ("connex99.inc"); $result=mysql_db_query("$db", "SELECT * FROM $tab WHERE jour99='$jour'") or die("xxx"); while($ligne=mysql_fetch_object($result)) { $nbre=$ligne->nbre99; echo "Nbre de pages visualisées ce jour : ".$nbre; } /* mettre à jour le compteur */ $nbre=$nbre+1; $result=mysql_db_query("$db", "UPDATE $tab SET nbre99='$nbre' WHERE jour99='$jour'") or die("xxx"); include ("deconnex.inc"); ?>
/* script IP */
function get_ip() {
if (isset($_SERVER['HTTP_CLIENT_IP'])) {
return $_SERVER['HTTP_CLIENT_IP'];
}
elseif (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {
return $_SERVER['HTTP_X_FORWARDED_FOR'];
}
else {
return (isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : '');
}
}
$ip=get_ip();
$jour=date("z");
$date=date("d/m/y - H:i:s");
/* echo "Jour : ".$jour."
"; $date=date("d/m/y H:i:s"); echo "Date : ".$date."
"; echo "N° com : ".$numcom."
"; echo "Nom com : ".$nomcom."
"; echo "IP : ".$ip."
"; */ include ("connex98.inc"); $result=mysql_db_query("$db", "INSERT INTO $tab(jour98,date98,numcom98,nomcom98,ip98) VALUES ('$jour','$date','$numcom','$nomcom','$ip')") or die("xxx"); include ("deconnex.inc"); ?>
"; $date=date("d/m/y H:i:s"); echo "Date : ".$date."
"; echo "N° com : ".$numcom."
"; echo "Nom com : ".$nomcom."
"; echo "IP : ".$ip."
"; */ include ("connex98.inc"); $result=mysql_db_query("$db", "INSERT INTO $tab(jour98,date98,numcom98,nomcom98,ip98) VALUES ('$jour','$date','$numcom','$nomcom','$ip')") or die("xxx"); include ("deconnex.inc"); ?>