Typecho 根据文章阅读数降序排序输出“热门文章”列表

3 years ago

source link: https://hellodk.cn/post/826
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

要想实现标题中的功能，sql 语句可以这样写

select views, cid, from_unixtime(created, '%Y-%m-%d %H:%m:%s') as created_time, title, commentsNum from typecho_contents where type='post' and status='publish' order by views desc;

现在通过在 typecho 博客上实现，并在归档页面展示。下面展示我的方法。

`functions.php` 中增加以下函数

* 根据文章阅读数排序的热门发布文章

function mostViewsPosts()

$archive = Typecho_Widget::widget('Widget_Archive');

// $hotNums = 5; //热门文章数

// $minViews = 10; //最低阅读量

$db = Typecho_Db::get();

$select = $db->select()->from('table.contents')

->where('table.contents.type = ?', 'post')

->where('table.contents.status = ?', 'publish');

//->limit($hotNums);

$select->order("table.contents.views", Typecho_Db::SORT_DESC);

$rows = $db->fetchAll($select);

foreach ($rows as $row) {

$mostViewsPosts[] = $archive->filter($row);

return $mostViewsPosts;

`page-archives.php` 中增加如下代码（用于 html 显示）

<hr />

<article class="post">

<?php $HotPosts = mostViewsPosts(); ?>

<?php if (count($HotPosts) > 1) : ?>

<div class="mostViewsPosts">

<ul>

<h1 class="post-title">按照阅读数降序排序的热门文章</h1>

<?php $loopItem = 1; ?>

<?php foreach ($HotPosts as $v) { ?>

<a class="title" title="<?= $v['title']; ?>" href="<?= $v['permalink']; ?>">

<li>

<div><?= $v['title']; ?></div>

</li>

</a>

                        <span class="seqNumber">seq is <?= $loopItem++; ?></span><span class="views"> | <?= $v['views']; ?> 次阅读</span><span class="postTime"> | 发布于 <?= date('Y-m-d H:m:s', $v['created']); ?></span><span class="commentsNum"> | 已有 <?= $v['commentsNum']; ?> 条评论</span>

<br />

<?php } ?>

</ul>

</div>

<?php endif; ?>

</article>

`tyle.min.css` 中增加样式

.mostViewsPosts .title {

color: black;

.mostViewsPosts .seqNumber {

color: #FF9900;

.mostViewsPosts .views {

color: red;

.mostViewsPosts .postTime {

color: green;

.mostViewsPosts .commentsNum {

color: blue;

color: black;

text-decoration: none;

最终界面预览如下归档页面

Recommend

blog.51cto.com 5 years ago
Cache

MySQL 8 新特性之降序索引底层实现-wx5cb6d3d725767的博客

大家可能对索引比较熟悉，而对降序索引比较陌生，事实上降序索引是索引的子集。我们通常使用下面的语句来创建一个索引：create index idx_t1_bcd on t1(b,c,d);上面sql的意思是在t1表中，针对b,c,d三个字段创建一个联合索引。但是大家不知道的是，上面这个sql实际...