PHP Classes
elePHPant
Icontem

DbSimple: Abstraction to access several SQL databases

Recommend this page to a friend!
  Info   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2007-01-17 (9 years ago) RSS 2.0 feedStarStarStar 46%Total: 1,195 All time: 3,064 This week: 871Up
Version License PHP version Categories
dbsimple 2GNU Lesser Genera...4.1Databases
Description Author

This is an abstraction package to access several types of SQL databases.

Its features:

- Drivers to access MySQL, PostgreSQL and InterBase or FireBird
- Can execute SQL query templates supporting conditional blocks
- Caching of query results
- Place holder query arguments
- Execute operations to select and count total number of resulting rows
- Retrieve query results in different modes: all result rows, one row, one column, one cell, associative array, multidimensional associative array, linked tree, etc.
- Support to watch and debug query errors
- Query logging that includes query results and caller line number
- Support to native prepared queries
- Access to BLOBs

Please note: there is a lot of usage examples at http://en.dklab.ru/lib/DbSimple/#list1
E.g. MySQL connect:

require_once "DbSimple/Generic.php";
$DB = DbSimple_Generic::connect("mysql://login:password@host/database");
$rows = $DB->select('SELECT * FROM ?_user LIMIT 10');

Always fresh version at http://en.dklab.ru/lib/DbSimple/

Picture of Dmitry Koterov
Name: Dmitry Koterov <contact>
Classes: 2 packages by
Country: Russian Federation Russian Federation

  Files folder image Files  
File Role Description
Accessible without login Plain text file Generic.php Class Base class
Accessible without login Plain text file Ibase.php Class InterBase/FireBird driver
Accessible without login Plain text file Mysql.php Class Mysql driver
Accessible without login Plain text file Postgresql.php Class Postgresql driver

 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,195
This week:0
All time:3,064
This week:871Up
 User Ratings  
 
 All time
Utility:75%StarStarStarStar
Consistency:91%StarStarStarStarStar
Documentation:-
Examples:-
Tests:-
Videos:-
Overall:46%StarStarStar
Rank:2326