\Fubber\DbPdoDb

PDO database wrapper using the IDb interface

Summary

Methods
Properties
Constants
__construct()
lastInsertId()
query()
queryOne()
queryField()
queryColumn()
exec()
beginTransaction()
commit()
rollBack()
$pdo
No constants found
prepare()
sendDebug()
_rewrite()
$idx
$_lastInsertId
$statements
N/A
No private methods found
No private properties found
N/A

Properties

$pdo

$pdo : 

Type

$idx

$idx : 

Type

$_lastInsertId

$_lastInsertId : 

Type

$statements

$statements : 

Type

Methods

__construct()

__construct(\Fubber\Db\PDO  $pdo) 

Parameters

\Fubber\Db\PDO $pdo

lastInsertId()

lastInsertId() : mixed

Return the primary key of the last inserted row

Returns

mixed

query()

query(  $statement, array  $vars = array(), string  $className = 'stdClass') : array

Query the database and return an array of objects

Parameters

$statement
array $vars
string $className

Returns

array —

Returns an array of stdClass objects, or whatever class provided in $className

queryOne()

queryOne(  $statement, array  $vars = array(), string  $className = 'stdClass') : mixed

Query the database and return a single object that is the first row in the result set

Parameters

$statement
array $vars
string $className

Returns

mixed

queryField()

queryField(  $statement, array  $vars = array()) : mixed

Query the database and return the first column of the first row

Parameters

$statement
array $vars

Returns

mixed

queryColumn()

queryColumn(  $statement, array  $vars = array()) 

Query the database and return an array of values with the first column of the result

Parameters

$statement
array $vars

exec()

exec(string  $statement, array  $vars = array()) : boolean|integer

Execute a query. If the query fails, throws an exception. Else it returns the number of affected rows.

Parameters

string $statement
array $vars

Returns

boolean|integer

beginTransaction()

beginTransaction() 

Start a database transaction

commit()

commit() 

Commit the database transaction

rollBack()

rollBack() 

Rollback the database transaction

prepare()

prepare(  $statement) 

Parameters

$statement

sendDebug()

sendDebug(  $statement,   $vars) 

Parameters

$statement
$vars

_rewrite()

_rewrite(  $statement, array  $vars) 

Parameters

$statement
array $vars