phpcms v9 内容收藏数

最新推荐文章于 2021-03-21 15:50:53 发布

小羽童鞋

最新推荐文章于 2021-03-21 15:50:53 发布

阅读量1.7k

点赞数

分类专栏： phpcms

本文链接：https://blog.csdn.net/xiaoyutongxie/article/details/8951470

版权

phpcms 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

{pc:get sql="select count(*) as count from yxx_favorite where title='$title'" return="data" num="9"}
	{loop $data $key $val}
		{$val[count]}
	{/loop}
{/pc}

内容页显示当前内容收藏数，查询条件 $title相同.

其他案例：

{pc:get sql="select *,count(*) as count from yxx_favorite where adddate>=DATE_SUB(CURDATE(),INTERVAL WEEKDAY(CURDATE()) DAY) group by title order by count(*) desc" return="data" num="9"}
	<ul>
		{loop $data $key $val}
			<li><a href="{str_replace('/index.html','',$val[url])}" target="_blank" title="{$val[title]}">{$val[title]}</a> {$val[count]}</li>
		{/loop}
	</ul>
{/pc}