blocks|key|1258675|text|比尔的回答很好。出于完整性考虑，如果您遇到以下情况：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1258676|SQLSTATE[HY000]:+General+error:+2053|code-block|syntax|javascript|1258677|使用此方法从过程中获取结果集时，请检查参数。我重构了一个方法，并将NULL作为参数传递给过程，因为我使用的变量超出了作用域。一旦我修复了这个愚蠢的错误，问题就消失了(被另一个问题取代)：|1258678|SQLSTATE[HY000]:+General+error:+2014+Cannot+execute+queries+while+other+
unbuffered+queries+are+active.++Consider+using+PDOStatement::fetchAll().|1258679|不过我使用的是$stmt->fetchAll()。我转而使用prepare()和execute()来代替query()。在我的Zend_Db配置中，从pdo_mysql切换到mysqli终于让我的工作正常了。我从下面的SO问题中找到了这个信息：|offset|length|style|CODE|1258680|Call+Multiple+Stored+Procedures+with+the+Zend+Framework|1258681|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/443895/call-multiple-stored-procedures-with-the-zend-framework^0|0|0|0|0|7|H|U|9|14|9|1G|7|23|9|2F|6|0|0|1J|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|14|8|@$M|15|N|16|O|P]|$M|17|N|18|O|P]|$M|19|N|1A|O|P]|$M|1B|N|1C|O|P]|$M|1D|N|1E|O|P]|$M|1F|N|1G|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1H|8|@]|9|@$M|1I|N|1J|1|1K]]|A|$]]|$1|S|3|-4|5|6|7|1L|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

Great answer from Bill. Just for completeness, if you encounter:

<pre><code>SQLSTATE[HY000]: General error: 2053
</code></pre>

When using this method to get a result set from your procedure, check your arguments. I refactored a method and was passing NULLs as arguments to the procedure as the variables I'd used were out of scope. Once I'd fixed this silly mistake the problem went away (to be replaced by another):

<pre><code>SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other 
unbuffered queries are active. Consider using PDOStatement::fetchAll().
</code></pre>

I'm using <code>$stmt-&gt;fetchAll()</code> though. I switched to using <code>prepare()</code> and <code>execute()</code> in place of <code>query()</code>. Switching to <code>mysqli</code> from <code>pdo_mysql</code> in my Zend_Db config finally got things working for me. I found this information from the following SO question:

<a href="https://stackoverflow.com/questions/443895/call-multiple-stored-procedures-with-the-zend-framework">Call Multiple Stored Procedures with the Zend Framework</a>

blocks|key|1473400|text|++++$db+=+Zend_Db_Table::getDefaultAdapter();++++
++++$stmt+=+$db->query("CALL+procedure()");
++++$data+=+$stmt->fetchAll();|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1473401|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code> $db = Zend_Db_Table::getDefaultAdapter(); 
 $stmt = $db-&gt;query("CALL procedure()");
 $data = $stmt-&gt;fetchAll();
</code></pre>

blocks|key|1473425|text|如果有人正在使用Zend\Db查找ZendFramework+2+\+Zend+Expressive：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1473426|使用createStatement()方法还有另一种方法可以做到这一点。|1473427|//+prepare+create+statement+from+adapter
$stmt+=+$this->getAdapter()->createStatement();

$stmt->prepare('CALL+myproc("myVal")');
//+execute+sql+query
$records+=+$stmt->execute();
//+manipulate+results
if+($records+instanceof+ResultInterface+&&+$records->isQueryResult())+{
++++$resultSet+=+new+ResultSet;
++++$resultSet->initialize($records);
++++//+return+records+if+found
++++if+(count($resultSet))+{
+++++++//+return+array+of+result+set
+++++++return+$resultSet->toArray();
++++}
+++//+if+no+records+found
+++return+array()

}|code-block|syntax|javascript|1473428|entityMap^0|8|7|H|F|Z|F|0|2|H|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|N|$]]

If someone is looking for <code>ZendFramework 2</code> \ <code>Zend Expressive</code> using <code>Zend\Db</code> :

There is another way to do this using <code>createStatement()</code> method.

<pre><code>// prepare create statement from adapter
$stmt = $this-&gt;getAdapter()-&gt;createStatement();

$stmt-&gt;prepare('CALL myproc("myVal")');
// execute sql query
$records = $stmt-&gt;execute();
// manipulate results
if ($records instanceof ResultInterface &amp;&amp; $records-&gt;isQueryResult()) {
 $resultSet = new ResultSet;
 $resultSet-&gt;initialize($records);
 // return records if found
 if (count($resultSet)) {
 // return array of result set
 return $resultSet-&gt;toArray();
 }
 // if no records found
 return array()

}
</code></pre>

I'm recently have learned to use Zend Framework. I did a simple CRUD application. But now I want to use a existing database for a more complex application and I want to know how I call a stored procedure in the Model, how to send parameters, how to read the results and store them in an array in PHP. Please. I appreciate any kind of help :)

How can I use a stored procedure in a MySql database with Zend Framework?

数据库

我最近学会了使用Zend框架。我做了一个简单的CRUD应用程序。但现在我想将现有的数据库用于更复杂的应用程序，我想知道如何在Model中调用存储过程，如何发送参数，如何读取结果并将其存储在PHP中的数组中。请。感谢任何形式的帮助:)

问如何在Zend Framework中使用MySql数据库中的存储过程？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Zend Framework中使用MySql数据库中的存储过程？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在Zend Framework中使用MySql数据库中的存储过程？
EN