redis 将用户浏览信息入库

来源：互联网发布：上海踩踏事件知乎编辑：程序博客网时间：2024/05/24 04:26

/**
* 将用户浏览信息入库
*/
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);
       }
   }
}

0 0