Issue Type: Docs: Improvement Created: 2006-08-31T16:44:06.000+0000 Last Updated: 2010-09-16T19:23:13.000+0000 Status: Resolved Fix version(s): Reporter: Lawrence Leach (leachypeachy) Assignee: Jordan Ryan Moore (jordanryanmoore) Tags: - Zend_Db
Related issues: - ZF-2097
In the Zend_Db section of the manual, there should be an example of making a stored procedure call using PDO.
Posted by Gavin (gavin) on 2006-08-31T20:12:56.000+0000
There are no examples in the manual either showing how to do the following example using a Zend_Db instance using the PDO_MYSQL adapter.
Example 3. Call a stored procedure with an INOUT parameter
<pre class="highlight"><?php /* Call a stored procedure with an INOUT parameter */ $colour = 'red'; $sth = $dbh->prepare('CALL puree_fruit(?)'); $sth->bindParam(1, $colour, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 12); $sth->execute(); print("After pureeing fruit, the colour is: $colour"); ?>
Posted by Bill Karwin (bkarwin) on 2006-11-13T15:22:38.000+0000
Changing fix version to 0.8.0.
Posted by Bill Karwin (bkarwin) on 2007-01-05T17:16:05.000+0000
Recategorize as Documentation, Zend_Db.
Posted by Wil Sinclair (wil) on 2008-01-15T16:38:04.000+0000
Updating to follow standard for documentation issues.
Posted by Wil Sinclair (wil) on 2008-03-21T17:05:26.000+0000
This issue should have been fixed for the 1.5 release.
Posted by Wil Sinclair (wil) on 2008-03-25T20:43:59.000+0000
Please categorize/fix as needed.
Posted by Wil Sinclair (wil) on 2008-04-18T13:11:58.000+0000
This doesn't appear to have been fixed in 1.5.0. Please update if this is not correct.
Posted by Wil Sinclair (wil) on 2008-12-04T12:53:16.000+0000
Reassigning as Ralph is the maintainer of Zend_Db
Posted by Ralph Schindler (ralph) on 2009-01-09T10:31:12.000+0000
Reviewed and on the radar.
Posted by Jordan Ryan Moore (jordanryanmoore) on 2009-10-30T08:37:48.000+0000
This example should be something found on the php.net manual and doesn't actually have anything specifically to do with Zend Framework.
Posted by Simon (_sims_) on 2010-09-16T19:23:09.000+0000
"This example should be something found on the php.net manual and doesn't actually have anything specifically to do with Zend Framework."
While it is nice if there are docs on the php.net manual, doesn't the Zend_Db have quite a different syntax to plain PHP? AFAIK, there are no "prepare", "bindParam", or "execute" functions on php.net. I think this is ZF specific? If so, please document it.
There are examples of using Zend_Db in the ZF manual. While portions of the ZF manual are not ZF specific, they are none the less included to give the user a clearer picture of how things fit together. If you left all the SQL fragments out of the ZF manual, see how clear that would be.
Have you found an issue?
See the Overview section for more details.