193 lines
8.1 KiB
PHP
193 lines
8.1 KiB
PHP
|
<!DOCTYPE html>
|
|||
|
|
<html>
|
|||
|
|
<head>
|
|||
|
|
<?php
|
|||
|
|
|
|||
|
|
|
|||
|
|
// 设置博客首页的SEO信息
|
|||
|
|
$title = "博客 - AI工具导航与最新AI新闻 - AI Tool Path";
|
|||
|
|
$description = "访问我们的博客，获取最新的AI工具、技术趋势、行业动态与AI新闻，帮助您快速了解和使用AI技术。";
|
|||
|
|
$keywords = "AI博客, 人工智能新闻, AI工具, AI技术趋势, AI行业动态";
|
|||
|
|
|
|||
|
|
// 引入包含SEO标签的文件
|
|||
|
|
include('container/links.php');
|
|||
|
|
?>
|
|||
|
|
</head>
|
|||
|
|
|
|||
|
|
<body class="body-bg-color">
|
|||
|
|
<!-- Header -->
|
|||
|
|
<?php include 'container/header.php'; ?>
|
|||
|
|
|
|||
|
|
<!-- Page Title Start -->
|
|||
|
|
<section class="page-title">
|
|||
|
|
<div class="container">
|
|||
|
|
<div class="page-title__inner">
|
|||
|
|
<div class="page-title__shape-1" style="background-image: url(images/shapes/page-title-shape-1.png);"></div>
|
|||
|
|
<div class="page-title__title-box">
|
|||
|
|
<p class="page-title__sub-title">博客文章</p>
|
|||
|
|
<h3 class="page-title__title">查看我们的文章，这可能有助于您开始 AI 之旅。</h3>
|
|||
|
|
</div>
|
|||
|
|
<p class="page-title__text">掌握 AI 工具的艺术：释放其强大力量 <br> 利用 AI 工具路径实现自动化创造力</p>
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
</section>
|
|||
|
|
<style>
|
|||
|
|
.active {
|
|||
|
|
background: #426bff;
|
|||
|
|
border-radius: 4px;
|
|||
|
|
}
|
|||
|
|
.active a {
|
|||
|
|
background: #426bff;
|
|||
|
|
color: #fff !important;
|
|||
|
|
}
|
|||
|
|
</style>
|
|||
|
|
<!-- Page Title End -->
|
|||
|
|
|
|||
|
|
<!-- Blog Page Start -->
|
|||
|
|
<section class="blog-page">
|
|||
|
|
<div class="container">
|
|||
|
|
<div class="row">
|
|||
|
|
<?php
|
|||
|
|
// 设置每页显示的博客数量
|
|||
|
|
$blogs_per_page = 9;
|
|||
|
|
|
|||
|
|
// 获取当前页码，默认是1
|
|||
|
|
$current_page = isset($_GET['page']) && is_numeric($_GET['page']) && $_GET['page'] > 0 ? (int)$_GET['page'] : 1;
|
|||
|
|
|
|||
|
|
// 计算 SQL 查询的起始行
|
|||
|
|
$start = ($current_page - 1) * $blogs_per_page;
|
|||
|
|
|
|||
|
|
// 计算总博客数
|
|||
|
|
$total_blogs_query = "SELECT COUNT(*) as total FROM cn_blogs WHERE status = 1";
|
|||
|
|
$total_blogs_result = mysqli_query($conn, $total_blogs_query);
|
|||
|
|
|
|||
|
|
if (!$total_blogs_result) {
|
|||
|
|
header('Location: 404'); // 查询失败，重定向到404页面
|
|||
|
|
exit();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
$total_blogs_row = mysqli_fetch_assoc($total_blogs_result);
|
|||
|
|
$total_blogs = intval($total_blogs_row['total']);
|
|||
|
|
$total_pages = ceil($total_blogs / $blogs_per_page);
|
|||
|
|
|
|||
|
|
// 获取当前页的博客列表
|
|||
|
|
$blogs_query = "SELECT id, title, image, created_at FROM cn_blogs WHERE status = 1 ORDER BY created_at DESC LIMIT ?, ?";
|
|||
|
|
$stmt = $conn->prepare($blogs_query);
|
|||
|
|
$stmt->bind_param('ii', $start, $blogs_per_page);
|
|||
|
|
$stmt->execute();
|
|||
|
|
$result = $stmt->get_result();
|
|||
|
|
|
|||
|
|
if (!$result) {
|
|||
|
|
header('Location: 404'); // 查询失败，重定向到404页面
|
|||
|
|
exit();
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// 显示博客
|
|||
|
|
while ($blog = $result->fetch_assoc()) {
|
|||
|
|
$id = $blog['id'];
|
|||
|
|
$title = htmlspecialchars($blog['title'], ENT_QUOTES, 'UTF-8');
|
|||
|
|
$image_name = htmlspecialchars($blog['image'], ENT_QUOTES, 'UTF-8');
|
|||
|
|
$created_at = new DateTime($blog['created_at']);
|
|||
|
|
$formatted_date = $created_at->format('d M Y');
|
|||
|
|
$read_time = '2 Minute Read';
|
|||
|
|
|
|||
|
|
echo "
|
|||
|
|
<div class='col-xl-4 col-lg-4 col-md-6'>
|
|||
|
|
<div class='blog-page__single'>
|
|||
|
|
<div class='blog-page__img-box'>
|
|||
|
|
<div class='blog-page__img'>
|
|||
|
|
<img src='$image_name' alt=''>
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
<h3 class='blog-page__title'>
|
|||
|
|
<a href='blog-details?blog=$id'>$title</a>
|
|||
|
|
</h3>
|
|||
|
|
</div>
|
|||
|
|
</div>";
|
|||
|
|
}
|
|||
|
|
?>
|
|||
|
|
</div>
|
|||
|
|
|
|||
|
|
<!-- Pagination -->
|
|||
|
|
<div class="career-page__pagination mt-5">
|
|||
|
|
<ul class="pg-pagination list-unstyled">
|
|||
|
|
<?php
|
|||
|
|
// 基础URL设置
|
|||
|
|
$base_url = htmlspecialchars("?page=");
|
|||
|
|
|
|||
|
|
// "Previous"按钮
|
|||
|
|
if ($current_page > 1): ?>
|
|||
|
|
<li class="prev">
|
|||
|
|
<a href="<?php echo $base_url . ($current_page - 1); ?>" aria-label="Previous">
|
|||
|
|
<span class="fas fa-arrow-left"></span>
|
|||
|
|
</a>
|
|||
|
|
</li>
|
|||
|
|
<?php endif; ?>
|
|||
|
|
|
|||
|
|
<?php if ($total_pages <= 6): ?>
|
|||
|
|
<!-- 如果总页数小于等于6，则显示所有页码 -->
|
|||
|
|
<?php for ($page = 1; $page <= $total_pages; $page++): ?>
|
|||
|
|
<li class="count <?php echo $page == $current_page ? 'active' : ''; ?>">
|
|||
|
|
<a href="<?php echo $base_url . $page; ?>"><?php echo $page; ?></a>
|
|||
|
|
</li>
|
|||
|
|
<?php endfor; ?>
|
|||
|
|
<?php else: ?>
|
|||
|
|
<!-- 显示第一页和第二页 -->
|
|||
|
|
<li class="count <?php echo $current_page == 1 ? 'active' : ''; ?>">
|
|||
|
|
<a href="<?php echo $base_url . '1'; ?>">1</a>
|
|||
|
|
</li>
|
|||
|
|
<li class="count <?php echo $current_page == 2 ? 'active' : ''; ?>">
|
|||
|
|
<a href="<?php echo $base_url . '2'; ?>">2</a>
|
|||
|
|
</li>
|
|||
|
|
|
|||
|
|
<!-- 中间省略部分 -->
|
|||
|
|
<?php if ($current_page > 4): ?>
|
|||
|
|
<li class="count"><span>...</span></li>
|
|||
|
|
<?php endif; ?>
|
|||
|
|
|
|||
|
|
<!-- 显示中间的页码 -->
|
|||
|
|
<?php
|
|||
|
|
$start_page = max(3, $current_page - 2);
|
|||
|
|
$end_page = min($total_pages - 2, $current_page + 2);
|
|||
|
|
|
|||
|
|
for ($page = $start_page; $page <= $end_page; $page++): ?>
|
|||
|
|
<li class="count <?php echo $page == $current_page ? 'active' : ''; ?>">
|
|||
|
|
<a href="<?php echo $base_url . $page; ?>"><?php echo $page; ?></a>
|
|||
|
|
</li>
|
|||
|
|
<?php endfor; ?>
|
|||
|
|
|
|||
|
|
<!-- 最后两页 -->
|
|||
|
|
<li class="count <?php echo $current_page == $total_pages - 1 ? 'active' : ''; ?>">
|
|||
|
|
<a href="<?php echo $base_url . ($total_pages - 1); ?>"><?php echo $total_pages - 1; ?></a>
|
|||
|
|
</li>
|
|||
|
|
<li class="count <?php echo $current_page == $total_pages ? 'active' : ''; ?>">
|
|||
|
|
<a href="<?php echo $base_url . $total_pages; ?>"><?php echo $total_pages; ?></a>
|
|||
|
|
</li>
|
|||
|
|
<?php endif; ?>
|
|||
|
|
|
|||
|
|
<!-- "Next"按钮 -->
|
|||
|
|
<?php if ($current_page < $total_pages): ?>
|
|||
|
|
<li class="next">
|
|||
|
|
<a href="<?php echo $base_url . ($current_page + 1); ?>" aria-label="Next">
|
|||
|
|
<span class="fas fa-arrow-right"></span>
|
|||
|
|
</a>
|
|||
|
|
</li>
|
|||
|
|
<?php endif; ?>
|
|||
|
|
</ul>
|
|||
|
|
</div>
|
|||
|
|
</div>
|
|||
|
|
</section>
|
|||
|
|
<!-- Blog Page End -->
|
|||
|
|
|
|||
|
|
<!-- Free Trail Start -->
|
|||
|
|
<?php include 'container/free_trail.php'; ?>
|
|||
|
|
<!-- Free Trail End -->
|
|||
|
|
|
|||
|
|
<!-- Main Footer Start -->
|
|||
|
|
<?php include 'container/footer.php'; ?>
|
|||
|
|
<!-- Main Footer End -->
|
|||
|
|
|
|||
|
|
<?php include 'container/footer_links.php'; ?>
|
|||
|
|
</body>
|
|||
|
|
</html>
|