Class MySQL

Database management driver wrapping mysql extension.

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

Extended by

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

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

Methods summary

`public`	# `__construct( string $host, string $database, string $username, string $password )` Init actions. Init actions. Parameters `$host` Host of the storage engine. `$database` Name of the database. `$username` Username to access the database. `$password` Password for the user. Overrides `Core\Modules\DB\Adapters\MySQLi::__construct`
`public array\|resource\|boolean`	# `query( string $sql, array $bind_params = array() )` Formats a query. Formats a query. Parameters `$sql` SQL string query. `$bind_params` Array of parameter values. Returns array\|resource\|boolean Overrides `Core\Modules\DB\Adapters\MySQLi::query`
`public resource`	# `execute( string $sql, array $bind_params = array() )` Executes a query. Executes a query. Parameters `$sql` SQL string query. `$bind_params` Parameter to bind. Returns resource Overrides `Core\Modules\DB\Adapters\MySQLi::execute` Implementation of `Core\Modules\DB\Interfaces\Adapter::execute()`
`public integer`	# `getLastInsertId( )` Retrieves last inserted id. Retrieves last inserted id. Returns integer Overrides `Core\Modules\DB\Adapters\MySQLi::getLastInsertId` Implementation of `Core\Modules\DB\Interfaces\Adapter::getLastInsertId()`
`public string`	# `escapeString( string $value )` Sanitizes string. Sanitizes string. Parameters `$value` Variable to be escaped. Returns string Overrides `Core\Modules\DB\Adapters\MySQLi::escapeString`
`private mixed`	# `prepare( string $sql, array $bind_params = array() )` Prepares a query for execution. Prepares a query for execution. Parameters `$sql` SQL Query. `$bind_params` Parameters. Returns mixed Throws Exception The number of values passed and placeholders mismatch.
`private array`	# `fetchAll( resource $resource )` Fetch all rows satisfying the query. Fetch all rows satisfying the query. Parameters `$resource` Resource source. Returns array

Methods inherited from Core\Modules\DB\Adapters\MySQLi

buildSql(), clearTable(), getSupportedJoinTypes(), getTableSchema(), getTables(), run(), setCharset(), storeQueries()

Properties summary

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

Properties inherited from Core\Modules\DB\Adapters\MySQLi