PHP Class CI_DB_oci8_driver, TastyIgniter

This is a modification of the DB_driver class to permit access to oracle databases

Author: Kelly McArdle

Inheritance: extends CI_DB

Datei anzeigen Open project: tastyigniter/tastyigniter

Public Properties

Property	Type	Description
$commit_mode	integer	Commit mode flag
$curs_id	resource	Cursor ID
$dbdriver	string	Database driver
$limit_used	boolean	If we use LIMIT, we'll add a field that will throw off num_fields later.
$stmt_id	resource	Statement ID

Protected Properties

Property	Type	Description
$_count_string	string	COUNT string
$_random_keyword	array	ORDER BY random keyword
$_reserved_identifiers	string[]	Identifiers that must NOT be escaped.
$_reset_stmt_id		Used by stored_procedure() to prevent _execute() from re-setting the statement ID.

Public Methods

Method	Description
__construct ( array $params ) : void	Class constructor
affected_rows ( ) : integer	Affected Rows
db_connect ( boolean $persistent = FALSE ) : resource	Non-persistent database connection
error ( ) : array	Error
field_data ( string $table ) : array	Returns an object with field data
get_cursor ( ) : resource	Get cursor. Returns a cursor from the database
insert_id ( ) : integer	Insert ID
stored_procedure ( $package, $procedure, array $params ) : mixed	Stored Procedure. Executes a stored procedure
version ( ) : string	Database version number

Protected Methods

Method	Description
_bind_params ( array $params ) : void	Bind parameters
_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	Insert batch statement
_limit ( string $sql ) : string	LIMIT
_list_columns ( string $table = '' ) : string	Show column query
_list_tables ( boolean $prefix_limit = FALSE ) : string	Show table query
_trans_begin ( ) : boolean	Begin Transaction
_trans_commit ( ) : boolean	Commit Transaction
_trans_rollback ( ) : boolean	Rollback Transaction
_truncate ( string $table ) : string	Truncate statement

Method Details

__construct() public method

Class constructor

public __construct ( array $params ) : void
$params	array
return	void

_bind_params() protected method

Bind parameters

protected _bind_params ( array $params ) : void
$params	array
return	void

_close() protected method

Close DB Connection

protected _close ( ) : void
return	void

_delete() protected method

Generates a platform-specific delete string from the supplied data

protected _delete ( string $table ) : string
$table	string
return	string

_execute() protected method

Execute the query

protected _execute ( string $sql ) : resource
$sql	string	an SQL query
return	resource

_insert_batch() protected method

Generates a platform-specific insert string from the supplied data

protected _insert_batch ( string $table, array $keys, array $values ) : string
$table	string	Table name
$keys	array	INSERT keys
$values	array	INSERT values
return	string

_limit() protected method

Generates a platform-specific LIMIT clause

protected _limit ( string $sql ) : string
$sql	string	SQL Query
return	string

_list_columns() protected method

Generates a platform-specific query string so that the column names can be fetched

protected _list_columns ( string $table = '' ) : string
$table	string
return	string

_list_tables() protected method

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
return	string

_trans_begin() protected method

Begin Transaction

protected _trans_begin ( ) : boolean
return	boolean

_trans_commit() protected method

Commit Transaction

protected _trans_commit ( ) : boolean
return	boolean

_trans_rollback() protected method

Rollback Transaction

protected _trans_rollback ( ) : boolean
return	boolean

_truncate() protected method

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
return	string

affected_rows() public method

Affected Rows

public affected_rows ( ) : integer
return	integer

db_connect() public method

Non-persistent database connection

public db_connect ( boolean $persistent = FALSE ) : resource
$persistent	boolean
return	resource

error() public method

Returns an array containing code and message of the last database error that has occured.

public error ( ) : array
return	array

field_data() public method

Returns an object with field data

public field_data ( string $table ) : array
$table	string
return	array

get_cursor() public method

Get cursor. Returns a cursor from the database

public get_cursor ( ) : resource
return	resource

insert_id() public method

Insert ID

public insert_id ( ) : integer
return	integer

stored_procedure() public method

Stored Procedure. Executes a stored procedure

public stored_procedure ( $package, $procedure, array $params ) : mixed
$params	array
return	mixed	params array keys KEY OPTIONAL NOTES name no the name of the parameter should be in : format value no the value of the parameter. If this is an OUT or IN OUT parameter, this should be a reference to a variable type yes the type of the parameter length yes the max size of the parameter

version() public method

Database version number

public version ( ) : string
return	string

Property Details

$_count_string protected_oe property

COUNT string

protected string $_count_string
return	string

$_random_keyword protected_oe property

ORDER BY random keyword

protected array $_random_keyword
return	array

$_reserved_identifiers protected_oe property

Identifiers that must NOT be escaped.

protected string[] $_reserved_identifiers
return	string[]

$_reset_stmt_id protected_oe property

Used by stored_procedure() to prevent _execute() from re-setting the statement ID.

protected $_reset_stmt_id

$commit_mode public_oe property

Commit mode flag

public int $commit_mode
return	integer

$curs_id public_oe property

Cursor ID

public resource $curs_id
return	resource

$dbdriver public_oe property

Database driver

public string $dbdriver
return	string

$limit_used public_oe property

If we use LIMIT, we'll add a field that will throw off num_fields later.

public bool $limit_used
return	boolean

$stmt_id public_oe property

Statement ID

public resource $stmt_id
return	resource