XpressEngine Core  1.11.2
 All Classes Namespaces Files Functions Variables Pages
Public Member Functions | List of all members
DBMysqli_innodb Class Reference
Inheritance diagram for DBMysqli_innodb:
DBMysql DB

Public Member Functions

 __construct ($auto_connect=TRUE)
 
 create ()
 
 __connect ($connection)
 
 _close ($connection)
 
 _begin ($transactionLevel=0)
 
 _rollback ($transactionLevel=0)
 
 _commit ()
 
 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)
 
 _createTable ($xml_doc)
 
- 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_innodb.class.php.

Constructor & Destructor Documentation

DBMysqli_innodb::__construct (   $auto_connect = TRUE)

Constructor

Returns
void

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

Member Function Documentation

DBMysqli_innodb::__connect (   $connection)

DB Connect this method is private

Parameters
array$connectionconnection's value is db_hostname, db_port, db_database, db_userid, db_password
Returns
resource

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

DBMysqli_innodb::__query (   $query,
  $connection 
)

Execute the query this method is private

Parameters
string$query
resource$connection
Returns
resource

Definition at line 167 of file DBMysqli_innodb.class.php.

DBMysqli_innodb::_begin (   $transactionLevel = 0)

DB transaction start this method is private

Returns
boolean

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

DBMysqli_innodb::_close (   $connection)

DB disconnection this method is private

Parameters
resource$connection
Returns
void

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

DBMysqli_innodb::_commit ( )

DB transaction commit this method is private

Returns
boolean

Definition at line 131 of file DBMysqli_innodb.class.php.

DBMysqli_innodb::_createTable (   $xml_doc)

Create table by using the schema xml

type : number, varchar, tinytext, text, bigtext, char, date,
opt : notnull, default, size
index : primary key, index, unique

Parameters
string$xml_docxml schema contents
Returns
void|object

Definition at line 499 of file DBMysqli_innodb.class.php.

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

Handles deleteAct

Parameters
BaseObject$queryObject
boolean$with_values
Returns
resource

Definition at line 425 of file DBMysqli_innodb.class.php.

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

Handles insertAct

Parameters
BaseObject$queryObject
boolean$with_values
Returns
resource

Definition at line 389 of file DBMysqli_innodb.class.php.

DBMysqli_innodb::_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 446 of file DBMysqli_innodb.class.php.

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

Handles updateAct

Parameters
BaseObject$queryObject
boolean$with_values
Returns
resource

Definition at line 407 of file DBMysqli_innodb.class.php.

DBMysqli_innodb::_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 285 of file DBMysqli_innodb.class.php.

DBMysqli_innodb::_prepareQueryParameters ( $types,
$params 
)

Before execute query, prepare statement this method is private

Parameters
string$types
array$params
Returns
void

Definition at line 231 of file DBMysqli_innodb.class.php.

DBMysqli_innodb::_rollback (   $transactionLevel = 0)

DB transaction rollback this method is private

Returns
boolean

Definition at line 108 of file DBMysqli_innodb.class.php.

DBMysqli_innodb::addQuotes (   $string)

Handles quatation of the string variables from the query

Parameters
string$string
Returns
string

Definition at line 146 of file DBMysqli_innodb.class.php.

DBMysqli_innodb::create ( )

Create an instance of this class

Returns
DBMysqli_innodb return DBMysqli_innodb object instance

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

DBMysqli_innodb::db_fetch_object ( $result)

Fetch a result row as an object

Parameters
resource$result
Returns
object

Definition at line 475 of file DBMysqli_innodb.class.php.

DBMysqli_innodb::db_free_result ( $result)

Free result memory

Parameters
resource$result
Returns
boolean Returns TRUE on success or FALSE on failure.

Definition at line 485 of file DBMysqli_innodb.class.php.

DBMysqli_innodb::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 464 of file DBMysqli_innodb.class.php.


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