PHP Classes

MySQL SP: Emulation of MySQL stored procedures

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 53%Total: 2,477 All time: 1,563 This week: 488Up
Version License Categories
mysql_sp 1.0BSD LicenseDatabases, Templates
Description 

Author

Alexandar Minkovsky

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.

Innovation Award
PHP Programming Innovation award nominee
April 2004
Number 5

Prize: One downloadable copy of Komodo		 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
Picture of Alexandar Minkovsky
Name: Alexandar Minkovsky <contact>
Classes: 3 packages by
Country: Bulgaria Bulgaria
Age: 53
All time rank: 1661 in Bulgaria Bulgaria
Week rank: 181 Down1 in Bulgaria Bulgaria Equal
Innovation award
Innovation award
Nominee: 2x

  Files folder image Files (4)  
File Role Description
Accessible without login Plain text file createAccount.sql Data sample stored procedure
Accessible without login Plain text file example.php Example Example class usage
Accessible without login 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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadmysql_sp-2005-08-12.zip 4KB
Downloadmysql_sp-2005-08-12.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:2,477
This week:0
All time:1,563
This week:488Up
 User Ratings  
 
 All time
Utility:75%StarStarStarStar
Consistency:75%StarStarStarStar
Documentation:-
Examples:81%StarStarStarStarStar
Tests:-
Videos:-
Overall:53%StarStarStar
Rank:2258
  

  Applications that use this package  
No pages of applications that use this class were specified.

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