Storing IP into DB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
I wondered if anyone could help me.
I would like to store the user IP only once
per multiple visits.
The code below store the user IP on every visit
which is not my intention.
Please I would like to have the IP stored at once upon
repetitive visits of the user.
Thank
Below is my code

<?

$ip_address = getenv ("REMOTE_ADDR"); 
$the_date = date("Y-m-D");
$connect = mysql_connect("localhost", "user", "pass") or die("Cant Connect!");
mysql_select_db("ipvisits")or die("Cant Connect To Database");
mysql_query("INSERT into visitorsips (ip, date) VALUES ('$ip_address', '$the_date')");
mysql_close($connect);

?>




---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux