我已经从StackOverflow和其他网站上浏览了很多帖子。以下是解决方案,我发现几乎所有的网站,但它不适合我。: -
return new 'Phalcon'Db'Adapter'Pdo'MySql(array(
"host" => 'XXXx',
"username" => 'XXXX',
"password" => 'XXXX',
"dbname" => 'XXXX',
"options" => array('PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true)
));
我调用存储过程的代码:
public function AssignPromoterToPromotionVenuAction($bookingSheetID = 0, $promoter_id = 0, $userID = 0)
{
$query = "CALL `x_wf_AgencyAssignPromoter`($bookingSheetID, $promoter_id, $userID)";
$rp = new Promotion();
return new Resultset(null, $rp, $rp->getReadConnection()->query($query));
}
public function RemovePromoterToPromotionVenuAction($bookingSheetID = 0, $promoter_id = 0, $userID = 0)
{
$query = "CALL `x_wf_AgencyRemovePromoter`($bookingSheetID, $promoter_id, $userID)";
$rp = new Promotion();
return new Resultset(null, $rp, $rp->getReadConnection()->query($query));
}
终于有了答案:
不返回Resultset,您可以获取调用过程的结果:
return $rp->getReadConnection()->query($query)->fetchAll();
Ref Link