PHP Classes

Database Abstraction: Access different types of SQL database

Recommend this page to a friend!
  Info   View files View files (13)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 623 This week: 1All time: 5,069 This week: 560Up
Version License PHP version Categories
database-abstraction 1.0GNU General Publi...5.3PHP 5, Databases
Description 

Author

This package implements a database abstraction layer that provides the same interface to access different types of SQL databases.

There is a factory class that can create an instance of the database access class specialized in accessing one of the several supported types of SQL databases.

Each database access class extends a configuration class and implements the same interface that provides functionality for establishing database connections, manage transactions, execute SQL queries, retrieve query results into arrays or objects and retrieve the number of affected rows or the last inserted row identifier.

Currently it provides classes for accessing MySQL, PostgreSQL, SQLite, Microsoft SQL and Oracle.

Picture of Nitesh Apte
  Performance   Level  
Name: Nitesh Apte is available for providing paid consulting. Contact Nitesh Apte .
Classes: 17 packages by
Country: India India
Age: 40
All time rank: 1337 in India India
Week rank: 106 Up8 in India India Down
Innovation award
Innovation award
Nominee: 3x

Winner: 1x

Details

You just need to change the DB_TYPE defined in conf.inc file. If I am missing something, please mail me at nitesh.apte@gmail.com. I'll like to make this package more better.

  Files folder image Files  
File Role Description
Plain text file abstract.DBConfig.php Class Abstract class to provide abstract features for database connectivity.
Plain text file class.DBManager.php Class Database manager class. Create the instance of database class depending on the type of database type defined.
Plain text file class.ExampleUsage.php Class Example usage class
Plain text file class.MSSqlDB.php Class MSSql database connectivity class.
Plain text file class.MySqlDB.php Class MySQL database connectivity class.
Plain text file class.OracleDB.php Class Oracle database connectivity class.
Plain text file class.PostgreDB.php Class Postgre database connectivity class.
Plain text file class.SqliteDB.php Class Sqlite database connectivity class.
Accessible without login Plain text file conf.inc Conf. Global Default values that to be used throughout the project
Accessible without login Plain text file example-usage.php Example Example usage script
Plain text file interface.DBConfigInterface.php Class Interface declaring the methods that to be followed for database interaction.
Accessible without login Plain text file LICENSE.TXT Lic. License Text
Accessible without login Plain text file README.TXT Doc. Readme file

 Version Control Unique User Downloads Download Rankings  
 0%
Total:623
This week:1
All time:5,069
This week:560Up