Login   Register  
PHP Classes
elePHPant
Icontem

SlimDb: Access different database types using PDO

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 (8)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2014-05-05 (5 months ago) RSS 2.0 feedNot enough user ratingsTotal: 385 This week: 1All time: 5,992 This week: 1,545Up
Version License PHP version Categories  
slimdb 1MIT/X Consortium License5.3PHP 5, Databases, Design Patterns
Description Author  

This package can be used to access different database types using PDO.

The main class can connect to a given database using PDO.

It takes configuration parameters to determine what driver it should call. Drivers are defined as arrays of functions that implement each of the supported driver operations. Currently there are drivers for MySQL and SQLite.

It supports operations like executing arbitrary SQL queries using prepared statements, retrieving results into arrays, get the last inserted table record identifier and get the metadata of a table.

There is a separate class for executing common SQL INSERT, UPDATE, DELETE and SELECT queries from lists of parameters that define tables, fields, field values, conditions, etc..

Another separate class can perform Object-Relational Mapping by storing and retrieving information in database table records mapped to class objects.

Picture of marcelo entraigas
Name: marcelo entraigas <contact>
Classes: 7 packages by
Country: Argentina Argentina
Age: 37
All time rank: 5406 in Argentina Argentina
Week rank: 607 Down7 in Argentina Argentina Down
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
File Role Description
Files folder imageSlimDb (6 files)
Accessible without login Plain text file LICENSE Lic. MIT License file
Accessible without login Plain text file README.md Doc. Readme file

  Files folder image Files  /  SlimDb  
File Role Description
  Accessible without login Plain text file Driver_Mysql.php Aux. Driver for MySQL
  Accessible without login Plain text file Driver_Sqlite.php Aux. Driver for Sqlite
  Plain text file ResultSet.php Class Main class (PDO wrapper)
  Plain text file SlimDb.php Class Main class (PDO Statement wrapper)
  Plain text file Table.php Class Class specialized in single table operations
  Plain text file TableRecord.php Class Mini ORM class

 Version Control Unique User Downloads Download Rankings  
 100%Total:385All time:5,992
 This week:1This week:1,545Up