PHP Classes

SQL Data Manager: Access MySQL databases

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
Not enough user ratingsTotal: 411 All time: 6,485 This week: 455Up
Version License PHP version Categories
sql-data-manager 1GNU General Publi...4.0PHP 5, Databases
Description 

Author

Paul Gillespie

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: 40
All time rank: 3522155 in United Kingdom
Week rank: 195 Up9 in United Kingdom Up

  Files folder image Files (9)  
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.

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
Downloadsql-data-manager-2010-03-03.zip 5KB
Downloadsql-data-manager-2010-03-03.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:411
This week:0
All time:6,485
This week:455Up

  Applications that use this package  
An eCommerce utility that is under development uses SQLDataManager.

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