""){ $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 { // dtermination 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"); } ?>
WebIdeaTree Диспетчер содержания и создатель сайтов web
Введение
|
Редактирование текста идеи
