广告展示优先级管理系统

y131673

于 2024-08-12 11:55:21 发布

阅读量169

点赞数 2

文章标签： android

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

版权

<?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;
}

// 获取广告数据，根据优先级排序
$sql = 'SELECT * FROM ads WHERE status = 1 ORDER BY priority DESC, created_at DESC';
$stmt = $pdo->query($sql);
$ads = $stmt->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>
#ad-container {
width: 80%;
margin: auto;
text-align: center;
}
.ad-item {
margin: 20px 0;
}
.ad-item img {
max-width: 100%;
height: auto;
}
</style>
</head>
<body>
<h1>广告展示优先级</h1>
<div id="ad-container">
<?php foreach ($ads as $ad): ?>
<div class="ad-item">
<a href="<?php echo htmlspecialchars($ad['url']); ?>" target="_blank">
<img src="<?php echo htmlspecialchars($ad['image']); ?>" alt="<?php echo htmlspecialchars($ad['title']); ?>">
</a>
<p>优先级: <?php echo htmlspecialchars($ad['priority']); ?></p>
</div>
<?php endforeach; ?>
</div>
</body>
</html>