$val){ if(!isset($GLOBALS[$var])){ $$var = $val; //echo "
$var =".$val; } } } if ($url != $host){ MYSQL_CONNECT($hostname, $username, $password) OR DIE(mysqlerror()); @mysql_select_db( "$dbName") or die(mysqlerror()); $query = mysql_fetch_row(mysql_query( "select * from $userstable where(url = '$url')")); if ($query == false){ $hits = "1"; $query2 = "INSERT INTO $userstable (url,hits) VALUES('$url','$hits')"; } else { $hitquery = "select hits from $userstable where url = '$url'"; $result = mysql_query($hitquery); $hits = mysql_result($result, 0, "hits"); $query2 = "update $userstable set hits = hits+1 where url = '$url'"; } MYSQL_QUERY($query2); // 1/9/2000 // Compter la page d'appel $page_appel=basename($HTTP_REFERER); $requete="select id from $userstable where url = '$url' "; $result=mysql_query($requete); $id_redirect=mysql_result($result, 0, "id"); $requete="select hits from $pagetable where id_url = '$id_redirect' and page = '$page_appel' "; $pagequery=mysql_fetch_row(mysql_query( $requete )); if ($pagequery==false) { $hits="1"; $query2="INSERT INTO $pagetable (id_url,page,hits) VALUES ('$id_redirect','$page_appel','$hits')"; } else { $hits = $pagequery[0]; $query2 = "update $pagetable set hits = hits+1 where page = '$page_appel' and id_url= '$id_redirect' "; } MYSQL_QUERY($query2); } if(!$url) { $url = "$host"; } else { Header( "Location: $url"); } ?>