destoon 的(de)首頁上(shàng)有(yǒu)這(z↕₩≠hè)樣的(de)一(yī)段代碼
<li>産品總數(shù):<span&g∞≠t;{php echo $db->c§§"Ωount($DT_PRE.'sell_5', 'sta§§ tus=3', 1800);}</span>$®δ ;</li>
<li>求購(gòu)總數(sh§€βù):<span>{php echo $db₩≠->count($DT_PRE.'b™≤"uy_6', 'status=3', 1800);}</span&g☆"t;</li>
<li>企業(yè)總數(shù):<spa₹÷n>{php echo $db->count($DT_ ∏PRE.'company', '1', 1800);}β </span></li>
<li>在線會(huì)員(yu€δ™βán):<span>{php echo $db-&g₹©t;count($DT_PRE.'online"✘✘±', '1', 1800);}</s•™≥≤pan></li>
這(zhè)個(gè)幾參數(shù)的(de)原型在include/db¥_mysql.class.php中
第一(yī)個(gè)參數(shù)是(sh¥γì)表名,第二個(gè)參數(shù)是(shì)條件(jiàn) ,第≤γ三個(gè)參數(shù)不(bù)太清楚具 ₽ 體(tǐ)的(de)作(zuò)用(yòng),從(cóng)參數(shù)φ名ttl上(shàng)看(kàn)是(α♠ shì)應該生(shēng)存期限,具體(tǐ)的(de)實現(xiàn),€∑在文(wén)件(jiàn)中的(de)原型
如(rú)果我們要(yào)統計(jì)當天的(de)總數(s©₹₹Ωhù)的(de)話(huà),就(jiù)可(kě☆×)以這(zhè)樣來(lái)實現(xi£§àn) {php echo→δ $db->count($DT_PRE.'sell_5', 'st∑↓atus=3 and TO_DAYS(now())=TO_DA€☆YS(adddate)', 1);}條
- function get_one($sql, $type = '', $ttl = 0) ♣✔•;{
- $sql = str_replace(array('select ', ' limit '), array('SELECT ', ' LIMIT '), $sql);
- if(strpos($sql, 'SELECT ') !== false &&₽£α÷; strpos($sql, ' LIMIT ') === false) $sql .= ' LIMIT 0,™ 1';
- $query = $this->query($sql, $type, $ttl);
- $r = $this->fetch_array($query);
- $this->free_result($query);
- ≥₹return $r;
- }
-
- function count($table, $condition = '', $ttl = 0) {
- global $DT_TIME;
- $sql = 'SELECT COUNT(*) >×as amount FROM&n₽αbsp;'.$table;
- if($condition) $sql .= ' WHERE '.$condition;
- β≥$r = $this->get_one($sql, $ttl ? 'CACHE' : '', $ttl);
- return $r ? $r['amount'] : 0; ♠π™
- }
