 |
|
Innovation award
 Nominee: 1x |
This class can be used to execute stored procedures on a PostgreSQL database by calling the class functions.
It uses PHP 5 __call function to map class function calls to execute stored procedures with the same name on a given PostgreSQL database schema.
The class passes function parameter values to the stored procedure as its parameters. If the values do not match the procedure expected types, the class throws an exception.
It returns a PDO statement object that can be used to retrieve any result sets returned from the execution of the stored procedure.
|
|
| Name: |
pl2method |
| Base name: |
pl2method |
| Description: |
Execute PgSQL stored procedures as class functions |
| Version: |
0.0.2 |
| PHP version: |
5.1 |
| License: |
BSD License |
| All time users: |
263 users |
| All time rank: |
6304 |
| Week users: |
0 users |
| Week rank: |
2159  |
| |
|
 November 2008
Number 3
Prize: One book of choice by O'Reilly |
Stored procedures are often used to execute complex database queries from inside the database server to make them run as fast as possible.
It is necessary to execute a query with special syntax to call a stored procedure passing eventual arguments.
This class provides a general solution to call PostgreSQL stored procedures as if they are actual PHP class functions.
This is an elegant solution that avoids the requirement to learn the syntax and pass the values to the procedure arguments.
Manuel Lemos |
| There are not enough user ratings to display for this class. |
| |
Applications that use this class |
|
|
No application links were specified for this class.

If you know an application of this package, send a message to the
author to add a link here.
| |
Files |
|
|