PHP Smarty新手

Question

如果只是query了我的SQL语句...
我想问一下怎么得到我的结果集记录数?
不可以用mysql_num_rows()和mysql_fetch_row()这些...

Answer 1

预编译处理能用不？function selectLink($oid){
        $sql = "select o.oid,l.lid,c.cid,comName,comPrice,ordTime
                from mis_order o,mis_link l,mis_commodity c
                where o.oid=l.lid and c.cid=l.cid and o.oid=?";
        $stmt = $this->mysqli->prepare($sql);
        $stmt->bind_param("i",$oid);
        $stmt->execute();
        $stmt->store_result();
        $stmt->bind_result($oid,$lid,$cid,$comName,$comPrice,$ordTime);
        $rows = $stmt->affected_rows;
        if($rows > 0){
            $arrLink = array();
            while($stmt->fetch()){
                 $arr = array(
                    "oid" => $oid,
                    "lid" => $lid,
                    "cid" => $cid,
                    "comName" => $comName,
                    "comPrice" => $comPrice,
                    "ordTime" => $ordTime
                );
                array_push($arrLink,$arr);
            }
            return $arrLink;
        }else{
            echo "查询订单明细失败!<br/>";
        }
    }

Answer 2

假如我有个HR的静态类：public function
这里是control
 default_action(){
$list = HR::get_emp_all();//调方法

$args=array('list' => $list);  //的结果

$this->show_page('index',$args);//传到Index页面
}