PHPで開発したユーザー行動分析機能を実装した中古リサイクルサイト

// 记录用户访问日志
function logVisit($ip, $uri, $referer, $userAgent) {
    $logFile = 'visit.log';
    $logData = $ip . '|' . date('Y-m-d H:i:s') . '|' . $uri . '|' . $referer . '|' . $userAgent . "
";
    file_put_contents($logFile, $logData, FILE_APPEND);
}

// 记录用户操作日志
function logAction($userId, $action, $data) {
    $logFile = 'action.log';
    $logData = $userId . '|' . date('Y-m-d H:i:s') . '|' . $action . '|' . json_encode($data) . "
";
    file_put_contents($logFile, $logData, FILE_APPEND);
}

// 记录用户交易数据
function logTransaction($userId, $orderId, $amount) {
    $logFile = 'transaction.log';
    $logData = $userId . '|' . date('Y-m-d H:i:s') . '|' . $orderId . '|' . $amount . "
";
    file_put_contents($logFile, $logData, FILE_APPEND);
}

// 示例代码调用
$logIp = $_SERVER['REMOTE_ADDR'];
$logUri = $_SERVER['REQUEST_URI'];
$logReferer = $_SERVER['HTTP_REFERER'];
$logUserAgent = $_SERVER['HTTP_USER_AGENT'];
logVisit($logIp, $logUri, $logReferer, $logUserAgent);

// 连接数据库
$host = 'localhost';
$dbname = 'analytic';
$username = 'root';
$password = '123456';
try {
    $db = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
} catch (PDOException $e) {
    die('数据库连接失败：' . $e->getMessage());
}

// 记录用户访问日志
function logVisit($ip, $uri, $referer, $userAgent) {
    global $db;
    $sql = "INSERT INTO visit_logs (ip, uri, referer, user_agent) VALUES (:ip, :uri, :referer, :user_agent)";
    $stmt = $db->prepare($sql);
    $stmt->bindParam(':ip', $ip);
    $stmt->bindParam(':uri', $uri);
    $stmt->bindParam(':referer', $referer);
    $stmt->bindParam(':user_agent', $userAgent);
    $stmt->execute();
}

// 记录用户操作日志
function logAction($userId, $action, $data) {
    global $db;
    $sql = "INSERT INTO action_logs (user_id, action, data) VALUES (:user_id, :action, :data)";
    $stmt = $db->prepare($sql);
    $stmt->bindParam(':user_id', $userId);
    $stmt->bindParam(':action', $action);
    $stmt->bindParam(':data', $data);
    $stmt->execute();
}

// 记录用户交易数据
function logTransaction($userId, $orderId, $amount) {
    global $db;
    $sql = "INSERT INTO transaction_logs (user_id, order_id, amount) VALUES (:user_id, :order_id, :amount)";
    $stmt = $db->prepare($sql);
    $stmt->bindParam(':user_id', $userId);
    $stmt->bindParam(':order_id', $orderId);
    $stmt->bindParam(':amount', $amount);
    $stmt->execute();
}

// 示例代码调用
$logIp = $_SERVER['REMOTE_ADDR'];
$logUri = $_SERVER['REQUEST_URI'];
$logReferer = $_SERVER['HTTP_REFERER'];
$logUserAgent = $_SERVER['HTTP_USER_AGENT'];
logVisit($logIp, $logUri, $logReferer, $logUserAgent);

// 统计访问次数
function countVisits() {
    global $db;
    $sql = "SELECT COUNT(*) AS visits FROM visit_logs";
    $stmt = $db->prepare($sql);
    $stmt->execute();
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    return $result['visits'];
}

// 示例代码调用
$visits = countVisits();
echo '总访问次数：' . $visits;