CakePHP
  • Documentation
    • Book
    • API
    • Videos
    • Logos & Trademarks
  • Business Solutions
  • Swag
  • Road Trip
  • Team
  • Community
    • Community
    • Team
    • Issues (Github)
    • YouTube Channel
    • Get Involved
    • Bakery
    • Featured Resources
    • Newsletter
    • Certification
    • My CakePHP
    • CakeFest
    • Facebook
    • Twitter
    • Help & Support
    • Forum
    • Stack Overflow
    • IRC
    • Slack
    • Paid Support
CakePHP

C CakePHP 3.0 Red Velvet API

  • Overview
  • Tree
  • Deprecated
  • Version:
    • 3.0
      • 3.7
      • 3.6
      • 3.5
      • 3.4
      • 3.3
      • 3.2
      • 3.1
      • 3.0
      • 2.10
      • 2.9
      • 2.8
      • 2.7
      • 2.6
      • 2.5
      • 2.4
      • 2.3
      • 2.2
      • 2.1
      • 2.0
      • 1.3
      • 1.2

Namespaces

  • Cake
    • Auth
    • Cache
      • Engine
    • Collection
      • Iterator
    • Console
      • Exception
    • Controller
      • Component
      • Exception
    • Core
      • Configure
        • Engine
      • Exception
    • Database
      • Driver
      • Exception
      • Expression
      • Schema
      • Statement
      • Type
    • Datasource
      • Exception
    • Error
    • Event
    • Filesystem
    • Form
    • I18n
      • Formatter
      • Parser
    • Log
      • Engine
    • Network
      • Email
      • Exception
      • Http
        • Adapter
        • Auth
        • FormData
      • Session
    • ORM
      • Association
      • Behavior
        • Translate
      • Exception
      • Rule
    • Routing
      • Exception
      • Filter
      • Route
    • Shell
      • Task
    • TestSuite
      • Fixture
      • Stub
    • Utility
      • Exception
    • Validation
    • View
      • Exception
      • Form
      • Helper
      • Widget
  • None

Classes

  • Mysql
  • Postgres
  • Sqlite
  • Sqlserver

Traits

  • PDODriverTrait

Class Mysql

Represents a database diver containing all specificities for a database engine including its SQL dialect

Cake\Database\Driver
Extended by Cake\Database\Driver\Mysql uses Cake\Database\Dialect\MysqlDialectTrait , Cake\Database\Driver\PDODriverTrait
Namespace: Cake\Database\Driver
Location: Database/Driver/Mysql.php

Properties summary

  • $_baseConfig protected
    array
    Base configuration settings for MySQL driver

Inherited Properties

  • _autoQuoting, _config _endQuote, _schemaDialect, _startQuote _connection

Method Summary

  • connect() public
    Establishes a connection to the database server
  • enabled() public
    Returns whether php is able to use this driver for connecting to database
  • prepare() public
    Prepares a sql statement to be executed

Method Detail

connect() public ¶

connect( )

Establishes a connection to the database server

Returns
boolean
true on success

enabled() public ¶

enabled( )

Returns whether php is able to use this driver for connecting to database

Returns
boolean
true if it is valid to use this driver

prepare() public ¶

prepare( string|Cake\Database\Query $query )

Prepares a sql statement to be executed

Parameters
string|Cake\Database\Query $query
The query to prepare.
Returns
Cake\Database\StatementInterface

Methods inherited from Cake\Database\Driver

__construct() public ¶

__construct( array $config [] )

Constructor

Parameters
array $config optional []
The configuration for the driver.
Throws
InvalidArgumentException

__debugInfo() public ¶

__debugInfo( )

Returns an array that can be used to describe the internal state of this object.

Returns
array

__destruct() public ¶

__destruct( )

Destructor

autoQuoting() public ¶

autoQuoting( boolean $enable null )

Returns whether or not this driver should automatically quote identifiers in queries

If called with a boolean argument, it will toggle the auto quoting setting to the passed value

Parameters
boolean $enable optional null
whether to enable auto quoting
Returns
boolean

beginTransaction() abstract public ¶

beginTransaction( )

Starts a transaction

Returns
boolean
true on success, false otherwise

commitTransaction() abstract public ¶

commitTransaction( )

Commits a transaction

Returns
boolean
true on success, false otherwise

compileQuery() public ¶

compileQuery( Cake\Database\Query $query , Cake\Database\ValueBinder $generator )

Transforms the passed query to this Driver's dialect and returns an instance of the transformed query and the full compiled SQL string

Parameters
Cake\Database\Query $query
The query to compile.
Cake\Database\ValueBinder $generator
The value binder to use.
Returns
array

containing 2 entries. The first entity is the transformed query and the second one the compiled SQL


connection() abstract public ¶

connection( null|PDO $connection null )

Returns correct connection resource or object that is internally used If first argument is passed,

Parameters
null|PDO $connection optional null
The connection object

disableForeignKeySQL() abstract public ¶

disableForeignKeySQL( )

Get the SQL for disabling foreign keys

Returns
string

disconnect() abstract public ¶

disconnect( )

Disconnects from database server

enableForeignKeySQL() abstract public ¶

enableForeignKeySQL( )

Get the SQL for enabling foreign keys

Returns
string

isConnected() public ¶

isConnected( )

Check whether or not the driver is connected.

Returns
boolean

lastInsertId() public ¶

lastInsertId( string $table null , string $column null )

Returns last id generated for a table or sequence in database

