网站访问记录系统：高效记录、安全管理和流量分析

connect_error) { die('连接失败: ' . $conn->connect_error); } //获取访客的IP地址 $ip = $_SERVER['REMOTE_ADDR']; //获取访客的浏览器信息 $browser = $_SERVER['HTTP_USER_AGENT']; //获取访问时间 $time = date('Y-m-d H:i:s', time()); //获取访问页面的URL $url = $_SERVER['REQUEST_URI']; //对访问记录进行过滤，防止恶意攻击和注入 $ip = filter_var($ip, FILTER_VALIDATE_IP); $browser = filter_var($browser, FILTER_SANITIZE_STRING); $url = filter_var($url, FILTER_SANITIZE_URL); //对访问记录进行加密处理，确保访客信息安全 $ip = hash('sha256', $ip); $browser = hash('sha256', $browser); $url = hash('sha256', $url); //将访客信息插入数据库 $sql = "INSERT INTO access_record (ip, browser, time, url) VALUES ('$ip', '$browser', '$time', '$url')"; if ($conn->query($sql) === TRUE) { echo '访问记录插入成功'; } else { echo '访问记录插入失败: ' . $conn->error; } $conn->close(); ?>