Graphe d'héritage de JDatabaseDriverMysql:

Fonctions membres publiques
	__construct ($options)

	connect ()

	disconnect ()

	escape ($text, $extra=false)

	connected ()

	getAffectedRows ()

	getNumRows ($cursor=null)

	getVersion ()

	insertid ()

	execute ()

	select ($database)

	setUtf ()

Fonctions membres publiques hérités de JDatabaseDriverMysqli
	__construct ($options)

	connect ()

	disconnect ()

	escape ($text, $extra=false)

	connected ()

	dropTable ($tableName, $ifExists=true)

	getAffectedRows ()

	getCollation ()

	getConnectionCollation ()

	getNumRows ($cursor=null)

	getTableCreate ($tables)

	getTableColumns ($table, $typeOnly=true)

	getTableKeys ($table)

	getTableList ()

	getVersion ()

	insertid ()

	lockTable ($table)

	execute ()

	renameTable ($oldTable, $newTable, $backup=null, $prefix=null)

	select ($database)

	setUtf ()

	transactionCommit ($toSavepoint=false)

	transactionRollback ($toSavepoint=false)

	transactionStart ($asSavepoint=false)

	unlockTables ()

Fonctions membres publiques hérités de JDatabaseDriver
	__call ($method, $args)

	__construct ($options)

	alterDbCharacterSet ($dbName)

	alterTableCharacterSet ($tableName, $rethrow=false)

	connect ()

	connected ()

	createDatabase ($options, $utf=true)

	__destruct ()

	disconnect ()

	addDisconnectHandler ($callable)

	dropTable ($table, $ifExists=true)

	escape ($text, $extra=false)

	getAffectedRows ()

	getAlterDbCharacterSet ($dbName)

	getAlterTableCharacterSet ($tableName)

	convertUtf8mb4QueryToUtf8 ($query)

	getCollation ()

	getConnectionCollation ()

	getConnection ()

	getCount ()

	getDateFormat ()

	getLog ()

	getTimings ()

	getCallStacks ()

	getMinimum ()

	getNullDate ()

	getNumRows ($cursor=null)

	getPrefix ()

	getExporter ()

	getImporter ()

	getName ()

	getServerType ()

	getQuery ($new=false)

	getIterator ($column=null, $class='stdClass')

	getTableColumns ($table, $typeOnly=true)

	getTableCreate ($tables)

	getTableKeys ($table)

	getTableList ()

	getUTFSupport ()

	hasUTFSupport ()

	hasUTF8mb4Support ()

	getVersion ()

	insertid ()

	insertObject ($table, &$object, $key=null)

	isMinimumVersion ()

	loadAssoc ()

	loadAssocList ($key=null, $column=null)

	loadColumn ($offset=0)

	loadNextObject ($class='stdClass')

	loadNextRow ()

	loadObject ($class='stdClass')

	loadObjectList ($key='', $class='stdClass')

	loadResult ()

	loadRow ()

	loadRowList ($index=null)

	lockTable ($tableName)

	quote ($text, $escape=true)

	quoteBinary ($data)

	quoteName ($name, $as=null)

	replacePrefix ($sql, $prefix='#__')

	renameTable ($oldTable, $newTable, $backup=null, $prefix=null)

	select ($database)

	setDebug ($level)

	setQuery ($query, $offset=0, $limit=0)

	setUtf ()

	transactionCommit ($toSavepoint=false)

	transactionRollback ($toSavepoint=false)

	transactionStart ($asSavepoint=false)

	truncateTable ($table)

	updateObject ($table, &$object, $key, $nulls=false)

	execute ()

	unlockTables ()

Fonctions membres publiques hérités de JDatabase
	query ()

	getErrorMsg ($escaped=false)

	getErrorNum ()

	stderr ($showSQL=false)

Fonctions membres publiques statiques
static	isSupported ()

Fonctions membres publiques statiques hérités de JDatabaseDriverMysqli
static	isSupported ()

Fonctions membres publiques statiques hérités de JDatabaseDriver
static	getConnectors ()

static	getInstance ($options=array())

static	splitSql ($sql)

Fonctions membres publiques statiques hérités de JDatabase
static	getConnectors ()

static	getInstance ($options=array())

static	splitSql ($query)

static	test ()

Champs de données
	$name = 'mysql'

