""){
$nb_visite=$row[nb_visite]+1;
mysql_query("update visiteur set nb_visite='".$nb_visite."' where code='".$row[code]."'");
$verif=mysql_query("select * from page where code='".$row[code]."' and page='".$nom_page."'");
$verif_row=mysql_fetch_array($verif);
if ($verif_row[page]<>""){
$p_visite=$verif_row[nb_visite]+1;
$requete="update page set nb_visite='".$p_visite."' where code='".$row[code]."' and page='".$verif_row[page]."'";
mysql_query($requete);
}
else
{
mysql_query("insert into page values ('".$row[code]."','".$nom_page."','1','".$heure."')");
}
}
else {
// détermination du code permettant la jointure entre la table visiteur et page
$result=mysql_query("select max(code) as cd from visiteur");
if($last_code=mysql_fetch_array($result)){
$the_last=$last_code[cd];
$anneemois=substr($the_last,0,4)."/".substr($the_last,4,2);
$verif_date=date("Y/m");
if($anneemois==$verif_date){
$cp=$the_last+1;
}
else {
$cp=date("Y").date("m")."00000001";
}
}
else {
$cp=date("Y").date("m")."00000001";
}
$host=gethostbyaddr($REMOTE_ADDR);
$url=explode(".",$host);
$nb=count($url);
for($cpt2=0;$cpt2<$nb;$cpt2++){
$dom=$url[$cpt2];
$sql1=mysql_query("select * from domaines where domaine='".$dom."'");
$row=mysql_fetch_array($sql1);
if($row[domaine]<>""){
$domaines=$row[description];
}
}
if ($domaines==""){ $domaines="Adresse IP";}
if ($domaines=="-"){ $domaines=".com .net .org .edu";}
$sql1="insert into visiteur values('".$HTTP_USER_AGENT."','".$HTTP_REFERER."','".$REMOTE_ADDR."','".$date."','".$host."','".$cp."','".$domaines."','1')";
$sql="insert into page values ('".$cp."','".$nom_page."','1','".$heure."')";
$result=mysql_query($sql1) or die ("requete invalide visiteurs nouveau");
$result=mysql_query($sql) or die ("requete invalide page");
}
?>
 |
55 / 83
|
|
|
 2. Former web sitesSend me a mail to add your site ! (Please note that I disclaim any responsibility regarding the contents of these web sites. Their respective authors remain responsible of what they publish.) 
1 2
|