PHP Classes

SQL Data Manager: Access MySQL databases

Recommend this page to a friend!
  Info   View files View files (9)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 410 All time: 6,462 This week: 1,116Up
Version License PHP version Categories
sql-data-manager 1GNU General Publi...4.0PHP 5, Databases


This package can be used to access MySQL databases.

It provides several classes to wrap MySQL database access connections, execute SQL queries and retrieve query result rows and column fields.

Picture of Paul Gillespie
Name: Paul Gillespie <contact>
Classes: 1 package by
Country: United Kingdom
Age: 38
All time rank: 3500155 in United Kingdom
Week rank: 514 Up17 in United Kingdom Up

  Files folder image Files  
File Role Description
Plain text file Database.php Class This class is extended by SQLDataManager and contains methods for handling data in chunks. This is also the wrapper for all of the other classes.
Accessible without login Plain text file example_1.php Example This is an example of how to use the manager for basic sql queries.
Accessible without login Plain text file example_2.php Example This is an example of using the manager to return data in chunks via the more processing flag and limit assignments.
Plain text file MyAccess.php Class This is used to read the mysql config file to extract the login details and database information.
Plain text file MyData.php Class This conatins the classes to generate the data structure based on the returned rows and fields.
Plain text file MyDB.php Class This is used to open database conections and also close them.
Plain text file MySQL.php Class This uses the opened connections to execute the sql and returns the raw data.
Accessible without login Plain text file mysql_access.config Data This is the format that the config file must be in.
Plain text file SQLDataManager.php Class The main class for the SQLDataManager package. This is the class that is to be called from the PHP script that wants to use it.

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:6,462
This week:1,116Up