PHP 클래스 CI_DB_sqlsrv_driver, TastyIgniter

Note: _DB is an extender class that the app controller creates dynamically based on whether the active record class is being used or not.
저자: ExpressionEngine Dev Team
상속: extends CI_DB
파일 보기 프로젝트 열기: tastyigniter/tastyigniter

공개 프로퍼티들

프로퍼티 타입 설명
$dbdriver string Database driver
$scrollable mixed Determines what cursor type to use when executing queries. FALSE or SQLSRV_CURSOR_FORWARD would increase performance, but would disable num_rows() (and possibly insert_id())

보호된 프로퍼티들

프로퍼티 타입 설명
$_quoted_identifier boolean Whether to use SQL-92 standard quoted identifier (double quotes) or brackets for identifier escaping.
$_random_keyword array ORDER BY random keyword

공개 메소드들

메소드 설명
__construct ( array $params ) : void Class constructor
affected_rows ( ) : integer Affected Rows
db_connect ( boolean $pooling = FALSE ) : resource Database connection
db_select ( string $database = '' ) : boolean Select the database
error ( ) : array Error
field_data ( string $table ) : array Returns an object with field data
insert_id ( ) : string Insert ID
version ( ) : string Database version number

보호된 메소드들

메소드 설명
_close ( ) : void Close DB Connection
_delete ( string $table ) : string Delete statement
_execute ( string $sql ) : resource Execute the query
_insert_batch ( string $table, array $keys, array $values ) : string | boolean Insert batch statement
_limit ( string $sql ) : string LIMIT
_list_columns ( string $table = '' ) : string List column query
_list_tables ( $prefix_limit = FALSE ) : string List table query
_trans_begin ( ) : boolean Begin Transaction
_trans_commit ( ) : boolean Commit Transaction
_trans_rollback ( ) : boolean Rollback Transaction
_truncate ( string $table ) : string Truncate statement
_update ( string $table, array $values ) : string Update statement

메소드 상세

__construct() 공개 메소드

Class constructor
public __construct ( array $params ) : void
$params array
리턴 void

_close() 보호된 메소드

Close DB Connection
protected _close ( ) : void
리턴 void

_delete() 보호된 메소드

Generates a platform-specific delete string from the supplied data
protected _delete ( string $table ) : string
$table string
리턴 string

_execute() 보호된 메소드

Execute the query
protected _execute ( string $sql ) : resource
$sql string an SQL query
리턴 resource

_insert_batch() 보호된 메소드

Generates a platform-specific insert string from the supplied data.
protected _insert_batch ( string $table, array $keys, array $values ) : string | boolean
$table string Table name
$keys array INSERT keys
$values array INSERT values
리턴 string | boolean

_limit() 보호된 메소드

Generates a platform-specific LIMIT clause
protected _limit ( string $sql ) : string
$sql string SQL Query
리턴 string

_list_columns() 보호된 메소드

Generates a platform-specific query string so that the column names can be fetched
protected _list_columns ( string $table = '' ) : string
$table string
리턴 string

_list_tables() 보호된 메소드

Generates a platform-specific query string so that the table names can be fetched
protected _list_tables ( $prefix_limit = FALSE ) : string
리턴 string $prefix_limit

_trans_begin() 보호된 메소드

Begin Transaction
protected _trans_begin ( ) : boolean
리턴 boolean

_trans_commit() 보호된 메소드

Commit Transaction
protected _trans_commit ( ) : boolean
리턴 boolean

_trans_rollback() 보호된 메소드

Rollback Transaction
protected _trans_rollback ( ) : boolean
리턴 boolean

_truncate() 보호된 메소드

Generates a platform-specific truncate string from the supplied data If the database does not support the TRUNCATE statement, then this method maps to 'DELETE FROM table'
protected _truncate ( string $table ) : string
$table string
리턴 string

_update() 보호된 메소드

Generates a platform-specific update string from the supplied data
protected _update ( string $table, array $values ) : string
$table string
$values array
리턴 string

affected_rows() 공개 메소드

Affected Rows
public affected_rows ( ) : integer
리턴 integer

db_connect() 공개 메소드

Database connection
public db_connect ( boolean $pooling = FALSE ) : resource
$pooling boolean
리턴 resource

db_select() 공개 메소드

Select the database
public db_select ( string $database = '' ) : boolean
$database string
리턴 boolean

error() 공개 메소드

Returns an array containing code and message of the last database error that has occured.
public error ( ) : array
리턴 array

field_data() 공개 메소드

Returns an object with field data
public field_data ( string $table ) : array
$table string
리턴 array

insert_id() 공개 메소드

Returns the last id created in the Identity column.
public insert_id ( ) : string
리턴 string

version() 공개 메소드

Database version number
public version ( ) : string
리턴 string

프로퍼티 상세

$_quoted_identifier 보호되어 있는 프로퍼티

Whether to use SQL-92 standard quoted identifier (double quotes) or brackets for identifier escaping.
protected bool $_quoted_identifier
리턴 boolean

$_random_keyword 보호되어 있는 프로퍼티

ORDER BY random keyword
protected array $_random_keyword
리턴 array

$dbdriver 공개적으로 프로퍼티

Database driver
public string $dbdriver
리턴 string

$scrollable 공개적으로 프로퍼티

Determines what cursor type to use when executing queries. FALSE or SQLSRV_CURSOR_FORWARD would increase performance, but would disable num_rows() (and possibly insert_id())
public mixed $scrollable
리턴 mixed