Docs for class JDatabaseMySQLi

Joomla! 1.5 API

Packages

Package: Joomla-Framework

License

Content on this site is copyright © 2005 - 2011 Open Source Matters Inc and can be used in accordance with the Joomla! Electronic Documentation License. Some parts of this website may be subject to other licenses.

JDatabaseMySQLi

Description

MySQLi database driver

since: 1.0

Located in /joomla/database/database/mysqli.php (line 25)

 JObject   (Subpackage Base)

 JDatabase
   
    JDatabaseMySQLi   (Subpackage Database)

Variable Summary

string $name

string $_nameQuote

string $_nullDate

Method Summary

static boolean test ()

JDatabaseMySQLi __construct (array $options)

boolean __destruct ()

boolean connected ()

string explain ()

int getAffectedRows ()

string getCollation ()

string getEscaped (string $text, [boolean $extra = false])

int getNumRows ([ $cur = null])

array getTableCreate (array|string $tables)

array getTableFields (array|string $tables, [boolean $typeonly = true])

array getTableList ()

void getVersion ()

boolean hasUTF ()

void insertid ()

void insertObject (string $table, object An &$object, [string $keyName = NULL])

array loadAssoc ()

array loadAssocList ([string $key = ''])

object loadObject ()

array loadObjectList ([string $key = ''])

The loadResult ()

void loadResultArray ([ $numinarray = 0])

The loadRow ()

array loadRowList ([string $key = null])

mixed query ()

mixed queryBatch ([ $abort_on_error = true], [ $p_transaction_safe = false])

boolean select (string $database)

void setUTF ()

void updateObject ( $table, &$object, $keyName, [[type] $updateNulls = true])

Variables

string $name = 'mysqli' (line 32)

The database driver name

Redefinition of:

JDatabase::$name: The database driver name

string $_nameQuote = '`' (line 46)

Quote for named objects

Redefinition of:

JDatabase::$_nameQuote: Quote for named objects

string $_nullDate = '0000-00-00 00:00:00' (line 39)

The null/zero date string

Redefinition of:

JDatabase::$_nullDate: The null/zero date string

Inherited Variables

Inherited from JDatabase

JDatabase::$_cursor
JDatabase::$_debug
JDatabase::$_errorMsg
JDatabase::$_errorNum
JDatabase::$_hasQuoted
JDatabase::$_limit
JDatabase::$_log
JDatabase::$_offset
JDatabase::$_quoted
JDatabase::$_resource
JDatabase::$_sql
JDatabase::$_table_prefix
JDatabase::$_ticker
JDatabase::$_utf

Inherited from JObject

JObject::$_errors

Methods

Constructor __construct (line 56)

Database object constructor

see: JDatabase
since: 1.5
access: public

JDatabaseMySQLi __construct (array $options)

array $options: List of options used to configure the connection

Redefinition of:

JDatabase::__construct(): Database object constructor

Destructor __destruct (line 114)

Database object destructor

since: 1.5

boolean __destruct ()

connected (line 142)

Determines if the connection to the server is active.

since: 1.5
access: public

boolean connected ()

Redefinition of:

JDatabase::connected(): Determines if the connection to the server is active.

explain (line 317)

Diagnostic function

access: public

string explain ()

Redefinition of:

JDatabase::explain(): Diagnostic function

getAffectedRows (line 261)

Description

return: The number of affected rows in the previous operation
since: 1.0.5
access: public

int getAffectedRows ()

Redefinition of:

JDatabase::getAffectedRows(): Get the affected rows by the most recent query

getCollation (line 628)

Assumes database collation in use by sampling one text field in one table

return: Collation in use
access: public

string getCollation ()

Redefinition of:

JDatabase::getCollation(): Get the database collation

getEscaped (line 208)

Get a database escaped string

abstract:
access: public

string getEscaped (string $text, [boolean $extra = false])

string $text: The string to be escaped
boolean $extra: Optional parameter to provide extra escaping

Redefinition of:

