Login   Register  
PHP Classes
elePHPant
Icontem

Class: MySQL stored procedures

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Cosmin Cristea  >  MySQL stored procedures  >  Download .tar.gz .zip  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: MySQL stored procedures
Base name: st_proc
Description: Emulation of stored procedures for MySQL databases
Related classes: , , , , , , ,
Version: -
PHP version: -
License: Freeware
All time users: 3559 users
All time rank: 745
Week users: 1 user
Week rank: 2434
Picture of Cosmin Cristea
Author: Cosmin Cristea <e-mail contact>
Packages: 3 Browse this author's classes Browse this author's classes
Country: Romania Romania - PHP jobs in Romania
Age: 32
All time rank: 3498 in Romania Romania
Week rank: 1620 Down43 in Romania Romania Down


  Detailed description  
This class emulates stored procedures for MySQL databases used (MySQL) client side files to define the SQL code of the procedures.

It executes simple queries defined within a named block, known as "stored procedure".

The query syntax within a stored procedure is compliant with standard SELECT, INSERT, DELETE and UPDATE MySQL queries, but it does not accept sub-select queries like "INSERT ... SELECT".

Every stored procedure can have parameters that must be initialized before the execution.

Here is the of provided functionality:

- Loading and saving stored procedures on disk files.
- Procedure execution
- Dumping in HTML format the code of loaded procedures
- All the methods not implemented have a proprietary license

 

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes

  Rate classes User ratings   Applications   Files Files  

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (83.3%)
Good (83.3%)
-
Good (83.3%)
-
-
Not sure (58.3%)
927
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 default.sp Data example
Plain text file sp.php Example example
Plain text file sqlLayer.php Class mysql wrapper
Plain text file STProc.php Class main class

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