$clientip = addslashes( @$_SERVER["REMOTE_ADDR"] );
$datetime = date('Y-m-d H:m:s');
$conn = mysql_connect('127.0.0.1' , 'root' , 'root' );
mysql_select_db('account' , $conn);
$query = mysql_query("select * from userip where userip='{$clientip}'" , $conn);
$row = mysql_fetch_row($query);
if(empty($row)){
mysql_query("insert into userip(userip,usertime) values('{$clientip}','{$datetime}')");
}else{
echo 'IP已存在';
}
下面是数据表代码
CREATE TABLE `userip` (
`userip` varchar(32) default NULL,
`usertime` datetime default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;