JDatabase::getEscaped(): Get a database escaped string

getNumRows (line 358)

Description

return: The number of rows returned from the most recent query.
access: public

int getNumRows ([ $cur = null])

$cur

Redefinition of:

JDatabase::getNumRows(): Get the number of rows returned by the most recent query

getTableCreate (line 658)

Shows the CREATE TABLE statement that creates the given tables

return: A list the create SQL for the tables
access: public

array getTableCreate (array|string $tables)

array|string $tables: A table name or a list of table names

Redefinition of:

JDatabase::getTableCreate(): Shows the CREATE TABLE statement that creates the given tables

getTableFields (line 683)

Retrieves information about the given tables

return: An array of fields by table
access: public

array getTableFields (array|string $tables, [boolean $typeonly = true])

array|string $tables: A table name or a list of table names
boolean $typeonly: Only return field types, default true

Redefinition of:

JDatabase::getTableFields(): Retrieves information about the given tables

getTableList (line 645)

Description

return: A list of all the tables in the database
access: public

array getTableList ()

Redefinition of:

JDatabase::getTableList(): List tables in a database

getVersion (line 617)

Description

access: public

void getVersion ()

Redefinition of:

JDatabase::getVersion(): Get the version of the database connector

hasUTF (line 183)

Determines UTF support

return: True - UTF is supported
access: public

boolean hasUTF ()

Redefinition of:

JDatabase::hasUTF(): Determines UTF support

insertid (line 607)

Description

access: public

void insertid ()

Redefinition of:

JDatabase::insertid(): Get the ID generated from the previous INSERT operation

insertObject (line 543)

Inserts a row into a table based on an objects properties

access: public

void insertObject (string $table, object An &$object, [string $keyName = NULL])

string $table: The name of the table
object An &$object: object whose properties match table fields
string $keyName: The name of the primary key. If provided the object property is updated.

Redefinition of:

JDatabase::insertObject(): Inserts a row into a table based on an objects properties

loadAssoc (line 406)

Fetch a result row as an associative array

access: public

array loadAssoc ()

Redefinition of:

JDatabase::loadAssoc(): Fetch a result row as an associative array

loadAssocList (line 426)

Load a assoc list of database rows

return: If key is empty as sequential list of returned records.
access: public

array loadAssocList ([string $key = ''])

string $key: The field name of a primary key

Redefinition of:

JDatabase::loadAssocList(): Load a associactive list of database rows

loadObject (line 449)

This global function loads the first row of a query into an object

access: public

object loadObject ()

Redefinition of:

JDatabase::loadObject(): This global function loads the first row of a query into an object

loadObjectList (line 472)

Load a list of database objects

If key is not empty then the returned array is indexed by the value the database key. Returns null if the query fails.

return: If key is empty as sequential list of returned records.
access: public

array loadObjectList ([string $key = ''])

string $key: The field name of a primary key

Redefinition of:

JDatabase::loadObjectList(): Load a list of database objects

loadResult (line 369)

This method loads the first field of the first row returned by the query.

return: value returned in the query or null if the query failed.
access: public

The loadResult ()

Redefinition of:

JDatabase::loadResult(): This method loads the first field of the first row returned by the query.

loadResultArray (line 387)

Load an array of single field results into an array

access: public

void loadResultArray ( $numinarray)

$numinarray

Redefinition of:

JDatabase::loadResultArray(): Load an array of single field results into an array

loadRow (line 495)

Description

return: first row of the query.
access: public

The loadRow ()

Redefinition of:

JDatabase::loadRow(): Load the first row returned by the query

loadRowList (line 518)

Load a list of database rows (numeric column indexing)

If key is not empty then the returned array is indexed by the value the database key. Returns null if the query fails.

return: If key is empty as sequential list of returned records.
access: public

array loadRowList ([string $key = null])

string $key: The field name of a primary key

Redefinition of:

JDatabase::loadRowList(): Load a list of database rows (numeric column indexing)

