广告效果跟踪与分析系统PHP

最新推荐文章于 2024-08-15 15:00:52 发布

y131673

最新推荐文章于 2024-08-15 15:00:52 发布

阅读量150

点赞数 2

文章标签： php 开发语言

本文链接：https://blog.csdn.net/y131673/article/details/141220957

版权

<?php
// 配置数据库连接
$host = 'localhost';
$db = 'ad_database';
$user = 'root';
$pass = 'password';
$dsn = "mysql:host=$host;dbname=$db;charset=utf8";

// 创建 PDO 实例
try {
$pdo = new PDO($dsn, $user, $pass);
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo '连接失败: ' . $e->getMessage();
exit;
}

// 插入广告点击数据
if (isset($_GET['ad_id'])) {
$adId = (int)$_GET['ad_id'];
$timestamp = date('Y-m-d H:i:s');

$insertStmt = $pdo->prepare('INSERT INTO ad_clicks (ad_id, clicked_at) VALUES (:ad_id, :clicked_at)');
$insertStmt->execute(['ad_id' => $adId, 'clicked_at' => $timestamp]);

// 跳转到广告目标网址
$adStmt = $pdo->prepare('SELECT * FROM ads WHERE id = :ad_id');
$adStmt->execute(['ad_id' => $adId]);
$ad = $adStmt->fetch(PDO::FETCH_ASSOC);

if ($ad) {
header('Location: ' . $ad['url']);
exit;
} else {
echo '广告未找到';
}
}

// 获取广告效果数据
$statsStmt = $pdo->query('SELECT ads.id, ads.title, COUNT(ad_clicks.id) AS click_count FROM ads LEFT JOIN ad_clicks ON ads.id = ad_clicks.ad_id GROUP BY ads.id');
$stats = $statsStmt->fetchAll(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>广告效果跟踪与分析系统</title>
<style>
#stats-container {
width: 80%;
margin: auto;
text-align: center;
}
.ad-stat {
margin: 20px 0;
}
</style>
</head>
<body>
<h1>广告效果跟踪与分析</h1>
<div id="stats-container">
<?php foreach ($stats as $stat): ?>
<div class="ad-stat">
<h2><?php echo htmlspecialchars($stat['title']); ?></h2>
<p>点击次数: <?php echo htmlspecialchars($stat['click_count']); ?></p>
</div>
<?php endforeach; ?>
</div>
</body>
</html>