MysqlDriver
class MysqlDriver extends PdoDriver (View source)
Class MysqlDriver
Methods
Constructor.
setConnection
Method to free up the memory used for the result set.
getTable
getWriter
Gets the name of the database used by this conneciton.
This function replaces a string identifier $prefix with the string held is the tablePrefix class variable.
Splits a string of multiple queries into an array of individual queries.
Sets the database debugging state for the driver.
Sets the SQL statement string for later execution.
Method to set property options
Method to set property database
Method to set property middlewares
Is this driver supported.
Retrieve a PDO database connection attribute http://www.php.net/manual/en/pdo.getattribute.php
Details
at line line 45
__construct(null $connection = null, array $options = array())
Constructor.
in AbstractDatabaseDriver at line line 189
resource|object
getConnection()
getConnection
in AbstractDatabaseDriver at line line 201
AbstractDatabaseDriver
setConnection(resource $connection)
setConnection
in AbstractDatabaseDriver at line line 216
resource|false
execute()
Execute the SQL statement.
AbstractDatabaseDriver
connect()
connect
AbstractDatabaseDriver
disconnect()
Disconnects the database.
AbstractDatabaseDriver
freeResult(mixed $cursor = null)
Method to free up the memory used for the result set.
in AbstractDatabaseDriver at line line 318
resource
getCursor()
getCursor
Query
getQuery(boolean $new = false)
Get the current query object or a new Query object.
in AbstractDatabaseDriver at line line 363
AbstractTable
getTable(string $name, bool $new = false)
getTable
in AbstractDatabaseDriver at line line 383
AbstractDatabase
getDatabase(string $name = null, bool $new = false)
getTable
in AbstractDatabaseDriver at line line 410
AbstractReader
getReader(Query $query = null, bool $new = true)
getReader
in AbstractDatabaseDriver at line line 434
AbstractWriter
getWriter(bool $new = true)
getWriter
in AbstractDatabaseDriver at line line 454
AbstractTransaction
getTransaction(boolean $nested = true, bool $new = false)
getWriter
in AbstractDatabaseDriver at line line 473
DataIterator
getIterator(string $class = 'stdClass')
getIterator
in AbstractDatabaseDriver at line line 485
string
getCurrentDatabase()
Gets the name of the database used by this conneciton.
in AbstractDatabaseDriver at line line 497
string
getPrefix()
Get the common table prefix for the database driver.
in AbstractDatabaseDriver at line line 513
string
replacePrefix(string $sql, string $prefix = '#__')
This function replaces a string identifier $prefix with the string held is the tablePrefix class variable.
in AbstractDatabaseDriver at line line 613
static array
splitSql(string $sql)
Splits a string of multiple queries into an array of individual queries.
in AbstractDatabaseDriver at line line 671
AbstractDatabaseDriver
setDebug(boolean $level)
Sets the database debugging state for the driver.
AbstractDatabaseDriver
setQuery(mixed $query, array $driverOptions = array())
Sets the SQL statement string for later execution.
in AbstractDatabaseDriver at line line 702
mixed
loadAll(string $key = null, string $class = '\\stdClass')
loadAll
in AbstractDatabaseDriver at line line 724
mixed
loadOne(string $class = '\\stdClass')
loadOne
in AbstractDatabaseDriver at line line 744
mixed
loadResult()
loadResult
in AbstractDatabaseDriver at line line 754
mixed
loadColumn()
loadColumn
in AbstractDatabaseDriver at line line 781
mixed
quoteName(string $text)
quoteName
in AbstractDatabaseDriver at line line 793
mixed
qn(string $text)
qn
in AbstractDatabaseDriver at line line 806
string
quote(string $text, bool $escape = true)
quote
in AbstractDatabaseDriver at line line 819
string
q(string $text, bool $escape = true)
q
in AbstractDatabaseDriver at line line 832
string
escape(string $text, bool $extra = true)
escape
in AbstractDatabaseDriver at line line 845
string
e(string $text, bool $extra = true)
e
in AbstractDatabaseDriver at line line 855
string
getName()
Method to get property Name
in AbstractDatabaseDriver at line line 865
array
getOptions()
Method to get property Options
in AbstractDatabaseDriver at line line 877
AbstractDatabaseDriver
setOptions(array $options)
Method to set property options
in AbstractDatabaseDriver at line line 891
AbstractDatabaseDriver
setDatabaseName(string $database)
Method to set property database
in AbstractDatabaseDriver at line line 909
AbstractDatabaseDriver
addMiddleware(MiddlewareInterface|callable $middleware)
addMiddleware
in AbstractDatabaseDriver at line line 923
ChainBuilder
getMiddlewares()
Method to get property Middlewares
in AbstractDatabaseDriver at line line 935
AbstractDatabaseDriver
resetMiddlewares()
Method to set property middlewares
in AbstractDatabaseDriver at line line 948
string
getLastQuery()
Method to get property LastQuery
at line line 32
static boolean
isSupported()
Is this driver supported.
mixed
getOption(mixed $key)
Retrieve a PDO database connection attribute http://www.php.net/manual/en/pdo.getattribute.php
Usage: $db->getOption(PDO::ATTR_CASE);
boolean
setOption(integer $key, mixed $value)
Sets an attribute on the PDO database handle.
http://www.php.net/manual/en/pdo.setattribute.php
Usage: $db->setOption(PDO::ATTRCASE, PDO::CASEUPPER);
PDOStatement|false
doExecute()
Execute the SQL statement.