标签: 置顶

Typecho 完美实现文章置顶的思路
目前我在Typecho圈里看见的文章置顶实现都是使用两个 Select，第一个Select是查询置顶的文章，第二个Select是查询剩余的文章。这样实现有BUG，而且也不优雅。置顶x篇文章首页文章数就变成 pageSize + x 了。我的方法就是添加一个用于排序的字段。法1最简单就是新增一个排序字段了。这是MySQL的，SQLITE怎么写忘记了。ALTER TABLE `prefix_co...
Typecho教程2020-05-29323℃30
友情链接
  1. Typecho Fans
最近评论
  1. https://fobamz.evlla.com/ : I have learn a few just right stuff here. Certainly value bookmarking for revisiting.
    I surprise how much effort you put to create this sort of excellent informative site.
    福 步 外贸 论坛 开发 信
  2. 123.hp.com/dj3630 : I think everything published was actually very reasonable.But, what about this? what if you added a little information? I am not suggesting your information is not
    solid., but suppose you added a title that grabbed folk's attention? I mean Typecho 超级标签云，每个标签附带一篇该标签的文章 -
    虾米皮皮乐 is a little plain. You could look at Yahoo's home page and see how
    they create news titles to grab people to click.
    You might add a video or a pic or two to grab readers excited about what you've written. In my opinion,
    it would make your posts a little bit more interesting.
  3. Jesseabert : Game LIFE 遊戲情報 https://gamelife.tw/portal.php
  4. wu先生 : 段首空2格如何编辑？小乖
  5. AKERS : 全部设置对了。显示这个{"status":500,"msg":"SMTP connect() 失败。https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting"}
Top