PHP 클래스 dibi

파일 보기 프로젝트 열기: dg/dibi 1 사용 예제들

공개 프로퍼티들

프로퍼티 타입 설명
$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

공개 메소드들

메소드 설명
__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

메소드 상세

__construct() 최종 공개 메소드

Static class - cannot be instantiated.
final public __construct ( )

activate() 공개 정적인 메소드

사용 중단:
public static activate ( $name )

affectedRows() 공개 정적인 메소드

Gets the number of affected rows. Alias for getAffectedRows().
public static affectedRows ( ) : integer
리턴 integer number of rows

begin() 공개 정적인 메소드

Begins a transaction - Monostate for Dibi\Connection::begin().
public static begin ( $savepoint = NULL ) : void
리턴 void

command() 공개 정적인 메소드

public static command ( ) : Dibi\Fluent
리턴 Dibi\Fluent

commit() 공개 정적인 메소드

Commits statements in a transaction - Monostate for Dibi\Connection::commit($savepoint = NULL).
public static commit ( $savepoint = NULL ) : void
리턴 void

connect() 공개 정적인 메소드

Creates a new Connection object and connects it to specified database.
public static connect ( $config = [], $name ) : Dibi\Connection
리턴 Dibi\Connection

dataSource() 공개 정적인 메소드

Generates and returns SQL query as DataSource - Monostate for Dibi\Connection::test().
public static dataSource ( $args ) : Dibi\DataSource
리턴 Dibi\DataSource

delete() 공개 정적인 메소드

public static delete ( $table ) : Dibi\Fluent
리턴 Dibi\Fluent

disconnect() 공개 정적인 메소드

Disconnects from database (doesn't destroy Connection object).
public static disconnect ( ) : void
리턴 void

dump() 공개 정적인 메소드

Prints out a syntax highlighted version of the SQL command or Result.
public static dump ( $sql = NULL, $return = FALSE ) : string
리턴 string

fetch() 공개 정적인 메소드

Executes SQL query and fetch result - Monostate for Dibi\Connection::query() & fetch().
public static fetch ( $args ) : Dibi\Row
리턴 Dibi\Row

fetchAll() 공개 정적인 메소드

Executes SQL query and fetch results - Monostate for Dibi\Connection::query() & fetchAll().
public static fetchAll ( $args ) : Dibi\Row[]
리턴 Dibi\Row[]

fetchPairs() 공개 정적인 메소드

Executes SQL query and fetch pairs - Monostate for Dibi\Connection::query() & fetchPairs().
public static fetchPairs ( $args ) : array
리턴 array

fetchSingle() 공개 정적인 메소드

Executes SQL query and fetch first column - Monostate for Dibi\Connection::query() & fetchSingle().
public static fetchSingle ( $args ) : string
리턴 string

getAffectedRows() 공개 정적인 메소드

Monostate for Dibi\Connection::getAffectedRows()
public static getAffectedRows ( ) : integer
리턴 integer number of rows

getConnection() 공개 정적인 메소드

Retrieve active connection.
public static getConnection ( $name = NULL ) : Dibi\Connection
리턴 Dibi\Connection

getDatabaseInfo() 공개 정적인 메소드

Gets a information about the current database - Monostate for Dibi\Connection::getDatabaseInfo().
public static getDatabaseInfo ( ) : Dibi\Reflection\Database
리턴 Dibi\Reflection\Database

getInsertId() 공개 정적인 메소드

Monostate for Dibi\Connection::getInsertId()
public static getInsertId ( $sequence = NULL ) : integer
리턴 integer

getSubstitutes() 공개 정적인 메소드

Returns substitution hashmap - Monostate for Dibi\Connection::getSubstitutes().
public static getSubstitutes ( ) : Dibi\HashMap
리턴 Dibi\HashMap

insert() 공개 정적인 메소드

public static insert ( $table, $args ) : Dibi\Fluent
리턴 Dibi\Fluent

insertId() 공개 정적인 메소드

Retrieves the ID generated for an AUTO_INCREMENT column. Alias for getInsertId().
public static insertId ( $sequence = NULL ) : integer
리턴 integer

isConnected() 공개 정적인 메소드

Returns TRUE when connection was established.
public static isConnected ( ) : boolean
리턴 boolean

loadFile() 공개 정적인 메소드

Import SQL dump from file - extreme fast!
public static loadFile ( $file ) : integer
리턴 integer count of sql commands

nativeQuery() 공개 정적인 메소드

Executes the SQL query - Monostate for Dibi\Connection::nativeQuery().
public static nativeQuery ( $sql ) : Dibi\Result | integer
리턴 Dibi\Result | integer result set object (if any)

query() 공개 정적인 메소드

Generates and executes SQL query - Monostate for Dibi\Connection::query().
public static query ( $args ) : Dibi\Result | integer
리턴 Dibi\Result | integer result set object (if any)

rollback() 공개 정적인 메소드

Rollback changes in a transaction - Monostate for Dibi\Connection::rollback().
public static rollback ( $savepoint = NULL ) : void
리턴 void

select() 공개 정적인 메소드

public static select ( $args ) : Dibi\Fluent
리턴 Dibi\Fluent

setConnection() 공개 정적인 메소드

Sets connection.
public static setConnection ( Dibi\Connection $connection ) : Dibi\Connection
$connection Dibi\Connection
리턴 Dibi\Connection

test() 공개 정적인 메소드

Generates and prints SQL query - Monostate for Dibi\Connection::test().
public static test ( $args ) : boolean
리턴 boolean

update() 공개 정적인 메소드

public static update ( $table, $args ) : Dibi\Fluent
리턴 Dibi\Fluent

프로퍼티 상세

$defaultDriver 공개적으로 정적으로 프로퍼티

Default dibi driver
public static $defaultDriver

$elapsedTime 공개적으로 정적으로 프로퍼티

Elapsed time for last query
public static $elapsedTime

$numOfQueries 공개적으로 정적으로 프로퍼티

Number or queries
public static $numOfQueries

$sql 공개적으로 정적으로 프로퍼티

Last SQL command @see dibi::query()
public static $sql

$totalTime 공개적으로 정적으로 프로퍼티

Elapsed time for all queries
public static $totalTime