DBMysqli Class Reference

Inheritance diagram for DBMysqli:

Public Member Functions
	__construct ($auto_connect=TRUE)
	create ()
	__connect ($connection)
	_close ($connection)
	addQuotes ($string)
	__query ($query, $connection)
	_prepareQueryParameters (&$types, &$params)
	_fetch ($result, $arrayIndexEndValue=NULL)
	_executeInsertAct ($queryObject, $with_values=false)
	_executeUpdateAct ($queryObject, $with_values=false)
	_executeDeleteAct ($queryObject, $with_values=false)
	_executeSelectAct ($queryObject, $connection=null, $with_values=false)
	db_insert_id ()
	db_fetch_object (&$result)
	db_free_result (&$result)
Public Member Functions inherited from DBMysql
	__construct ($auto_connect=TRUE)
	create ()
	__connect ($connection)
	_afterConnect ($connection)
	_close ($connection)
	addQuotes ($string)
	_begin ($transactionLevel=0)
	_rollback ($transactionLevel=0)
	_commit ()
	__query ($query, $connection)
	_fetch ($result, $arrayIndexEndValue=NULL)
	getNextSequence ()
	isValidOldPassword ($password, $saved_password)
	isTableExists ($target_name)
	addColumn ($table_name, $column_name, $type= 'number', $size= '', $default=null, $notnull=false)
	dropColumn ($table_name, $column_name)
	isColumnExists ($table_name, $column_name)
	addIndex ($table_name, $index_name, $target_columns, $is_unique=false)
	dropIndex ($table_name, $index_name, $is_unique=false)
	isIndexExists ($table_name, $index_name)
	createTableByXml ($xml_doc)
	createTableByXmlFile ($file_name)
	_createTable ($xml_doc)
	_executeInsertAct ($queryObject, $with_values=true)
	_executeUpdateAct ($queryObject, $with_values=true)
	_executeDeleteAct ($queryObject, $with_values=true)
	_executeSelectAct ($queryObject, $connection=null, $with_values=true)
	db_insert_id ()
	db_fetch_object (&$result)
	db_free_result (&$result)
&	getParser ($force=FALSE)
	queryError ($queryObject)
	queryPageLimit ($queryObject, $result, $connection, $with_values=true)
	getSelectPageSql ($query, $with_values=true, $start_count=0, $list_count=0)
Public Member Functions inherited from DB
	getInstance ($db_type=NULL)
	create ()
	__construct ()
	getSupportedList ()
	_getSupportedList ()
	_sortDBMS ($a, $b)
	isSupported ()
	isConnected ($type= 'master', $indx=0)
	actStart ($query)
	actFinish ()
	setQueryLog ($log)
	setError ($errno=0, $errstr= 'success')
	isError ()
	getError ()
	executeQuery ($query_id, $args=NULL, $arg_columns=NULL, $type=NULL)
	checkQueryCacheFile ($query_id, $xml_file)
	_executeQuery ($cache_file, $source_args, $query_id, $arg_columns, $type)
	getCountCache ($tables, $condition)
	putCountCache ($tables, $condition, $count=0)
	resetCountCache ($tables)
	dropTable ($table_name)
	getSelectSql ($query, $with_values=TRUE)
	getClickCountQuery ($queryObject)
	getDeleteSql ($query, $with_values=TRUE, $with_priority=FALSE)
	getUpdateSql ($query, $with_values=TRUE, $with_priority=FALSE)
	getInsertSql ($query, $with_values=TRUE, $with_priority=FALSE)
	_getSlaveConnectionStringIndex ()
	_getConnection ($type= 'master', $indx=NULL)
	_dbInfoExists ()
	_close ($connection)
	close ($type= 'master', $indx=0)
	_begin ($transactionLevel=0)
	begin ()
	_rollback ($transactionLevel=0)
	rollback ()
	_commit ()
	commit ($force=FALSE)
	__query ($query, $connection)
	_query ($query, $connection=NULL)
	_setDBInfo ()
	__connect ($connection)
	_afterConnect ($connection)
	_connect ($type= 'master', $indx=0)
	actDBClassStart ()
	actDBClassFinish ()
	getParser ($force=FALSE)

Additional Inherited Members
Static Public Member Functions inherited from DB
static	getEnableList ()
static	getDisableList ()
Public Attributes inherited from DBMysql
	$prefix = 'xe_'
	$comment_syntax = '/* %s */'
	$column_type
