Class PdoMySql

Database management driver wrapping PDO_MYSQL extension.

PDO

Core\Modules\DB\Adapters\PdoMySql implements Core\Modules\DB\Interfaces\Adapter

Namespace: Core\Modules\DB\Adapters
Located at modules/db/adapters/pdomysql.php

Methods summary

`public mixed`	# `run( Core\Modules\DB\Query $query )` Runs a query. Runs a query. Parameters `$query` Current query object. Returns mixed Implementation of `Core\Modules\DB\Interfaces\Adapter::run()`
`public mixed`	# `query( string $sql, array $bind_params = array() )` Formats query object. Formats query object. Parameters `$sql` SQL query. `$bind_params` Parameters. Returns mixed Overrides `PDO::query`
`public boolean\|integer`	# `execute( string $sql, array $bind_params = array() )` Executes a query. Executes a query. Parameters `$sql` SQL query string. `$bind_params` Query parameters. Returns boolean\|integer Implementation of `Core\Modules\DB\Interfaces\Adapter::execute()`
`public integer`	# `setCharset( string $charset = 'utf8' )` Sets connection charset. Sets connection charset. Parameters `$charset` Character set type. Returns integer Implementation of `Core\Modules\DB\Interfaces\Adapter::setCharset()`
`public array`	# `getTables( string $schema )` Get all tables under the database. Get all tables under the database. Parameters `$schema` Schema contents. Returns array Implementation of `Core\Modules\DB\Interfaces\Adapter::getTables()`
`public array`	# `getTableSchema( string $table, string $schema )` Retrieves table schema. Retrieves table schema. Parameters `$table` Table name. `$schema` Schema contents. Returns array Implementation of `Core\Modules\DB\Interfaces\Adapter::getTableSchema()`
`public`	# `storeQueries( string $query, array $params = array() )` Caches queries. Caches queries. Parameters `$query` SQL Query. `$params` Query parameters. Implementation of `Core\Modules\DB\Interfaces\Adapter::storeQueries()`
`public integer`	# `getLastInsertId( )` Returns the last insert id representation. Returns the last insert id representation. Returns integer Implementation of `Core\Modules\DB\Interfaces\Adapter::getLastInsertId()`
`public string`	# `escapeString( string $value )` Sanitizes string. Sanitizes string. Parameters `$value` Value to be escaped. Returns string
`public boolean\|integer`	# `clearTable( string $table )` Purge cache. Purge cache. Parameters `$table` Table name. Returns boolean\|integer Implementation of `Core\Modules\DB\Interfaces\Adapter::clearTable()`
`private string`	# `buildSql( Core\Modules\DB\Query $query )` Builds the SQL part of the query. Builds the SQL part of the query. Parameters `$query` Query object. Returns string Throws DomainException DB Adapter does not support the required JOIN type.
`private array`	# `convertAttributes( array $attributes )` Convert attributes method to adapter locals. Convert attributes method to adapter locals. Parameters `$attributes` Attributes to be converted. Returns array
`public static array`	# `getSupportedJoinTypes( )` Retrieves all supported types of SQL JOIN operator. Retrieves all supported types of SQL JOIN operator. Returns array Implementation of `Core\Modules\DB\Interfaces\Adapter::getSupportedJoinTypes()`

Methods inherited from PDO

__construct(), __sleep(), __wakeup(), beginTransaction(), commit(), errorCode(), errorInfo(), exec(), getAttribute(), getAvailableDrivers(), inTransaction(), lastInsertId(), prepare(), quote(), rollBack(), setAttribute()

Constants summary

Constants inherited from PDO

ATTR_AUTOCOMMIT, ATTR_CASE, ATTR_CLIENT_VERSION, ATTR_CONNECTION_STATUS, ATTR_CURSOR, ATTR_CURSOR_NAME, ATTR_DEFAULT_FETCH_MODE, ATTR_DRIVER_NAME, ATTR_EMULATE_PREPARES, ATTR_ERRMODE, ATTR_FETCH_CATALOG_NAMES, ATTR_FETCH_TABLE_NAMES, ATTR_MAX_COLUMN_LEN, ATTR_ORACLE_NULLS, ATTR_PERSISTENT, ATTR_PREFETCH, ATTR_SERVER_INFO, ATTR_SERVER_VERSION, ATTR_STATEMENT_CLASS, ATTR_STRINGIFY_FETCHES, ATTR_TIMEOUT, CASE_LOWER, CASE_NATURAL, CASE_UPPER, CURSOR_FWDONLY, CURSOR_SCROLL, ERRMODE_EXCEPTION, ERRMODE_SILENT, ERRMODE_WARNING, ERR_NONE, FETCH_ASSOC, FETCH_BOTH, FETCH_BOUND, FETCH_CLASS, FETCH_CLASSTYPE, FETCH_COLUMN, FETCH_FUNC, FETCH_GROUP, FETCH_INTO, FETCH_KEY_PAIR, FETCH_LAZY, FETCH_NAMED, FETCH_NUM, FETCH_OBJ, FETCH_ORI_ABS, FETCH_ORI_FIRST, FETCH_ORI_LAST, FETCH_ORI_NEXT, FETCH_ORI_PRIOR, FETCH_ORI_REL, FETCH_PROPS_LATE, FETCH_SERIALIZE, FETCH_UNIQUE, MYSQL_ATTR_COMPRESS, MYSQL_ATTR_DIRECT_QUERY, MYSQL_ATTR_FOUND_ROWS, MYSQL_ATTR_IGNORE_SPACE, MYSQL_ATTR_INIT_COMMAND, MYSQL_ATTR_LOCAL_INFILE, MYSQL_ATTR_MULTI_STATEMENTS, MYSQL_ATTR_SERVER_PUBLIC_KEY, MYSQL_ATTR_SSL_CA, MYSQL_ATTR_SSL_CAPATH, MYSQL_ATTR_SSL_CERT, MYSQL_ATTR_SSL_CIPHER, MYSQL_ATTR_SSL_KEY, MYSQL_ATTR_SSL_VERIFY_SERVER_CERT, MYSQL_ATTR_USE_BUFFERED_QUERY, NULL_EMPTY_STRING, NULL_NATURAL, NULL_TO_STRING, PARAM_BOOL, PARAM_EVT_ALLOC, PARAM_EVT_EXEC_POST, PARAM_EVT_EXEC_PRE, PARAM_EVT_FETCH_POST, PARAM_EVT_FETCH_PRE, PARAM_EVT_FREE, PARAM_EVT_NORMALIZE, PARAM_INPUT_OUTPUT, PARAM_INT, PARAM_LOB, PARAM_NULL, PARAM_STMT, PARAM_STR, SQLITE_DETERMINISTIC

Properties summary

`public Core\Modules\DB\DbCache`	`$cache` DB Cache instance. DB Cache instance.	#

Namespaces

Classes

Class PdoMySql

Methods summary

Parameters

Returns

Implementation of

Parameters

Returns

Overrides

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Returns

Implementation of

Parameters

Implementation of

Returns

Implementation of

Parameters

Returns

Parameters

Returns

Implementation of

Parameters

Returns

Throws

Parameters

Returns

Returns

Implementation of

Methods inherited from PDO

Constants summary

Constants inherited from PDO

Properties summary