Docs For Class ilance

Description

MySQLi database class to perform the majority of database related functions in ILance.

author: ILance
version: $Revision: 1.0.0 $

Located in /api/class.database_mysqli.inc.php (line 29)

ilance_database
   |
   --ilance_mysqli

Variable Summary

mixed $functions

mixed $types

Method Summary

ilance_mysqli ilance_mysqli ( &$registry, [ $cachetimeout = 1], [ $cachetodatabase = true])

nothing affected_rows ()

nothing close ()

void db_connect ()

nothing errno ()

nothing error ()

nothing escape_string ([string $query = ''])

void fetch_array ( &$query, [ $type = DB_BOTH])

void fetch_assoc ( &$query, [ $type = DB_ASSOC])

void fetch_field ([ $tbl = ''], [ $condition = ''], [ $field = ''], [ $limit = ''])

nothing fetch_object (string &$query)

void fetch_row ( &$query)

void field_name ([ $query = ''])

nothing free_result ([string $res = ''])

nothing insert_id ()

void num_fields ([ $query = ''])

void num_rows ([ $query = ''])

void query ([ $string = ''], [ $hideerrors = 0], [ $enablecache = null], [ $script = ''], [ $line = ''], [ $buffered = true], [ $errorexempt = array()])

void query_fetch ( $string, [ $hideerrors = 0], [ $enablecache = null], [ $script = ''], [ $line = ''], [ $buffered = true])

void select_db_wrapper ([ $database = ''], [ $link = null])

Variables

mixed $functions = array(
'select_db' => 'mysqli_select_db',
'pconnect' => 'mysqli_real_connect',
'connect' => 'mysqli_real_connect',
'query' => 'mysqli_query',
'query_unbuffered' => 'mysqli_unbuffered_query',
'fetch_row' => 'mysqli_fetch_row',
'fetch_object' => 'mysqli_fetch_object',
'fetch_array' => 'mysqli_fetch_array',
'fetch_field' => 'mysqli_fetch_field',
'free_result' => 'mysqli_free_result',
'data_seek' => 'mysqli_data_seek',
'error' => 'mysqli_error',
'errno' => 'mysqli_errno',
'affected_rows' => 'mysqli_affected_rows',
'num_rows' => 'mysqli_num_rows',
'num_fields' => 'mysqli_num_fields',
'field_name' => 'mysqli_field_name',
'insert_id' => 'mysqli_insert_id',
'list_tables' => 'mysqli_list_tables',
'list_fields' => 'mysqli_list_fields',
'escape_string' => 'mysqli_real_escape_string',
'real_escape_string' => 'mysqli_real_escape_string',
'close' => 'mysqli_close',
'client_encoding' => 'mysqli_client_encoding',
'create_db' => 'mysqli_create_db',
'ping' => 'mysqli_ping',
'free_result' => 'mysqli_free_result'
) (line 47)

mixed $types = array(
DB_NUM => MYSQLI_NUM,
DB_ASSOC => MYSQLI_ASSOC,
DB_BOTH => MYSQLI_BOTH
) (line 36)

Inherited Variables

Inherited from ilance_database

ilance_database::$connection_link
ilance_database::$connection_read
ilance_database::$connection_write
ilance_database::$database
ilance_database::$debug
ilance_database::$email_reporting
ilance_database::$end
ilance_database::$errno
ilance_database::$error
ilance_database::$error_reporting
ilance_database::$explain
ilance_database::$formatted
ilance_database::$multiserver
ilance_database::$querylist
ilance_database::$query_count
ilance_database::$registry
ilance_database::$start
ilance_database::$totaltime
ilance_database::$ttquery

Methods

Constructor ilance_mysqli (line 84)

ilance_mysqli ilance_mysqli ( &$registry, [ $cachetimeout = 1], [ $cachetodatabase = true])

&$registry
$cachetimeout
$cachetodatabase

affected_rows (line 284)

Function to fetch the total number of affected rows for the connection

nothing affected_rows ()

close (line 372)

Function to close the database connection

nothing close ()

db_connect (line 99)

void db_connect ()

errno (line 393)

Function to mimic database error number handling

nothing errno ()

error (line 382)

Function to mimic database error handling

nothing error ()

escape_string (line 406)

Function to execute xxxx_real_escape_string()

nothing escape_string ([string $query = ''])

string $query: sql code

fetch_array (line 237)

void fetch_array ( &$query, [ $type = DB_BOTH])

&$query
$type

fetch_assoc (line 262)

void fetch_assoc ( &$query, [ $type = DB_ASSOC])

&$query
$type

fetch_field (line 298)

void fetch_field ([ $tbl = ''], [ $condition = ''], [ $field = ''], [ $limit = ''])

$tbl
$condition
$field
$limit

fetch_object (line 249)

Function to perform a database fetch object

nothing fetch_object (string &$query)

string &$query: sql code

fetch_row (line 274)

void fetch_row ( &$query)

&$query

field_name (line 352)

void field_name ([ $query = ''])

$query

free_result (line 418)

Function to frees the memory associated with a result

nothing free_result ([string $res = ''])

string $res: sql result

insert_id (line 362)

Function to fetch the last insert id for the database connection

nothing insert_id ()

num_fields (line 340)

void num_fields ([ $query = ''])

$query

num_rows (line 320)

void num_rows ([ $query = ''])

$query

query (line 156)

void query ([ $string = ''], [ $hideerrors = 0], [ $enablecache = null], [ $script = ''], [ $line = ''], [ $buffered = true], [ $errorexempt = array()])

$string
$hideerrors
$enablecache
$script
$line
$buffered
$errorexempt

query_fetch (line 207)

void query_fetch ( $string, [ $hideerrors = 0], [ $enablecache = null], [ $script = ''], [ $line = ''], [ $buffered = true])

$string
$hideerrors
$enablecache
$script
$line
$buffered

select_db_wrapper (line 140)

void select_db_wrapper ([ $database = ''], [ $link = null])

$database
$link

Inherited Methods

Inherited From ilance_database

ilance_database::ilance_database()
ilance_database::add()
ilance_database::add_field_if_not_exist()
ilance_database::change_field_if_not_exist()
ilance_database::connect()
ilance_database::dberror()
ilance_database::explain_query()
ilance_database::field_exists()
ilance_database::format()
ilance_database::gettime()
ilance_database::query_cache()
ilance_database::remove()
ilance_database::select_db()
ilance_database::stop()
ilance_database::table_exists()
ilance_database::timer()

Class ilance_mysqli

Inherited Variables

Inherited Methods