Auto increment updaten

Raar ik krijg het niet voor elkaar, ik post hier mn hele pagina ff, hoop dat het niet voor overlast zorgt

<?
session_start();
$_SESSION['userData'];
$verloopdata = time() + 86400;
setcookie('countProtect','count_al_geregistreerd', $verloopdata, '','*.gigabyte.barrypostma.com');
?>

<?

$server = "localhost"; // Your mySQL Server
$db_user = "zeg ik niet"; // Your mySQLUsername
$db_pass = "blijft ook geheim"; // Your mySQLPassword
$database = "barrypos_visitors"; // Your mySQLDatabasename

$timeoutseconds = 120;
$timestamp=time();
$timeout=$timestamp-$timeoutseconds;

//IP adres verkrijgen
if(getenv($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$ip = getenv($_SERVER['HTTP_X_FORWARDED_FOR']);
} elseif(getenv($_SERVER['HTTP_CLIENT_IP'])) {
$ip = getenv($_SERVER['HTTP_CLIENT_IP']);
} else {
$ip = $_SERVER['REMOTE_ADDR'];
}
$host = gethostbyaddr($ip);



$dblink = mysql_connect($server, $db_user, $db_pass) or die ("Useronline Database CONNECT Error");

mysql_db_query($database, "INSERT INTO useronline VALUES ('$timestamp','$REMOTE_ADDR','$PHP_SELF','$session')") or die("Useronline Database INSERT Error");

$checkclient = mysql_query("SELECT * FROM visits WHERE ip = '". $ip ."' AND host = '". $host ."' ");

if(!$checkclient) {
if($_COOKIE['countProtect'] == "count_al_geregistreerd") {
$insertHostAndIP = mysql_db_query($database, "INSERT INTO visits VALUES ('','$ip','$host')");
$updateVisit = mysql_query("UPDATE visits SET bezoek = bezoek+1");
}
} else {
$updateVisit = mysql_query("UPDATE visits SET bezoek = bezoek+1");
}

$getVisits = "SELECT bezoek FROM visits WHERE ip = ". $ip ."";
$visitResults = mysql_query($getVisits);

mysql_db_query($database, "DELETE FROM useronline WHERE timestamp<$timeout") or die("Useronline Database DELETE Error");

$result=mysql_db_query($database, "SELECT DISTINCT session FROM useronline") or die("Useronline Database SELECT Error");

$user =mysql_num_rows($result);

mysql_close();

if($user==1) {
echo "Er is ". $user . " Bezoeker online<br />";
} else {
echo "Er zijn" . $user . " Bezoekers online<br />";
}


while($nrVisits = mysql_fetch_array($visitResults)) {
if($getVisits['bezoek'] > 1) {
echo "U hebt deze pagina " . $nrVisits['bezoek'] . " keer bezocht...<br />";
}
else {
echo "Welkom, dit is uw eerste bezoek<br />";
}
}
echo "Uw IP adres is: " . $ip . "<br />";
echo "U bent verbonden via host: " . $host . "<br />";
echo "<input type=\"submit\" name=\"delete\" value=\"delete the cookie\" /><br />";

if($delete) {
setcookie('countProtect');
}

?>

De bovenste 2 php scripts zitten op 1 pagina...

Geen reacties?
jammer, dan kan ik niet verder...