Public Attributes inherited from DB
	$priority_dbms
	$count_cache_path = 'files/cache/db'
	$cond_operation
	$master_db = NULL
	$slave_db = NULL
	$result = NULL
	$errno = 0
	$errstr = ''
	$query = ''
	$connection = ''
	$elapsed_time = 0
	$elapsed_dbclass_time = 0
	$transaction_started = FALSE
	$is_connected = FALSE
	$cache_file = 'files/cache/queries/'
	$db_type
	$use_prepared_statements
Static Public Attributes inherited from DB
static	$isSupported = FALSE
static	$supported_list = array()

Detailed Description

Definition at line 16 of file DBMysqli.class.php.

Constructor & Destructor Documentation

DBMysqli::__construct

(

$auto_connect = TRUE

)

Constructor

Returns

void

Definition at line 23 of file DBMysqli.class.php.

Member Function Documentation

DBMysqli::__connect

(

$connection

)

DB Connect this method is private

Parameters

array

$connection

connection's value is db_hostname, db_port, db_database, db_userid, db_password

Returns

resource

Definition at line 44 of file DBMysqli.class.php.

DBMysqli::__query	(		$query,
			$connection
	)

Execute the query this method is private

Parameters

string	$query
resource	$connection

Returns

resource

Definition at line 109 of file DBMysqli.class.php.

DBMysqli::_close

(

$connection

)

DB disconnection this method is private

Parameters

resource

$connection

Returns

void

Definition at line 78 of file DBMysqli.class.php.

DBMysqli::_executeDeleteAct	(		$queryObject,
			$with_values = false
	)

Handles deleteAct

Parameters

BaseObject	$queryObject
boolean	$with_values

Returns

resource

Definition at line 367 of file DBMysqli.class.php.

DBMysqli::_executeInsertAct	(		$queryObject,
			$with_values = false
	)

Handles insertAct

Parameters

BaseObject	$queryObject
boolean	$with_values

Returns

resource

Definition at line 331 of file DBMysqli.class.php.

DBMysqli::_executeSelectAct	(		$queryObject,
			$connection = null,
			$with_values = false
	)

Handle selectAct In order to get a list of pages easily when selecting
it supports a method as navigation

Parameters

BaseObject	$queryObject
resource	$connection
boolean	$with_values

Returns

BaseObject

Definition at line 388 of file DBMysqli.class.php.

DBMysqli::_executeUpdateAct	(		$queryObject,
			$with_values = false
	)

Handles updateAct

Parameters

BaseObject	$queryObject
boolean	$with_values

Returns

resource

Definition at line 349 of file DBMysqli.class.php.

DBMysqli::_fetch	(		$result,
			$arrayIndexEndValue = NULL
	)

Fetch the result

Parameters

resource	$result
int | NULL	$arrayIndexEndValue

Returns

array

Mysqli has a bug that causes LONGTEXT columns not to get loaded Unless store_result is called before MYSQLI_TYPE for longtext is 252

Definition at line 227 of file DBMysqli.class.php.

DBMysqli::_prepareQueryParameters	(	&	$types,
		&	$params
	)

Before execute query, prepare statement this method is private

Parameters

string	$types
array	$params

Returns

void

Definition at line 173 of file DBMysqli.class.php.

DBMysqli::addQuotes

(

$string

)

Handles quatation of the string variables from the query

Parameters

string

$string

Returns

string

Definition at line 88 of file DBMysqli.class.php.

DBMysqli::create

(

)

Create an instance of this class

Returns

DBMysqli return DBMysqli object instance

Definition at line 33 of file DBMysqli.class.php.

DBMysqli::db_fetch_object

(

&

$result

)

Fetch a result row as an object

Parameters

resource

$result

Returns

object

Definition at line 417 of file DBMysqli.class.php.

DBMysqli::db_free_result

(

&

$result

)

Free result memory

Parameters

resource

$result

Returns

boolean Returns TRUE on success or FALSE on failure.

Definition at line 427 of file DBMysqli.class.php.

DBMysqli::db_insert_id

(

)

Get the ID generated in the last query Return next sequence from sequence table This method use only mysql

Returns

int

Definition at line 406 of file DBMysqli.class.php.

---

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

• classes/db/DBMysqli.class.php