Champs de données hérités de JDatabaseDriverMysqli
	$name = 'mysqli'

	$serverType = 'mysql'

Champs de données hérités de JDatabaseDriver
	$name

	$serverType

Fonctions membres protégées
	fetchArray ($cursor=null)

	fetchAssoc ($cursor=null)

	fetchObject ($cursor=null, $class='stdClass')

	freeResult ($cursor=null)

	getErrorNumber ()

	getErrorMessage ()

Fonctions membres protégées hérités de JDatabaseDriverMysqli
	fetchArray ($cursor=null)

	fetchAssoc ($cursor=null)

	fetchObject ($cursor=null, $class='stdClass')

	freeResult ($cursor=null)

	getErrorNumber ()

	getErrorMessage ()

Fonctions membres protégées hérités de JDatabaseDriver
	fetchArray ($cursor=null)

	fetchAssoc ($cursor=null)

	fetchObject ($cursor=null, $class='stdClass')

	freeResult ($cursor=null)

	getCreateDatabaseQuery ($options, $utf)

	getDatabase ()

	quoteNameStr ($strArr)

Fonctions membres privées
	hasProfiling ()

	hasQueryCacheEnabled ()

	serverClaimsUtf8mb4Support ()

Membres hérités additionnels
Attributs protégés hérités de JDatabaseDriverMysqli
	$connection

	$nameQuote = '`'

	$nullDate = '0000-00-00 00:00:00'

Attributs protégés hérités de JDatabaseDriver
	$connection

	$count = 0

	$cursor

	$debug = false

	$limit = 0

	$log = array()

	$timings = array()

	$callStacks = array()

	$nameQuote

	$nullDate

	$offset = 0

	$options

	$sql

	$tablePrefix

	$utf = true

	$utf8mb4 = false

	$errorNum = 0

	$errorMsg

	$transactionDepth = 0

	$disconnectHandlers = array()

Attributs protégés statiques hérités de JDatabaseDriverMysqli
static	$dbMinimum = '5.0.4'

Attributs protégés statiques hérités de JDatabaseDriver
static	$instances = array()

static	$dbMinimum

Description détaillée

MySQL database driver

3.0.0 deprecated 269.

Documentation des constructeurs et destructeur

◆ __construct()

__construct ( $options )

Constructor.

Paramètres

array $options Array of database options with keys: host, user, password, database, select.

Depuis: 3.0.0

Références $options.

Documentation des fonctions membres

◆ connect()

connect ( )

Connects to the database if needed.

Renvoie: void Returns void if the database connected successfully.

Depuis: 3.0.0

Exceptions

RuntimeException

◆ connected()

connected ( )

Determines if the connection to the server is active.

Renvoie: boolean True if connected to the database engine.

Depuis: 3.0.0

◆ disconnect()

disconnect ( )

Disconnects the database.

Renvoie: void

Depuis: 3.0.0

Références null.

◆ escape()

escape	(	$text,
		$extra = `false`
	)

Method to escape a string for usage in an SQL statement.

Paramètres

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

Renvoie: string The escaped string.

Depuis: 3.0.0

Références $text.

◆ execute()

execute ( )

Execute the SQL statement.

Renvoie: mixed A database cursor resource on success, boolean false on failure.

Depuis: 3.0.0

Exceptions

RuntimeException

Références $limit, $query, et null.

◆ fetchArray()

fetchArray ( $cursor = null )

protected

Method to fetch a row from the result set cursor as an array.

Paramètres

mixed $cursor The optional result set cursor from which to fetch the row.

Renvoie: mixed Either the next row from the result set or false if there are no more rows.

Depuis: 3.0.0

◆ fetchAssoc()

fetchAssoc ( $cursor = null )

protected

Method to fetch a row from the result set cursor as an associative array.

Paramètres

mixed $cursor The optional result set cursor from which to fetch the row.

Renvoie: mixed Either the next row from the result set or false if there are no more rows.

Depuis: 3.0.0

◆ fetchObject()

fetchObject	(	$cursor = `null`,
		$class = `'stdClass'`
	)

protected

Method to fetch a row from the result set cursor as an object.

Paramètres

mixed	$cursor	The optional result set cursor from which to fetch the row.
string	$class	The class name to use for the returned row object.

Renvoie: mixed Either the next row from the result set or false if there are no more rows.

Depuis: 3.0.0

Références $class.

◆ freeResult()

