PHP获取请求来源IP

一、php获取请求来源IP并写入数据库

<?php

//获取客户端IP地址
$ip=$_SERVER["REMOTE_ADDR"];

//获取客户端参数
$user=$_GET["user"];

//获取本机时间
$time = date('Y-m-d H:i:s');

//连接数据库
$coon=mysql_connect("localhost","root","") or die (mysql_error());
mysql_select_db("ip",$coon);

//操作数据库
$sql="INSERT INTO user(user,ip,time) VALUES('$user','$ip','$time') ON DUPLICATE KEY UPDATE ip='$ip',time='$time'";
mysql_query($sql);

//关闭数据库
mysql_close();

//输出信息
echo "ip:$ip user:$user time:$time";
?>

二、php读取数据库内保存的IP并输出到页面

<?php

//获取客户端参数
$user=$_GET["user"];

//连接数据库
$coon=mysql_connect("localhost","root","") or die (mysql_error());
mysql_select_db("ip",$coon);

//操作数据库
$sql="SELECT ip,user,time from user WHERE user='$user'";
$result = mysql_query($sql);

while($row = mysql_fetch_array($result))
{
    $ip = $row["ip"];
    $user = $row["user"];
    $time = $row["time"];
    echo "ip:$ip user:$user time:$time";
}

//关闭数据库
mysql_close();
?>

三、数据库建表

/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50617
Source Host : localhost:3306
Source Database : ip

Target Server Type : MYSQL
Target Server Version : 50617
File Encoding : 65001

Date: 2015-09-07 17:05:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user` varchar(255) DEFAULT NULL,
`ip` varchar(255) DEFAULT NULL,
`time` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------