php请求来源,PHP获取请求来源IP

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

//获取客户端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并输出到页面

//获取客户端参数

$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

-- ----------------------------