PHP Developer's Network : Network Member Forums

Class: MySQL SP


  Search   All class groups   Latest entries   Top 10 charts   Newsletter   Blog   Forums   Help FAQ  
  Login   Register  
Recommend this page to a friend! Trackback URL: http://www.phpclasses.org/trackback/browse/package/1579.html
      Classes of Alexandar Minkovsky  > 
MySQL SP
  >  Download  >  Support forum Support forum  >  RSS 1.0 feed RSS 2.0 feed Latest changes  >  Stumble It! Stumble It!  >  Bookmark in del.icio.us Bookmark in del.icio.us  
  Supplied by   Group folder image Groups   Detailed description  
  Rate classes User ratings   Applications   Files Files  

  • Supplied by:

    • Picture of Alexandar Minkovsky
    Name: Alexandar Minkovsky <e-mail contact>
    Published packages: 3
    Country: Bulgaria Bulgaria - PHP jobs in Bulgaria
    Home page: ???
    Age: 37
    All time rank: 136
    Week rank: 233

    Browse this author's classes

  • 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

  • Groups:

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

  • 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.

  • 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%)
    649
    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:

    • 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.

 
  Advertise on this site   Site map   Statistics   Site tips   Privacy policy   Contact  
For more information send a message to :
info at phpclasses dot org.
Copyright (c) Icontem 1999-2008 PHP Classes - PHP Class Scripts
  PHP Book Reviews - Reviews of books and other products