PHP Classes

ezMySQL: Manage MySQL database tables and 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 55%Total: 1,594 All time: 2,464 This week: 488Up
Version License PHP version Categories
ezmysql_manage 1.0.0Freeware3.0Databases
Description 

Author

This class can be used to manage MySQL database tables and stored procedures.

It can read and display the list of tables and their fields, as well the stored procedures of a given MySQL database.

The class may also create, update, drop and list the code of a given stored procedure.

Innovation Award
PHP Programming Innovation award winner
February 2007
Winner


Prize: One copy of DWeb Pro Lifetime License
One of the most expected enhancements of MySQL 5 is the support to stored procedures.

Most high-end relational database systems already supported a stored procedures language for a long time.

This was one enhancement that MySQL 5 provides, nailing one of the remaining objections that high end relational database system fans used to not consider MySQL a serious option.

This class provides means to simplify the creation, alteration, dropping and listing of stored procedures under MySQL 5.

Manuel Lemos
Picture of S. M. ARIFUL ISLAM
Name: S. M. ARIFUL ISLAM <contact>
Classes: 2 packages by
Country: Bangladesh Bangladesh
Age: 42
All time rank: 82612 in Bangladesh Bangladesh
Week rank: 215 Up4 in Bangladesh Bangladesh Up
Innovation award
Innovation award
Nominee: 1x

Winner: 1x

  Files folder image Files (9)  
File Role Description
Plain text file db_struct_view.php Example View database structure
Accessible without login Plain text file ezMySQL.cls.lib.php Class Class to view database and manage(create, update, delete) stored procedures.
HTML file help.html Doc. A simple help guide and reference to learn Stored Procedure
Plain text file index.php Example Home page of this package
Plain text file sp_manage.php Example Home page for Stored procedure manage
Plain text file style.css Data Style sheet file
Plain text file update_sp.php Example Update a stored procedure
Plain text file view_procedure_list.php Example View existing procedure list
Plain text file view_sp_list_home.php Example Home page of view stored procedure list

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
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,594
This week:0
All time:2,464
This week:488Up
 User Ratings  
 
 All time
Utility:70%StarStarStarStar
Consistency:70%StarStarStarStar
Documentation:66%StarStarStarStar
Examples:66%StarStarStarStar
Tests:-
Videos:-
Overall:55%StarStarStar
Rank:1916