Issues

ZF-348: Zend_DB: Stored Procedure Example

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

Attachments:

Description

In the Zend_Db section of the manual, there should be an example of making a stored procedure call using PDO.

Comments

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");
?>

http://www.php.net/pdostatement-bindparam

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.

Copyright

© 2006-2016 by Zend, a Rogue Wave Company. Made with by awesome contributors.

This website is built using zend-expressive and it runs on PHP 7.

Contacts