Storing IP into DB
| From: | web man | Date: | Thu, 30 Jan 2003 20:09:09 +0000 |
| Subject: | Storing IP into DB | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25261@lists.php.net to get a copy of this message | ||
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