/**
* 将用户浏览信息入库
*/
require_once 'common.php';
$mysqliTj = new mysqli($mysqlTjServer['host'],$mysqlTjServer['user'],$mysqlTjServer['pwd'],$mysqlTjServer['db']);
$redis = new Redis();
$redis->pconnect($redisServer['host'], $redisServer['port']);
$redis->select($redisServer['db']);
while(true){
$record = $redis->brPop(array('Record'), 1);
if($record != false){
//记录信息入库
$data = (array)json_decode($record[1]);
$ip = $data['ip'];
$recordTable = getTableName('record');
$recordTable = $recordTable['month'];
//不检查重复,因为设置了unique
$sql2 = "INSERT INTO `{$recordTable}` (`aid`, `time`, `refer`, `ip`, `browser`) VALUES ({$data['aid']}, {$data['time']}, '{$data['refer']}', {$data['ip']}, '{$data['browser']}')";
$res2 = $mysqliTj->query($sql2);
//检查数据表不存在则创建一个数据表
if($mysqliTj->affected_rows == -1 && $mysqliTj->query("show tables like '{$recordTable}'") != false && $mysqliTj->affected_rows == 0){
$sql = "CREATE TABLE `{$recordTable}` ("
. "`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id', "
. "`aid` int(11) NOT NULL COMMENT '文章id', "
. "`time` int(11) NOT NULL COMMENT '用户浏览时间', "
. "`refer` varchar(255) NOT NULL COMMENT '来源页面', "
. "`ip` int(11) NOT NULL COMMENT 'ip2long', "
. "`browser` varchar(255) NOT NULL COMMENT '浏览器', "
. "PRIMARY KEY (`id`), KEY `aid` (`aid`)) "
. "ENGINE=MyISAM AUTO_INCREMENT=39 "
. "DEFAULT CHARSET=utf8 COMMENT='文章点击纪录,{$recordTable}季度'";
$rst = $mysqliTj->query($sql);
$sql = "INSERT INTO `{$recordTable}` (`aid`, `time`, `refer`, `ip`, `browser`) VALUES ({$data['aid']}, {$data['time']}, '{$data['refer']}', {$data['ip']}, '{$data['browser']}')";
$rst2 = $mysqliTj->query($sql);
}
}
}
* 将用户浏览信息入库
*/
require_once 'common.php';
$mysqliTj = new mysqli($mysqlTjServer['host'],$mysqlTjServer['user'],$mysqlTjServer['pwd'],$mysqlTjServer['db']);
$redis = new Redis();
$redis->pconnect($redisServer['host'], $redisServer['port']);
$redis->select($redisServer['db']);
while(true){
$record = $redis->brPop(array('Record'), 1);
if($record != false){
//记录信息入库
$data = (array)json_decode($record[1]);
$ip = $data['ip'];
$recordTable = getTableName('record');
$recordTable = $recordTable['month'];
//不检查重复,因为设置了unique
$sql2 = "INSERT INTO `{$recordTable}` (`aid`, `time`, `refer`, `ip`, `browser`) VALUES ({$data['aid']}, {$data['time']}, '{$data['refer']}', {$data['ip']}, '{$data['browser']}')";
$res2 = $mysqliTj->query($sql2);
//检查数据表不存在则创建一个数据表
if($mysqliTj->affected_rows == -1 && $mysqliTj->query("show tables like '{$recordTable}'") != false && $mysqliTj->affected_rows == 0){
$sql = "CREATE TABLE `{$recordTable}` ("
. "`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id', "
. "`aid` int(11) NOT NULL COMMENT '文章id', "
. "`time` int(11) NOT NULL COMMENT '用户浏览时间', "
. "`refer` varchar(255) NOT NULL COMMENT '来源页面', "
. "`ip` int(11) NOT NULL COMMENT 'ip2long', "
. "`browser` varchar(255) NOT NULL COMMENT '浏览器', "
. "PRIMARY KEY (`id`), KEY `aid` (`aid`)) "
. "ENGINE=MyISAM AUTO_INCREMENT=39 "
. "DEFAULT CHARSET=utf8 COMMENT='文章点击纪录,{$recordTable}季度'";
$rst = $mysqliTj->query($sql);
$sql = "INSERT INTO `{$recordTable}` (`aid`, `time`, `refer`, `ip`, `browser`) VALUES ({$data['aid']}, {$data['time']}, '{$data['refer']}', {$data['ip']}, '{$data['browser']}')";
$rst2 = $mysqliTj->query($sql);
}
}
}