Re: [PHP] timestamp

This is what I'm using so far. But I need to put in a time stamp to calculate if the visitor is new. I want to use the IP so if the ip saved in MySQL is older than 60 minutes, it will write a new record, if not, don't:

$myconnection = mysql_connect($server,$user,$pass);
mysql_select_db($db,$myconnection);

$getaddr = $_SERVER['REMOTE_ADDR'];
$gethost = gethostbyaddr($_SERVER['REMOTE_ADDR']);
$EntryDate = date("Y-m-d");

$sql = "INSERT INTO $table (IPAddress,RemoteHost,EntryDate) values('$getaddr','$gethost','$EntryDate')";
mysql_query($sql);

$myconnection = mysql_connect($server,$user,$pass);
mysql_select_db($db,$myconnection);
$result = mysql_query("SELECT * FROM $table", $myconnection);
$num_rows = mysql_num_rows($result);

echo "document.write(\"$num_rows visitors. \");";

Anyone? Please :)

John Taylor-Johnston wrote:

> This is what I'm using so far. But I need to put in a time stamp to calculate if the visitor is new. I want to use the IP so if the ip saved in MySQL is older than 60 minutes, it will write a new record, if not, don't:
>
> $myconnection = mysql_connect($server,$user,$pass);
> mysql_select_db($db,$myconnection);
>
> $getaddr = $_SERVER['REMOTE_ADDR'];
> $gethost = gethostbyaddr($_SERVER['REMOTE_ADDR']);
> $EntryDate = date("Y-m-d");
>
> $sql = "INSERT INTO $table (IPAddress,RemoteHost,EntryDate) values('$getaddr','$gethost','$EntryDate')";
> mysql_query($sql);
>
> $myconnection = mysql_connect($server,$user,$pass);
> mysql_select_db($db,$myconnection);
> $result = mysql_query("SELECT * FROM $table", $myconnection);
> $num_rows = mysql_num_rows($result);
>
> echo "document.write(\"$num_rows visitors. \");";

--
John Taylor-Johnston
-----------------------------------------------------------------------------
"If it's not open-source, it's Murphy's Law."

' ' ' Collège de Sherbrooke:
ô¿ô http://www.collegesherbrooke.qc.ca/languesmodernes/
- Université de Sherbrooke:
http://compcanlit.ca/
819-569-2064