Inheritance diagram for CI_DB_cubrid_driver:

Public Member Functions
	db_connect ()

	db_pconnect ()

	reconnect ()

	db_select ()

	db_set_charset ($charset, $collation)

	_version ()

	_execute ($sql)

	_prep_query ($sql)

	trans_begin ($test_mode=FALSE)

	trans_commit ()

	trans_rollback ()

	escape_str ($str, $like=FALSE)

	affected_rows ()

	insert_id ()

	count_all ($table= '')

	_list_tables ($prefix_limit=FALSE)

	_list_columns ($table= '')

	_field_data ($table)

	_error_message ()

	_error_number ()

	_escape_identifiers ($item)

	_from_tables ($tables)

	_insert ($table, $keys, $values)

	_replace ($table, $keys, $values)

	_insert_batch ($table, $keys, $values)

	_update ($table, $values, $where, $orderby=array(), $limit=FALSE)

	_update_batch ($table, $values, $index, $where=NULL)

	_truncate ($table)

	_delete ($table, $where=array(), $like=array(), $limit=FALSE)

	_limit ($sql, $limit, $offset)

	_close ($conn_id)

Data Fields
const	DEFAULT_PORT = 33000

	$dbdriver = 'cubrid'

	$_escape_char = ''

	$_like_escape_str = ''

	$_like_escape_chr = ''

	$_count_string = 'SELECT COUNT(*) AS '

	$_random_keyword = ' RAND()'

Member Function Documentation

_close ( $conn_id)

Close DB Connection

public

Parameters

resource

Returns: void

_delete	(	$table,
		$where = `array()`,
		$like = `array()`,
		$limit = `FALSE`
	)

Delete statement

Generates a platform-specific delete string from the supplied data

public

Parameters

string	the table name
array	the where clause
string	the limit clause

Returns: string

_error_message ( )

The error message string

private

Returns: string

_error_number ( )

The error message number

private

Returns: integer

_escape_identifiers ( $item)

Escape the SQL Identifiers

This function escapes column and table names

private

Parameters

string

Returns: string

_execute ( $sql)

Execute the query

private called by the base class

Parameters

string an SQL query

Returns: resource

_field_data ( $table)

Field data query

Generates a platform-specific query so that the column data can be retrieved

public

Parameters

string the table name

Returns: object

_from_tables ( $tables)

From Tables

This function implicitly groups FROM tables so there is no confusion about operator precedence in harmony with SQL standards

public

Parameters

type

Returns: type

_insert	(	$table,
		$keys,
		$values
	)

Insert statement

Generates a platform-specific insert string from the supplied data

public

Parameters

string	the table name
array	the insert keys
array	the insert values

Returns: string

_insert_batch	(	$table,
		$keys,
		$values
	)

Insert_batch statement

Generates a platform-specific insert string from the supplied data

public

Parameters

string	the table name
array	the insert keys
array	the insert values

Returns: string

_limit	(	$sql,
		$limit,
		$offset
	)

Limit string

Generates a platform-specific LIMIT clause

public

Parameters

string	the sql query string
integer	the number of rows to limit the query to
integer	the offset value

Returns: string

_list_columns ( $table = '')

Show column query

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

public

Parameters

string the table name

Returns: string

_list_tables ( $prefix_limit = FALSE)

List table query

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

private

Parameters

boolean

Returns: string

_prep_query ( $sql)

Prep the query

If needed, each database adapter can prep the query string

private called by execute()

Parameters

string an SQL query

Returns: string

_replace	(	$table,
		$keys,
		$values
	)

Replace statement

Generates a platform-specific replace string from the supplied data

public

Parameters

string	the table name
array	the insert keys
array	the insert values

Returns: string

_truncate ( $table)

Truncate statement

Generates a platform-specific truncate string from the supplied data If the database does not support the truncate() command This function maps to "DELETE FROM table"

public

Parameters

string the table name

Returns: string

_update	(	$table,
		$values,
		$where,
		$orderby = `array()`,
		$limit = `FALSE`
	)

Update statement

Generates a platform-specific update string from the supplied data

public

Parameters

string	the table name
array	the update data
array	the where clause
array	the orderby clause
array	the limit clause

Returns: string

_update_batch	(	$table,
		$values,
		$index,
		$where = `NULL`
	)

Update_Batch statement

Generates a platform-specific batch update string from the supplied data

public

Parameters

string	the table name
array	the update data
array	the where clause

Returns: string

_version ( )

Version number query string

public

Returns: string

affected_rows ( )

Affected Rows

public

Returns: integer

count_all ( $table = '')

"Count All" query

Generates a platform-specific query string that counts all records in the specified table

public

Parameters

string

Returns: string

db_connect ( )

Non-persistent database connection

private called by the base class

Returns: resource

db_pconnect ( )

Persistent database connection In CUBRID persistent DB connection is supported natively in CUBRID engine which can be configured in the CUBRID Broker configuration file by setting the CCI_PCONNECT parameter to ON. In that case, all connections established between the client application and the server will become persistent. This is calling the same function will establish persisten connection considering that the CCI_PCONNECT is ON.

private called by the base class

Returns: resource

db_select ( )

Select the database

private called by the base class

Returns: resource

db_set_charset	(	$charset,
		$collation
	)

Set client character set

public

Parameters

string
string

Returns: resource

escape_str	(	$str,
		$like = `FALSE`
	)

Escape String

public

Parameters

string
bool	whether or not the string will be used in a LIKE condition

Returns: string

insert_id ( )

Insert ID

public

Returns: integer

reconnect ( )

Reconnect

Keep / reestablish the db connection if no queries have been sent for a length of time exceeding the server's idle timeout

public

Returns: void

trans_begin ( $test_mode = FALSE)

Begin Transaction

public

Returns: bool

trans_commit ( )

Commit Transaction

public

Returns: bool

trans_rollback ( )

Rollback Transaction

public

Returns: bool

Field Documentation

$_count_string = 'SELECT COUNT(*) AS '

The syntax to count rows is slightly different across different database engines, so this string appears in each driver and is used for the count_all() and count_all_results() functions.

The documentation for this class was generated from the following file:

system/database/drivers/cubrid/cubrid_driver.php

Public Member Functions

Data Fields

Member Function Documentation

Field Documentation