Login   Register  
PHP Classes
elePHPant
Icontem

Class: MySQL SP

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Alexandar Minkovsky  >  MySQL SP  >  Download .tar.gz .zip  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: MySQL SP
Support forum Support forum
Base name: mysql_sp
Description: Emulation of MySQL stored procedures
Related classes: , , , , , , ,
Version: -
PHP version: -
License: BSD License
All time users: 2327 users
All time rank: 1377
Week users: 1 user
Week rank: 2467
Picture of Alexandar Minkovsky
Author: Alexandar Minkovsky <e-mail contact>
Packages: 3 Browse this author's classes Browse this author's classes
Country: Bulgaria Bulgaria - PHP jobs in Bulgaria
Age: 41
All time rank: 1391 in Bulgaria Bulgaria
Week rank: 453 Down3 in Bulgaria Bulgaria Down
Innovation award
Innovation award
Nominee: 2x


  Detailed description  
This class is meant to provide an emulation of stored procedures for MySQL.

It uses template files stored on the database client side that contain multiple SQL statements with special marks that identify placeholders that are replaced by procedure arguments when they are executed.

The result of the execution of procedure is an array containing either the handles of the result set of the SELECT statements or the number of affected rows of other statements.

 

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Templates Template processing engines and components View top rated classes

  Rate classes User ratings   Applications   Files Files  

  Innovation Award  
PHP Programming Innovation award nominee
April 2004
Number 5
 Despite the MySQL popularity among PHP developers, it always had several limitations when compared to high end commercial databases. One of such limitations is the lack of support for stored procedures that could be used to encapsulate several SQL statements in a single function that just takes a few arguments to execute.

This class provides a MySQL client side solution that implements a stored procedure language using files to store the procedure SQL statments.

Despite the support for MySQL server side based stored procedurex is planned for one of the upcoming releases of MySQL, the solution provided by this class provides right now part of the benefits of using stored procedures in MySQL based PHP applications.

Manuel Lemos

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (83.3%)
Good (83.3%)
-
Good (91.7%)
-
-
Not sure (59.2%)
871
Month:
Not yet rated by the users

  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.
  Files folder image Files  
File Role Description
Plain text file createAccount.sql Data sample stored procedure
Plain text file example.php Example Example class usage
Plain text file junk_db_create.sql Data Creates the example database (executed by example.php)
Plain text file mysql_sp.class.php Class The class file

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