openlss/lib-db

PDO wrapper library with helpers

Thursday, May 2, 2013
by nullivex
Repository
1 Watchers
2 Stars
179 Installations

PHP
3 Dependents
0 Suggesters
0 Forks
0 Open issues
17 Versions
0 % Grown

The README.md

openlss/lib-db

PDO wrapper library with helpers, _(*1)

The Db class tracks query counts and can debug queries. It will auto-generate SQL for insert/update queries., _(*2)

Usage

//connect
Db::_get()->setConfig($dbconfig)->connect();

//execute a fetch
$result = Db::_get()->fetch('SELECT * FROM `table` WHERE `col` = ?',array($col));

Reference

Call to PDO

Any functions not shown in the reference are passed directly to PDO, _(*3)

Singleton Information

Db can be and is recommended to be used as a singleton to reuse the same PDO instance., _(*4)

If multiple connections are needed use a custom method of maintaining the instances., _(*5)

($this) Db::setConfig($config)

Sets the config of the database system., _(*6)

Takes an array with the following structure, _(*7)

$config = array(
     'driver'       =>  'mysql'
    ,'database'     =>  'database_name'
    ,'host'         =>  'server_host'
    ,'port'         =>  'server_port'
    ,'user'         =>  'username'
    ,'password'     =>  'password'
);

($this) Db::connect()

Will use the current configuration and connect, _(*8)

(int) Db::getQueryCount()

Returns the current query count, _(*9)

(bool) Db::close()

Close the open PDO istance (if any), _(*10)

(array) Db::prepWhere($pairs,$type='WHERE')

Prepares WHERE strings to be used in queries * $pairs array of clauses which can be in 4 formats * 'field-name' => array($bool='AND',$operator='=',$value) * 'field-name' => array($operator='=',$value) //bool defaults to AND * 'field-name' => array($operator) //bool defaults to AND, value defaults to NULL * 'field-name' => $value //bool defaults to AND, operator defaults to = * NOTE: use Db::IS_NULL and Db::IS_NOT_NULL for null value operators * $type specify the start of the string defaults to 'WHERE' * returns an array, with members: * [0] the resulting WHERE clause; compiled for use with PDO::prepare including leading space (ready-to-use) * [n] the values array; ready for use with PDO::execute, _(*11)

(int) Db::insert($table,$params=array(),$update_if_exists=false)

Insert into a table with given parameters, _(*12)

When $update_if_exists is set to TRUE it will perform an INSERT OR UPDATE query., _(*13)

(bool) Db::update($table,$keys=array(),$params=array())

Updates a record in the database * $table The table to be updates * $keys Pairs compatible with prepWhere * $params Array of name=>value pairs to update with, _(*14)

(result) Db::fetch($stmt,$params=array(),$throw_exception=Db::NO_EXCEPTIONS,$except_code=null,$flatten=Db::NO_FLATTEN)

Fetches a single row from a query and returns the result * $stmt The SQL query * $params Parameters to be bound to the query * $throw_exception When set to Db::EXCEPTIONS will throw an exception on result not found * $except_cde Code to be throw with the exception * $flatten When set to Db::FLATTEN will return an array of values from a specific column, _(*15)

(array result) Db::fetchAll($stmt,$params=array(),$throw_exception=Db::NO_EXCEPTIONS,$except_code=null,$flatten=Db::NO_FLATTEN)

Same as fetch but returns all results in an array, _(*16)

The Versions

02/05 2013

dev-master

9999999-dev http://openlss.org

PDO wrapper library with helpers

library lib-db

PDO wrapper library with helpers

openlss/lib-db

The README.md

openlss/lib-db

Usage

Reference

Call to PDO

Singleton Information

($this) Db::setConfig($config)

($this) Db::connect()

(int) Db::getQueryCount()

(bool) Db::close()

(array) Db::prepWhere($pairs,$type='WHERE')

(int) Db::insert($table,$params=array(),$update_if_exists=false)

(bool) Db::update($table,$keys=array(),$params=array())

(result) Db::fetch($stmt,$params=array(),$throw_exception=Db::NO_EXCEPTIONS,$except_code=null,$flatten=Db::NO_FLATTEN)

(array result) Db::fetchAll($stmt,$params=array(),$throw_exception=Db::NO_EXCEPTIONS,$except_code=null,$flatten=Db::NO_FLATTEN)

The Versions

dev-master

The Requires

by Bryan Tong

by Tony Butler

dev-0.0.x-dev

The Requires

by Bryan Tong

by Tony Butler

0.0.15

The Requires

by Bryan Tong

by Tony Butler

0.0.11

The Requires

by Bryan Tong

by Tony Butler

0.0.12

The Requires

by Bryan Tong

by Tony Butler

0.0.13

The Requires

by Bryan Tong

by Tony Butler

0.0.14

The Requires

by Bryan Tong

by Tony Butler

0.0.10

The Requires

by Bryan Tong

by Tony Butler

0.0.8

The Requires

The Development Requires

by Bryan Tong

by Tony Butler

0.0.9

The Requires

The Development Requires

by Bryan Tong

by Tony Butler

0.0.7

The Requires

The Development Requires

by Bryan Tong

by Tony Butler

0.0.6

The Requires

The Development Requires

by Bryan Tong

by Tony Butler

0.0.5

The Requires

The Development Requires

by Bryan Tong

by Tony Butler

0.0.4

The Requires

by Bryan Tong

by Tony Butler