Destoon realization of the first page display supply, enterprise, Information Bar number of methods _php example

Destoon implementation of the home page display supply, enterprise, Information Bar number has a variety of methods, here is a direct call to the PHP program code to query. Destoon template inside is to support the code of PHP, so we can directly query the template inside out.

The implementation code is as follows:

<ul>
  {php $sellcount = $db->get_one ("Select COUNT (*) as num from". $DT _pre. " Sell WHERE status=3 ");} 
   <li> Total {$sellcount [num]} supply </li>
 {php $company = $db->get_one ("Select COUNT (*) as num from". $DT _pre ." Member WHERE groupid>5 ");}
   <li> Total {$company [num]} enterprise </li>
 {php $newcount = $db->get_one ("Select COUNT (*) as num from". $DT _pre. " article_21 WHERE status=3 ");}
   <li> Total {$newcount [num]} news </li>
</ul>

How the page displays the current date:

{Date (' y-m-d ', $DT _time)}