Login   Register  
PHP Classes
elePHPant
Icontem

DbSimple: Abstraction to access several SQL databases

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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 (7 years ago) RSS 2.0 feedStarStarStar 46%Total: 1,184 All time: 2,976 This week: 1,398Up
Version License PHP version Categories  
dbsimple 2GNU Lesser General Publ...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
Age: ???
All time rank: 65918 in Russian Federation Russian Federation
Week rank: 732 Down21 in Russian Federation Russian Federation Down

  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,184All time:2,976
 This week:0This week:1,398Up
 User Ratings  
 
 All time
Utility:75%StarStarStarStar
Consistency:91%StarStarStarStarStar
Documentation:-
Examples:-
Tests:-
Videos:-
Overall:46%StarStarStar
Rank:1839