Parameters
string $table optional null
table name or sequence to get last insert value from
string $column optional null
the name of the column representing the primary key
Returns
string|integer

newCompiler() public ¶

newCompiler( )

Returns an instance of a QueryCompiler

Returns
Cake\Database\QueryCompiler

queryTranslator() abstract public ¶

queryTranslator( string $type )

Returns a callable function that will be used to transform a passed Query object. This function, in turn, will return an instance of a Query object that has been transformed to accommodate any specificities of the SQL dialect in use.

Parameters
string $type

the type of query to be transformed (select, insert, update, delete)

Returns
callable

quote() abstract public ¶

quote( mixed $value , string $type )

Returns a value in a safe representation to be used in a query string

Parameters
mixed $value
The value to quote.
string $type
Type to be used for determining kind of quoting to perform
Returns
string

quoteIdentifier() abstract public ¶

quoteIdentifier( string $identifier )

Quotes a database identifier (a column name, table name, etc..) to be used safely in queries without the risk of using reserved words

Parameters
string $identifier
The identifier expression to quote.
Returns
string

releaseSavePointSQL() abstract public ¶

releaseSavePointSQL( string $name )

Get the SQL for releasing a save point.

Parameters
string $name
The table name
Returns
string

rollbackSavePointSQL() abstract public ¶

rollbackSavePointSQL( string $name )

Get the SQL for rollingback a save point.

Parameters
string $name
The table name
Returns
string

rollbackTransaction() abstract public ¶

rollbackTransaction( )

Rollsback a transaction

Returns
boolean
true on success, false otherwise

savePointSQL() abstract public ¶

savePointSQL( string $name )

Get the SQL for creating a save point.

Parameters
string $name
The table name
Returns
string

schemaDialect() abstract public ¶

schemaDialect( )

Get the schema dialect.

Used by Cake\Database\Schema package to reflect schema and generate schema.

If all the tables that use this Driver specify their own schemas, then this may return null.

Returns
Cake\Database\Schema\BaseSchema

schemaValue() public ¶

schemaValue( mixed $value )

Escapes values for use in schema definitions.

Parameters
mixed $value
The value to escape.
Returns
string
String for use in schema definitions.

supportsQuoting() public ¶

supportsQuoting( )

Checks if the driver supports quoting

Returns
boolean

supportsSavePoints() public ¶

supportsSavePoints( )

Returns whether this driver supports save points for nested transactions

Returns
boolean
true if save points are supported, false otherwise

Methods used from Cake\Database\Dialect\MysqlDialectTrait

disableForeignKeySQL() public ¶

disableForeignKeySQL( )

enableForeignKeySQL() public ¶

enableForeignKeySQL( )

schemaDialect() public ¶

schemaDialect( )

Get the schema dialect.

Used by Cake\Database\Schema package to reflect schema and generate schema.

Returns
Cake\Database\Schema\MysqlSchema

Methods used from Cake\Database\Driver\PDODriverTrait

_connect() protected ¶

_connect( string $dsn , array $config )

Establishes a connection to the database server

Parameters
string $dsn
A Driver-specific PDO-DSN
array $config
configuration to be used for creating connection
Returns
boolean
true on success

beginTransaction() public ¶

beginTransaction( )

Starts a transaction

Returns
boolean
true on success, false otherwise

commitTransaction() public ¶

commitTransaction( )

Commits a transaction

Returns
boolean
true on success, false otherwise

connection() public ¶

connection( null|PDO $connection null )

Returns correct connection resource or object that is internally used If first argument is passed, it will set internal connection object or result to the value passed

Parameters
null|PDO $connection optional null
The PDO connection instance.
Returns
mixed
connection object used internally

disconnect() public ¶

disconnect( )

Disconnects from database server

lastInsertId() public ¶

lastInsertId( string|null $table null , string|null $column null )

Returns last id generated for a table or sequence in database

Parameters
string|null $table optional null
table name or sequence to get last insert value from
string|null $column optional null
the name of the column representing the primary key
Returns
string|integer

quote() public ¶

quote( mixed $value , string $type )

Returns a value in a safe representation to be used in a query string

Parameters
mixed $value
The value to quote.
string $type
Type to be used for determining kind of quoting to perform
Returns
string

rollbackTransaction() public ¶

rollbackTransaction( )

Rollsback a transaction

Returns
boolean
true on success, false otherwise

supportsQuoting() public ¶

supportsQuoting( )

Checks if the driver supports quoting, as PDO_ODBC does not support it.

Returns
boolean

Properties detail

$_baseConfig ¶

protected array

Base configuration settings for MySQL driver

[
    'persistent' => true,
    'host' => 'localhost',
    'username' => 'root',
    'password' => '',
    'database' => 'cake',
    'port' => '3306',
    'flags' => [],
    'encoding' => 'utf8',
    'timezone' => null,
    'init' => [],
]
Follow @CakePHP
#IRC
OpenHub
Rackspace
  • Business Solutions
  • Showcase
  • Documentation
  • Book
  • API
  • Videos
  • Logos & Trademarks
  • Community
  • Team
  • Issues (Github)
  • YouTube Channel
  • Get Involved
  • Bakery
  • Featured Resources
  • Newsletter
  • Certification
  • My CakePHP
  • CakeFest
  • Facebook
  • Twitter
  • Help & Support
  • Forum
  • Stack Overflow
  • IRC
  • Slack
  • Paid Support

Generated using CakePHP API Docs