PHP Classes

SlimDb: Access different database types using PDO

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 50%Total: 440 All time: 6,256 This week: 48Up
Version License PHP version Categories
slimdb 1MIT/X Consortium ...5.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: 47
All time rank: 5476 in Argentina Argentina
Week rank: 214 Up2 in Argentina Argentina Up
Innovation award
Innovation award
Nominee: 1x

Recommendations

Good and simple MySQL wrapper
What MySQL wrapper should I go with?

Details

SlimDb ====== Small db layer around the PDO and PDO statement. The package goal is to be small and handy, with the basic, commonly used db functions (like select, update, insert and delete). Currently there's only support for mysql and sqlite. # Db Setup The configuration it's done using arrays. In this example, there are two db settings: * the first has 'portal' as connection name, and it's a mysql db. * the second has 'admin' as connection name, and it's a sqlite db. Finally, there is a 'default' connection name configured with the 'portal' value. //database configutation $config = array( 'portal' => array( 'dns' => "mysql:host=127.0.0.1;port=3306;dbname=testdb", 'username' => 'user', 'password' => 'secret', 'charset' => 'UTF8', 'log' => TRUE, ), 'admin' => array( 'dns' => "sqlite:/path/to/sqlite.db", 'log' => TRUE, ), 'default' => 'portal', ); //initialize SlimDb foreach($config as $index=>$setting){ if(is_array($setting)){ \SlimDb\SlimDb::configure($index, $setting); }elseif($index==='default'){ \SlimDb\SlimDb::setDefaultConnection($setting); } } There are many classes bundled with the package. Depending on what you are trying to do, you should use one over the other. Here is a list: * Runing raw queries: SlimDb or Database classes * Fetching data: ResultSet class * Working with a single table: Table * ORM: TableRecord class # Running raw queries If you want to run raw queries you can use `SlimDb` (which is a static class) or `Database` (which is not static). These two classes are just a wrapper around pdo, and will return a `ResultSet` object after a query. Examples $sql = "select * from customer"; //static example $resultSet = \SlimDb\SlimDb::query('portal', $sql); //non static example $db = \SlimDb\Database(); //by default use 'portal' db $resultSet = $db->query($sql); ## Fetching data Everytime you run a `query()` method, you'll get a `ResultSet` object (which is a wrapper around pdo statement object). Now you can use `getAll()`, `getRow()` or `getVal()` methods to retrieve data. Please note, when running raw queries, `ResultSet` objects will return data as an array by default. **getAll()** examples //fetching several rows from db (low memory consumption) $resultSet = $db->query($sql); foreach($resultSet as $row) { print_r($row); //show an array } //fetching several rows from db into an array $sql = "select * from customer"; $array = $db->query($sql)->getAll(); foreach($array as $row) { print_r($row); //show an array } **getRow()** example //fetching the 'where id=1' row $sql = "select * from customer where id=?"; $row = $db->query($sql, array(1))->getRow(); echo $row['id']; **getVal()** example //fetching a single value $sql = "select count(*) from customer"; $row = $db->query( $sql )->getVal(); # Using the Table class This class is ment for doing common task in a sigle table without writing raw queries. Internally, this class will use `SlimDb::query()` method, so after a `find()`, `first()`, `insert()`, `update()` or `delete()` call you'll get a `ResultSet` object. Please note, when using `Table` object, `ResultSet` objects will return data as a `TableRecord` object by default. **Fetching data** examples //get all rows from customer table $resultSet = $db->table('customer')->find(); foreach($resultSet as $row) { print_r($row); //show an object } echo $resultSet->rowCount(); //returned rows //get some rows from customer table (where name like '%jhon%') $resultSet = $db->table('customer')->find("name like ?", array('%jhon%')); foreach($resultSet as $row) { print_r($row); //show an object } echo count($resultSet); //returned rows //get a single row $row = $db->table('customer')->first(); echo $row->id; **Insert, update, delete** operations //insert into customer(name) values('Jhon Doe') $data = array( 'name'=>'Jhon Doe' ); $resultSet = $db->table('customer')->insert($data); echo $resultSet->lastInsertId(); //update customer where id=1 set name='Jhon Doe' $data = array( 'name'=>'Jhon Doe' ); $resultSet = $db->table('customer')->update($data, "id=?", array(1)); echo $resultSet->rowCount(); //affected rows //delete where id=1 or category=9 $db->table('customer')->delete("id=? or category=?", array(1, 9)); echo $resultSet->rowCount(); //affected rows ## Working with TableRecord class This class it's a small ORM class. You can change properties values with `set()` method and then push changes to db with `save()` method. Example //get customer id=1 and change it name $customer = $db->table('customer')->first("id=?", array(1)); $customer->set('name', 'Jhon Foo')->save();

  Files folder image Files (8)  
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 (8)  /  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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:440
This week:0
All time:6,256
This week:48Up
 User Ratings  
 
 All time
Utility:75%StarStarStarStar
Consistency:58%StarStarStar
Documentation:75%StarStarStarStar
Examples:-
Tests:-
Videos:-
Overall:50%StarStarStar
Rank:2627