假设我在server_a中有一个网站_a,并且想存储诸如客户端IP(单击white nebsite_a(和浏览器名称(客户端浏览器(和日期和时间(client_a时(之类的信息(当客户端打开网站_a(server_b数据库。**我的问题再次是.."我们如何存储信息在另一台服务器中?"
请建议
要获取客户端IP,您可以使用:
$ip = $_SERVER[‘REMOTE_ADDR’];
要获取Brower用户代理,您可以使用
$agent = $_SERVER['HTTP_USER_AGENT'];
要获得日期时间,您可以使用:
$datetime = date("Y-m-d h:i:sa", $d);
完整代码:
<?php
$ip = $_SERVER[‘REMOTE_ADDR’];
$agent = $_SERVER['HTTP_USER_AGENT'];
$datetime = date("Y-m-d h:i:sa", $d);
$dbh = new mysqli("remote-server-ip", "my_user", "my_password", "database-name");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %sn", mysqli_connect_error());
exit();
}
$stmt = $dbh->prepare("INSERT INTO TABLENAME (date, ip, useragent) VALUES (?, ?, ?)");
$stmt->bindParam(1, $datetime);
$stmt->bindParam(2, $ip);
$stmt->bindParam(2, $agent);
$stmt->execute();
$stmt->close();
/* close connection */
$mysqli->close();
?>