\Fubber\DbIDb

Generic DB driver interface. Can be mapped directly to most SQL database engines.

Summary

Methods
Constants
lastInsertId()
query()
queryField()
beginTransaction()
commit()
rollBack()
queryOne()
exec()
No constants found
No protected methods found
N/A
No private methods found
N/A

Methods

lastInsertId()

lastInsertId() : mixed

Return the primary key of the last inserted row

Returns

mixed

query()

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

Perform an SQL query

Parameters

string $sql
array $vars
string $className

Returns

array —

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

queryField()

queryField(string  $sql, array  $vars = array()) : mixed

Perform an SQL query, but only return the first field of the first row.

Parameters

string $sql
array $vars

Returns

mixed

beginTransaction()

beginTransaction() 

Start a database transaction

commit()

commit() 

Commit the database transaction

rollBack()

rollBack() 

Rollback the database transaction

queryOne()

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

Select the first row in the result as an instance of $className

Parameters

string $sql
array $vars
string $className

Returns

mixed

exec()

exec(string  $sql, array  $vars = array()) : boolean

Execute a database statement

Parameters

string $sql
array $vars

Returns

boolean