PHP Class CI_DB_mssql_driver, TastyIgniter

Note: _DB is an extender class that the app controller creates dynamically based on whether the query builder class is being used or not.
See link: http://codeigniter.com/user_guide/database/
Author: EllisLab Dev Team
Inheritance: extends CI_DB
Afficher le fichier Open project: tastyigniter/tastyigniter

Méthodes publiques

Свойство Type Description
$dbdriver string Database driver

Protected Properties

Свойство Type Description
$_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

Méthodes publiques

Méthode Description
__construct ( array $params ) : void Class constructor
affected_rows ( ) : integer Affected Rows
db_connect ( boolean $persistent = FALSE ) : resource Non-persistent 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

Méthodes protégées

Méthode Description
_close ( ) : void Close DB Connection
_db_set_charset ( string $charset ) : boolean Set client character set
_delete ( string $table ) : string Delete statement
_execute ( string $sql ) : mixed 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 ( boolean $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
_version ( ) : string Version number query string

Method Details

__construct() public méthode

Appends the port number to the hostname, if needed.
public __construct ( array $params ) : void
$params array
Résultat void

_close() protected méthode

Close DB Connection
protected _close ( ) : void
Résultat void

_db_set_charset() protected méthode

Set client character set
protected _db_set_charset ( string $charset ) : boolean
$charset string
Résultat boolean

_delete() protected méthode

Generates a platform-specific delete string from the supplied data
protected _delete ( string $table ) : string
$table string
Résultat string

_execute() protected méthode

Execute the query
protected _execute ( string $sql ) : mixed
$sql string an SQL query
Résultat mixed resource if rows are returned, bool otherwise

_insert_batch() protected méthode

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
Résultat string | boolean

_limit() protected méthode

Generates a platform-specific LIMIT clause
protected _limit ( string $sql ) : string
$sql string SQL Query
Résultat string

_list_columns() protected méthode

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

_list_tables() protected méthode

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

_trans_begin() protected méthode

Begin Transaction
protected _trans_begin ( ) : boolean
Résultat boolean

_trans_commit() protected méthode

Commit Transaction
protected _trans_commit ( ) : boolean
Résultat boolean

_trans_rollback() protected méthode

Rollback Transaction
protected _trans_rollback ( ) : boolean
Résultat boolean

_truncate() protected méthode

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
Résultat string

_update() protected méthode

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

_version() protected méthode

Version number query string
protected _version ( ) : string
Résultat string

affected_rows() public méthode

Affected Rows
public affected_rows ( ) : integer
Résultat integer

db_connect() public méthode

Non-persistent database connection
public db_connect ( boolean $persistent = FALSE ) : resource
$persistent boolean
Résultat resource

db_select() public méthode

Select the database
public db_select ( string $database = '' ) : boolean
$database string
Résultat boolean

error() public méthode

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

field_data() public méthode

Returns an object with field data
public field_data ( string $table ) : array
$table string
Résultat array

insert_id() public méthode

Returns the last id created in the Identity column.
public insert_id ( ) : string
Résultat string

Property Details

$_quoted_identifier protected_oe property

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

$_random_keyword protected_oe property

ORDER BY random keyword
protected array $_random_keyword
Résultat array

$dbdriver public_oe property

Database driver
public string $dbdriver
Résultat string