CI_DB_mssql_driver Class Reference

Inheritance diagram for CI_DB_mssql_driver:

Public Member Functions
	db_connect ()
	db_pconnect ()
	reconnect ()
	db_select ()
	db_set_charset ($charset, $collation)
	_execute ($sql)
	_prep_query ($sql)
	trans_begin ($test_mode=FALSE)
	trans_commit ()
	trans_rollback ()
	escape_str ($str, $like=FALSE)
	affected_rows ()
	insert_id ()
	_parse_major_version ($version)
	_version ()
	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)
	_update ($table, $values, $where, $orderby=array(), $limit=FALSE)
	_truncate ($table)
	_delete ($table, $where=array(), $like=array(), $limit=FALSE)
	_limit ($sql, $limit, $offset)
	_close ($conn_id)

Data Fields
	$dbdriver = 'mssql'
	$_escape_char = ''
	$_like_escape_str = " ESCAPE '%s' "
	$_like_escape_chr = '!'
	$_count_string = "SELECT COUNT(*) AS "
	$_random_keyword = ' ASC'

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

_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 = '')

List column query

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

private

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

_parse_major_version

(

$version)

Parse major version

Grabs the major version number from the database server version string passed in.

private

Parameters

string

$version

Returns

int16 major version number

_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

_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

_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 database

public

Parameters

string

Returns

string

db_connect

(

)

Non-persistent database connection

private called by the base class

Returns

resource

db_pconnect

(

)

Persistent database connection

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

Returns the last id created in the Identity column.

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/mssql/mssql_driver.php