freeResult ( $cursor = null )

protected

Method to free up the memory used for the result set.

Paramètres

mixed $cursor The optional result set cursor from which to fetch the row.

Renvoie: void

Depuis: 3.0.0

◆ getAffectedRows()

getAffectedRows ( )

Get the number of affected rows by the last INSERT, UPDATE, REPLACE or DELETE for the previous executed SQL statement.

Renvoie: integer The number of affected rows.

Depuis: 3.0.0

◆ getErrorMessage()

getErrorMessage ( )

protected

Return the actual SQL Error message

Renvoie: string The SQL Error message

Depuis: 3.4.6

◆ getErrorNumber()

getErrorNumber ( )

protected

Return the actual SQL Error number

Renvoie: integer The SQL Error number

Depuis: 3.4.6

◆ getNumRows()

getNumRows ( $cursor = null )

Get the number of returned rows for the previous executed SQL statement. This command is only valid for statements like SELECT or SHOW that return an actual result set. To retrieve the number of rows affected by an INSERT, UPDATE, REPLACE or DELETE query, use getAffectedRows().

Paramètres

resource $cursor An optional database cursor resource to extract the row count from.

Renvoie: integer The number of returned rows.

Depuis: 3.0.0

◆ getVersion()

getVersion ( )

Get the version of the database connector.

Renvoie: string The database connector version.

Depuis: 3.0.0

◆ hasProfiling()

hasProfiling ( )

private

Internal function to check if profiling is available

Renvoie: boolean

Depuis: 3.1.3

Références $row.

◆ hasQueryCacheEnabled()

hasQueryCacheEnabled ( )

private

Internal function to check if query cache is enabled.

Renvoie: boolean

Depuis: 3.9.25

Références $row.

◆ insertid()

insertid ( )

Method to get the auto-incremented value from the last INSERT statement.

Renvoie: integer The value of the auto-increment field from the last inserted row.

Depuis: 3.0.0

◆ isSupported()

static isSupported ( )

static

Test to see if the MySQL connector is available.

Renvoie: boolean True on success, false otherwise.

Depuis: 3.0.0

Implémente JDatabaseInterface.

◆ select()

select ( $database )

Select a database for use.

Paramètres

string $database The name of the database to select for use.

Renvoie: boolean True if the database was successfully selected.

Depuis: 3.0.0

Exceptions

RuntimeException

◆ serverClaimsUtf8mb4Support()

serverClaimsUtf8mb4Support ( )

private

Does the database server claim to have support for UTF-8 Multibyte (utf8mb4) collation?

libmysql supports utf8mb4 since 5.5.3 (same version as the MySQL server). mysqlnd supports utf8mb4 since 5.0.9.

Renvoie: boolean

Depuis: CMS 3.5.0

◆ setUtf()

setUtf ( )

Set the connection to use UTF-8 character encoding.

Renvoie: boolean True on success.

Depuis: 3.0.0

If I could not set the utf8mb4 charset then the server doesn't support utf8mb4 despite claiming otherwise. This happens on old MySQL server versions (less than 5.5.3) using the mysqlnd PHP driver. Since mysqlnd masks the server version and reports only its own we can not be sure if the server actually does support UTF-8 Multibyte (i.e. it's MySQL 5.5.3 or later). Since the utf8mb4 charset is undefined in this case we catch the error and determine that utf8mb4 is not supported!

Documentation des champs

◆ $name

$name = 'mysql'

La documentation de cette classe a été générée à partir du fichier suivant :

libraries/joomla/database/driver/mysql.php

Fonctions membres publiques

Fonctions membres publiques statiques

Champs de données

Fonctions membres protégées

Fonctions membres privées

Membres hérités additionnels

Description détaillée

Documentation des constructeurs et destructeur

◆ __construct()

Documentation des fonctions membres

◆ connect()

◆ connected()

◆ disconnect()

◆ escape()

◆ execute()

◆ fetchArray()

◆ fetchAssoc()

◆ fetchObject()

◆ freeResult()

◆ getAffectedRows()

◆ getErrorMessage()

◆ getErrorNumber()

◆ getNumRows()

◆ getVersion()

◆ hasProfiling()

◆ hasQueryCacheEnabled()

◆ insertid()

◆ isSupported()

◆ select()

◆ serverClaimsUtf8mb4Support()

◆ setUtf()

Documentation des champs

◆ $name