PdoDriver
class PdoDriver extends AbstractDatabaseDriver (View source)
Class PdoDriver
Methods
Constructor.
setConnection
connect
Disconnects the database.
Select a database for use.
Get the version of the database connector
Method to free up the memory used for the result set.
getDatabaseList
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
Sets an attribute on the PDO database handle.
Execute the SQL statement.
Details
at line line 78
__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.
at line line 108
AbstractDatabaseDriver
connect()
connect
at line line 144
AbstractDatabaseDriver
disconnect()
Disconnects the database.
at line line 220
boolean
select(string $database)
Select a database for use.
at line line 203
string
getVersion()
Get the version of the database connector
at line line 304
AbstractDatabaseDriver
freeResult(mixed $cursor = null)
Method to free up the memory used for the result set.
at line line 357
mixed
listDatabases()
getDatabaseList
in AbstractDatabaseDriver at line line 318
resource
getCursor()
getCursor
at line line 328
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.
at line line 239
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 65
static boolean
isSupported()
Is this driver supported.
at line line 167
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);
at line line 189
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);
at line line 257
PDOStatement|false
doExecute()
Execute the SQL statement.