只為自己記錄學(xué)習(xí),分享給新手,老手略過~~(有更快捷的方法還請指教)
統(tǒng)計調(diào)用復(fù)選框數(shù)據(jù)


模板中調(diào)用代碼:
<li class="nav-item"><a class="nav-link {if !$params.suoshuzu} active{/if}" href="{dr_search_url($params, 'suoshuzu', NULL, 'news')}"><i class="ion ion-ios-email-outline"></i> 不限
<span class="label label-info pull-right"><?php $query=urlencode("SELECT * FROM dr_1_news");?>{count action=sql sql='$query'}</span></a></li>
{php $field = dr_field_options(134);}
{loop $field $value $name}
<li class="nav-item"><a class="nav-link {if $value==$params.suoshuzu} active{/if}" href="{dr_search_url($params, 'suoshuzu', $value, 'news')}"><i class="ion ion-ios-email-outline"></i> {$name}
<span class="label label-info pull-right"><?php $query=urlencode("SELECT * FROM dr_1_news WHERE suoshuzu LIKE '%$value%'");?>{count action=sql sql='$query'}</span></a></li>
{/loop}統(tǒng)計代碼:
<?php $query=urlencode("SELECT * FROM dr_1_news");?>{count action=sql sql='$query'}<?php $query=urlencode("SELECT * FROM dr_1_news WHERE suoshuzu LIKE '%$value%'");?>{count action=sql sql='$query'}