query (line 222)

Execute the query

return: A database resource if successful, FALSE if not.
access: public

mixed query ()

Redefinition of:

JDatabase::query(): Execute the query

queryBatch (line 272)

Execute a batch query

return: A database resource if successful, FALSE if not.
access: public

mixed queryBatch ([ $abort_on_error = true], [ $p_transaction_safe = false])

$abort_on_error
$p_transaction_safe

Redefinition of:

JDatabase::queryBatch(): Execute a batch query

select (line 155)

Select a database for use

return: True if the database has been successfully selected
since: 1.5
access: public

boolean select (string $database)

string $database

setUTF (line 194)

Custom settings for UTF support

access: public

void setUTF ()

Redefinition of:

JDatabase::setUTF(): Custom settings for UTF support

test (line 130)

Test to see if the MySQLi connector is available

return: True on success, false otherwise.
access: public

boolean test ()

Redefinition of:

JDatabase::test(): Test to see if the MySQLi connector is available

updateObject (line 574)

Description

access: public

void updateObject ( $table, &$object, $keyName, [[type] $updateNulls = true])

[type] $updateNulls
$table
&$object
$keyName

Redefinition of:

JDatabase::updateObject(): Update an object in the database

Inherited Methods

Inherited From JDatabase

JDatabase::__construct()
JDatabase::addQuoted()
JDatabase::BeginTrans()
JDatabase::CommitTrans()
JDatabase::connected()
JDatabase::debug()
JDatabase::ErrorMsg()
JDatabase::ErrorNo()
JDatabase::Execute()
JDatabase::explain()
JDatabase::GenID()
JDatabase::getAffectedRows()
JDatabase::GetCol()
JDatabase::getCollation()
JDatabase::getConnectors()
JDatabase::getErrorMsg()
JDatabase::getErrorNum()
JDatabase::getEscaped()
JDatabase::getInstance()
JDatabase::getLog()
JDatabase::getNullDate()
JDatabase::getNumRows()
JDatabase::GetOne()
JDatabase::getPrefix()
JDatabase::getQuery()
JDatabase::GetRow()
JDatabase::getTableCreate()
JDatabase::getTableFields()
JDatabase::getTableList()
JDatabase::getTicker()
JDatabase::getUTFSupport()
JDatabase::getVersion()
JDatabase::hasUTF()
JDatabase::insertid()
JDatabase::insertObject()
JDatabase::isQuoted()
JDatabase::loadAssoc()
JDatabase::loadAssocList()
JDatabase::loadObject()
JDatabase::loadObjectList()
JDatabase::loadResult()
JDatabase::loadResultArray()
JDatabase::loadRow()
JDatabase::loadRowList()
JDatabase::nameQuote()
JDatabase::PageExecute()
JDatabase::query()
JDatabase::queryBatch()
JDatabase::Quote()
JDatabase::replacePrefix()
JDatabase::RollbackTrans()
JDatabase::SelectLimit()
JDatabase::setQuery()
JDatabase::setUTF()
JDatabase::splitSql()
JDatabase::stderr()
JDatabase::test()
JDatabase::updateObject()

Inherited From JObject

JObject::JObject()
JObject::__construct()
JObject::get()
JObject::getError()
JObject::getErrors()
JObject::getProperties()
JObject::getPublicProperties()
JObject::set()
JObject::setError()
JObject::setProperties()
JObject::toString()

Joomla! 1.5 API

Packages

Package: Joomla-Framework

Other documents

License

JDatabaseMySQLi

Inherited Variables

Inherited Methods

Joomla!

News

Sites

About

Get Started

About

Project Organization

Forum

Support Forums

Development

Sites

Forum General

Community

Joomla!

News

User Groups

Events

Translations

Directories

Extensions

Resources

Site Showcase

Developer

Resources

Production WG

Mailing Lists

Joomlacode

Shop

Merchandise

Books

Documentation

For Everyone

For Beginners

For Designers

Personae

Be a Documenter