Login   Register  
PHP Classes
elePHPant
Icontem

Class: DbSimple

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Dmitry Koterov  >  DbSimple  >  Download .tar.gz .zip  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: DbSimple
Support forum Support forum
Base name: dbsimple
Description: Abstraction to access several SQL databases
Related classes: , , , , , ,
Version: 2
PHP version: 4.1
License: GNU Lesser General Public License (LGPL)
All time users: 1104 users
All time rank: 2768
Week users: 0 users
Week rank: 2502
Picture of Dmitry Koterov
Author: Dmitry Koterov <e-mail contact>
Packages: 2 Browse this author's classes Browse this author's classes
Country: Russian Federation Russian Federation - PHP jobs in Russian Federation
Age: ???
All time rank: 64119 in Russian Federation Russian Federation
Week rank: 2255 Down65 in Russian Federation Russian Federation Down


  Detailed description  
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/

 

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes

  Freshmeat project   Rate classes User ratings   Applications   Files Files  

  Freshmeat project  
Project record: dbsimple
Popularity score: 8.83
Vitality score: 43.16

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Sufficient (75.0%)
Good (91.7%)
-
-
-
-
Not sure (46.7%)
1675
Month:
Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.
  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

Download all files: dbsimple.tar.gz dbsimple.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.