Login   Register  
PHP Classes
elePHPant
Icontem

pl2method

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author  
Picture of Ivo Augusto Nascimento
Name: Ivo Augusto Nascimento <e-mail contact>
Packages: 1 Browse all classes by Ivo Augusto Nascimento Browse all classes by
Country: Brazil Brazil - PHP jobs in Brazil
Age: 33
All time rank: 3251253 in Brazil Brazil
Week rank: 2041 Up157 in Brazil Brazil Up
Innovation award
Innovation award
Nominee: 1x


  Detailed description   Download .zip .tar.gz  
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.

  Classes of Ivo Augusto Nascimento  >  pl2method  >  Download .zip .tar.gz  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
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 Equal
 
  Groups   Rate classes User ratings   Applications   Related links   Files Files  

  Groups  
Group folder image PHP 5 Classes using PHP 5 specific features View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Language Constructs to assist in the language control View top rated classes


  Innovation Award  
PHP Programming Innovation award nominee
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

  User ratings  
There are not enough user ratings to display for this class.

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.

  Related links  
Link Description
Ianntech Projects Area Link to pl2method newer versions

  Files folder image Files  
File Role Description
Plain text file ipgpl.class.php Class ipgpl.class.php
Plain text file ipgtype.class.php Class ipgtype.class.php
Accessible without login Plain text file teste.php Example teste.php

Download all files: pl2method.tar.gz pl2method.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.