语句无法执行(HY000-2014-当其他未缓冲的查询处于活动状态时无法执行查询。请考虑使用PDOStatement::fetchAll()。或者,如果你的代码只针对mysql运行,你可以通过设置PDO::mysql_ATTR_USE_BUFFERED来启用查询缓冲。我在zf2中运行操作时遇到了这个错误,如何解决这个问题
{$assSub=$this->getTblInstitutesDepartmentsTable()->getAssignedDetails($urlassId);
$request=$this->getRequest();
if($request->isPost()){
$submittedArray = $request->getPost()->toArray();
$remarks = $submittedArray['remark'];
$grades = $submittedArray['grade'];
$submittedChk =$submittedArray['submitted'];
foreach ($submittedChk as $submitted){
$chksubmitted = 1;
$remark = $remarks[$submitted];
$grade = $grades[$submitted];
$submittedObj = new TblInstitutesDepartmentModel(array('asid' => $sub,'gd_id' => $grd,'rem' => $rem,'is_sub' => $chksub,'sub_date'=>date('Y-m-d')));
$this->getTblInstitutesDepartmentsTable()->updateAssigned($submittedObj); }
}
$view = new ViewModel(array(
'assStd' => $assSub,
'flashMessages' => $this->flashMessenger()->getMessages()
)
);
我只需要调用$this->getTblInstitutesDepartmentsTable()->getAssignedDetails($urlassId)this来查看模型
//$assSub=$this->getTblInstitutesDepartmentsTable()->getAssignedDetails($urlassId)
$request=$this->getRequest()
if($request->isPost()){
$submittedArray = $request->getPost()->toArray();
$remarks = $submittedArray['remark'];
$grades = $submittedArray['grade'];
$submittedChk =$submittedArray['submitted'];
foreach ($submittedChk as $submitted){
$chksubmitted = 1;
$remark = $remarks[$submitted];
$grade = $grades[$submitted];
$submittedObj = new TblInstitutesDepartmentModel(array('asid' => $sub,'gd_id' => $grd,'rem' => $rem,'is_sub' => $chksub,'sub_date'=>date('Y-m-d')));
$this->getTblInstitutesDepartmentsTable()->updateAssigned($submittedObj); }
}
$view = new ViewModel(array(
//'assStd' => **$assSub**,
'assStd' => $this->getTblInstitutesDepartmentsTable()->getAssignedDetails($urlassId),
'flashMessages' => $this->flashMessenger()->getMessages()
)
);