|
$server = "localhost";
$user = "tugrul";
$pass = "ebru94";
$db = "veriler";
$ip = getenv("REMOTE_ADDR");
// maak dbase connectie
$connect=@mysql_connect($server,$user,$pass);
if (!$connect) {
die('Onze excuses,
er is tijdelijk geen verbinding met onze database mogelijk.Wij doen onze uiterste best de verbinding zo snel mogelijk te herstellen. Ga naar hoofdpagina ');
}
mysql_select_db($db);
?>
$now = time();
$expire = $now - 120;
$query = "DELETE FROM online WHERE timestamp < $expire AND sayfa='$page'";
mysql_query($query);
$query = "SELECT ip FROM online WHERE ip='$ip' AND sayfa='$page'";
$result = mysql_query($query);
$user =mysql_num_rows($result);
if($user == 0) {
$query = "INSERT online (timestamp,ip,sayfa) VALUES ($now,'$ip','$page')";
mysql_query($query);
}
$query = "SELECT timestamp FROM online WHERE sayfa='$page'";
$result = mysql_query($query);
$user =mysql_num_rows($result);
# select pageviews vandaag als leeg dan insert anders update
#select
$result=mysql_query("SELECT views,tarih FROM stats_pageviews WHERE tarih=curdate() AND sayfa='$page'") or die();
$yeni =mysql_num_rows($result);
#test
if ($yeni>0)
{
#update
$obj=mysql_fetch_object($result);
$views = "$obj->views";
$views=$views+1;
$query3 = "UPDATE stats_pageviews SET views = views + 1 WHERE tarih=curdate() AND sayfa='$page'";
mysql_query($query3) or die(mysql_error());
}
else
#insert
{
$views=1;
$q = mysql_query("INSERT INTO stats_pageviews SET views=1, tarih=CURDATE(), sayfa='$page'") or die("");
}
?>
Daire - Villa - Yazlik - Arsa
Yeni sunulan
Gayrimenkul |
Yer |
Cinsi |
Yüzölç. m2 |
Fiyati Euro |
emlak bağlantısı kurulamadı |