• Home
• dibi

PHP Class dibi

Show file Open project: dg/dibi Class Usage Examples

Public Properties

Property	Type	Description
$defaultDriver		Default dibi driver
$elapsedTime		Elapsed time for last query
$numOfQueries		Number or queries
$sql		Last SQL command @see dibi::query()
$totalTime		Elapsed time for all queries

Public Methods

Method	Description
__construct ( )	Static class - cannot be instantiated.
activate ( $name )
affectedRows ( ) : integer	Gets the number of affected rows. Alias for getAffectedRows().
begin ( $savepoint = NULL ) : void	Begins a transaction - Monostate for Dibi\Connection::begin().
command ( ) : Dibi\Fluent
commit ( $savepoint = NULL ) : void	Commits statements in a transaction - Monostate for Dibi\Connection::commit($savepoint = NULL).
connect ( $config = [], $name ) : Dibi\Connection	Creates a new Connection object and connects it to specified database.
dataSource ( $args ) : Dibi\DataSource	Generates and returns SQL query as DataSource - Monostate for Dibi\Connection::test().
delete ( $table ) : Dibi\Fluent
disconnect ( ) : void	Disconnects from database (doesn't destroy Connection object).
dump ( $sql = NULL, $return = FALSE ) : string	Prints out a syntax highlighted version of the SQL command or Result.
fetch ( $args ) : Dibi\Row	Executes SQL query and fetch result - Monostate for Dibi\Connection::query() & fetch().
fetchAll ( $args ) : Dibi\Row[]	Executes SQL query and fetch results - Monostate for Dibi\Connection::query() & fetchAll().
fetchPairs ( $args ) : array	Executes SQL query and fetch pairs - Monostate for Dibi\Connection::query() & fetchPairs().
fetchSingle ( $args ) : string	Executes SQL query and fetch first column - Monostate for Dibi\Connection::query() & fetchSingle().
getAffectedRows ( ) : integer	Gets the number of affected rows.
getConnection ( $name = NULL ) : Dibi\Connection	Retrieve active connection.
getDatabaseInfo ( ) : Dibi\Reflection\Database	Gets a information about the current database - Monostate for Dibi\Connection::getDatabaseInfo().
getInsertId ( $sequence = NULL ) : integer	Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
getSubstitutes ( ) : Dibi\HashMap	Returns substitution hashmap - Monostate for Dibi\Connection::getSubstitutes().
insert ( $table, $args ) : Dibi\Fluent
insertId ( $sequence = NULL ) : integer	Retrieves the ID generated for an AUTO_INCREMENT column. Alias for getInsertId().
isConnected ( ) : boolean	Returns TRUE when connection was established.
loadFile ( $file ) : integer	Import SQL dump from file - extreme fast!
nativeQuery ( $sql ) : Dibi\Result | integer	Executes the SQL query - Monostate for Dibi\Connection::nativeQuery().
query ( $args ) : Dibi\Result | integer	Generates and executes SQL query - Monostate for Dibi\Connection::query().
rollback ( $savepoint = NULL ) : void	Rollback changes in a transaction - Monostate for Dibi\Connection::rollback().
select ( $args ) : Dibi\Fluent
setConnection ( Dibi\Connection $connection ) : Dibi\Connection	Sets connection.
test ( $args ) : boolean	Generates and prints SQL query - Monostate for Dibi\Connection::test().
update ( $table, $args ) : Dibi\Fluent

Method Details

Property Details