时间戳

首页 > 解决方案 > 按年份显示存档博客文章

php - 按年份显示存档博客文章

问题描述

我正在尝试按年份显示博客文章，但是我无法调出博客文章，我需要重新循环吗？

我想要一个存档部分，以下拉方式返回年份下的博客文章-您可以在此处查看示例

<?php

$monthText = "";
$link_archive="";
$i=1;

$query1="SELECT DISTINCT YEAR(`date`) AS `Year` FROM posts WHERE type='news' GROUP BY `Year` ORDER BY `date` DESC";
$sql1 = $dbh->prepare($query1);
$sql1->execute();

while ($row1 = $sql1->fetch( PDO::FETCH_OBJ )) {
    $inner_posts="";

    $dateObj   = DateTime::createFromFormat('!m', $row1->Month);
    $year = $row1->Year;

    $query2="SELECT * FROM posts WHERE type='news' AND YEAR(`date`) = ? ORDER BY `date` DESC";
    $sql2 = $dbh->prepare($query2);
    $sql2->execute([$year]);
while ($row2 = $sql2->fetch( PDO::FETCH_OBJ )) {
    $inner_posts.="<div class='post'>
                <h2><a href='/{$GLOBALS['post_url']}/{$row->url}'>$row->title</a></h2>
                $blog_post_sh
              </div>";
}

if ($inner_posts != '') {
    $inner_posts = "<ul id='list{$i}' class='inner_posts'>{$inner_posts}</ul>";
}



$monthText.="<li>
<a class='open{$i}' href='/{$GLOBALS['posts_url']}$link_archive'>
{$year}
</a>
{$inner_posts}
</li>";
$i++;

}


?>

<ul>
    <?php echo $monthText; ?>
</ul>

标签： phpmysql

解决方案

推荐阅读