Silla.IO API
  • Namespace
  • Class
  • Tree
  • Todo
  • Download

Namespaces

  • App
    • Controllers
  • CMS
    • Controllers
    • Helpers
    • Models
  • Configurations
    • CI
    • Development
    • Production
    • Staging
  • Core
    • Base
    • CLI
      • Cache
      • DB
    • Helpers
    • Modules
      • Cache
        • Adapters
        • Interfaces
      • Crypt
      • DB
        • Adapters
        • Decorators
          • Interfaces
        • Features
          • Paginator
        • Interfaces
      • Registry
      • Render
        • Adapters
        • Interfaces
      • Router
      • Session
        • Adapters
        • Interfaces
  • None
  • Tasks
    • DB

Classes

  • MySQL
  • MySQLi
  • PdoMySql
  • SQLite

Class PdoMySql

Database management driver wrapping PDO_MYSQL extension.

PDO
Extended by 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.

#
Silla.IO API API documentation generated by ApiGen