Elke bezoeker een title
Code (php)
1
2
3
4
5
6
7
2
3
4
5
6
7
<?
CREATE TABLE `bezoekers` (
id int(11) not null auto_increment primary key,
ipadres varchar(20) not null,
datum varchar(16) not null
);
?>
CREATE TABLE `bezoekers` (
id int(11) not null auto_increment primary key,
ipadres varchar(20) not null,
datum varchar(16) not null
);
?>
Scriptje includen op elke pagina:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?
$sql = "SELECT id FROM bezoekers WHERE ipadres = '" . $_SERVER['REMOTE_ADDR'] . "' AND datum = '" . date("d.m.Y") . "'";
$res = mysql_query($sql);
if (mysql_num_rows($res) < 1)
{
$sql = "INSERT INTO bezoekers SET id = '', ipadres = '" . $_SERVER['REMOTE_ADDR'] . "', datum = '" . date("d.m.Y") . "'";
$res = mysql_query($sql);
}
$sql = "SELECT id FROM bezoekers WHERE datum = '" . date("d.m.Y") . "'";
$res = mysql_query($sql);
$visits = mysql_result($res);
echo "Beste bezoeker, je bent vandaag de <b> " . $visits . "</b> bezoeker..";
?>
$sql = "SELECT id FROM bezoekers WHERE ipadres = '" . $_SERVER['REMOTE_ADDR'] . "' AND datum = '" . date("d.m.Y") . "'";
$res = mysql_query($sql);
if (mysql_num_rows($res) < 1)
{
$sql = "INSERT INTO bezoekers SET id = '', ipadres = '" . $_SERVER['REMOTE_ADDR'] . "', datum = '" . date("d.m.Y") . "'";
$res = mysql_query($sql);
}
$sql = "SELECT id FROM bezoekers WHERE datum = '" . date("d.m.Y") . "'";
$res = mysql_query($sql);
$visits = mysql_result($res);
echo "Beste bezoeker, je bent vandaag de <b> " . $visits . "</b> bezoeker..";
?>
Uit de losse hand getypt ff snel, bugjes moet je er zelf uithalen..