Zend_Db_Statement 直接下 SQL

過去用Zend_Db_Table物件寫SQL時，常常遇到不知該如何把一整行SQL指令拆成Zend_Db_Table的方式。現在有了Zend_Db_Statement之後，不管SQL指令再怎麼長，再怎麼join來join去都不是問題了...


$sql = 'select count(a.id) from tableA as a inner join tableB as b on a.Bid = b.id where b.member_sn = ? and a.status = ?';
$stmt = new Zend_Db_Statement_Mysqli($dbAdapter, $sql);
$stmt->execute(array($var1, $var2));
$row = $stmt->fetch();   //單筆資料用fetch(), 多筆用fetchAll()