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 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

$link

Silla.IO API API documentation generated by ApiGen