\ManaPHP\Data\Db\Connection\AdapterMysql

Summary

Methods

Properties

Constants

__construct()
__clone()
getUrl()
execute()
query()
close()
begin()
rollback()
commit()
getInstance()
getShared()
inject()
__get()
__set()
__isset()
attachEvent()
detachEvent()
peekEvent()
fireEvent()
on()
off()
emit()
__debugInfo()
dump()
toArray()
jsonSerialize()
getMetadata()
truncate()
drop()
getTables()
tableExists()
buildSql()
replaceQuoteCharacters()
bulkInsert()
upsert()

$alias
$eventsManager
$logger
$configure
$settings
$crypt
$identity
$cache
$httpClient
$restClient
$db
$redisCache
$redisDb
$redisBroker
$mongodb
$rabbitmq
$elasticsearch
$mailer
$bosClient
$wspClient
$coroutineManager
$wsClient
$pubSub
$_context
$_di

No constants found

_ping()
_getPdo()
_escapeIdentifier()
_getPrepared()
_execute()
_createContext()

$_url
$_dsn
$_username
$_password
$_emulate_prepares
$_options
$_pdo
$_in_transaction
$_prepared
$_readonly
$_object_id
$_on
$_injections
$_charset

N/A

No private methods found

No private properties found

N/A

File: Data/Db/Connection/Adapter/Mysql.php
Package: Default
Class hierarchy: \ManaPHP\Component

\ManaPHP\Data\Db\Connection

\ManaPHP\Data\Db\Connection\Adapter\Mysql

Properties

$alias

$alias : \ManaPHP\AliasInterface

Type

\ManaPHP\AliasInterface

$eventsManager

$eventsManager : \ManaPHP\Event\ManagerInterface

Type

\ManaPHP\Event\ManagerInterface

$logger

$logger : \ManaPHP\Logging\LoggerInterface

Type

\ManaPHP\Logging\LoggerInterface

$configure

$configure : \ManaPHP\Configuration\Configure

Type

\ManaPHP\Configuration\Configure

$settings

$settings : \ManaPHP\Configuration\SettingsInterface

Type

\ManaPHP\Configuration\SettingsInterface

$crypt

$crypt : \ManaPHP\Security\CryptInterface

Type

\ManaPHP\Security\CryptInterface

$identity

$identity : \ManaPHP\IdentityInterface

Type

\ManaPHP\IdentityInterface

$cache

$cache : \ManaPHP\Caching\CacheInterface

Type

\ManaPHP\Caching\CacheInterface

$httpClient

$httpClient : \ManaPHP\Http\ClientInterface

Type

\ManaPHP\Http\ClientInterface

$restClient

$restClient : \ManaPHP\Http\ClientInterface

Type

\ManaPHP\Http\ClientInterface

$db

$db : \ManaPHP\Data\DbInterface

Type

\ManaPHP\Data\DbInterface

$redisCache

$redisCache : \Redis|\ManaPHP\Data\RedisInterface

Type

\Redis|\ManaPHP\Data\RedisInterface

$redisDb

$redisDb : \Redis|\ManaPHP\Data\RedisInterface

Type

\Redis|\ManaPHP\Data\RedisInterface

$redisBroker

$redisBroker : \Redis|\ManaPHP\Data\RedisInterface

Type

\Redis|\ManaPHP\Data\RedisInterface

$mongodb

$mongodb : \ManaPHP\Data\MongodbInterface

Type

\ManaPHP\Data\MongodbInterface

$rabbitmq

$rabbitmq : \ManaPHP\Messaging\AmqpInterface

Type

\ManaPHP\Messaging\AmqpInterface

$elasticsearch

$elasticsearch : \Elasticsearch\Client

Type

\Elasticsearch\Client

$mailer

$mailer : \ManaPHP\Mailing\MailerInterface

Type

\ManaPHP\Mailing\MailerInterface

$bosClient

$bosClient : \ManaPHP\Bos\ClientInterface

Type

\ManaPHP\Bos\ClientInterface

$wspClient

$wspClient : \ManaPHP\Ws\Pushing\ClientInterface

Type

\ManaPHP\Ws\Pushing\ClientInterface

$coroutineManager

$coroutineManager : \ManaPHP\Coroutine\ManagerInterface

Type

\ManaPHP\Coroutine\ManagerInterface

$wsClient

$wsClient : \ManaPHP\Ws\ClientInterface

Type

\ManaPHP\Ws\ClientInterface

$pubSub

$pubSub : \ManaPHP\Messaging\PubSubInterface

Type

\ManaPHP\Messaging\PubSubInterface

$_context

$_context : \object

Type

\object

$_di

$_di : \ManaPHP\DiInterface

Type

\ManaPHP\DiInterface

$_url

$_url : string

Type

string

$_dsn

$_dsn : string

Type

string

$_username

$_username : string

Type

string

$_password

$_password : string

Type

string

$_emulate_prepares

$_emulate_prepares : boolean

Type

boolean

$_options

$_options : array

Type

array

$_pdo

$_pdo : \PDO

Type

\PDO

$_in_transaction

$_in_transaction : boolean

Type

boolean

$_prepared

$_prepared : array<mixed,\PDOStatement>

Type

array<mixed,\PDOStatement>

$_readonly

$_readonly : boolean

Type

boolean

$_object_id

$_object_id : integer

Type

integer

$_on

$_on : array<mixed,callable>

Type

array<mixed,callable>

$_injections

$_injections : array

Type

array

$_charset

$_charset : string

Type

string

Methods

__construct()

__construct(string  $url = 'mysql://root@localhost/test?charset=utf8')

Parameters

string

$url

__clone()

__clone()

getUrl()

getUrl() : string

Returns

string

execute()

execute(string  $sql, array  $bind = array(), boolean  $has_insert_id = false) : integer

Parameters

string	$sql
array	$bind
boolean	$has_insert_id

Throws

\ManaPHP\Data\Db\ConnectionException
\ManaPHP\Exception\NotSupportedException

Returns

integer

query()

query(string  $sql, array  $bind = array(), integer  $mode = \PDO::FETCH_ASSOC) : array

Parameters

string	$sql
array	$bind
integer	$mode

Returns

array

close()

close()

begin()

begin() : boolean

Returns

boolean

rollback()

rollback() : boolean

Returns

boolean

commit()

commit() : boolean

Returns

boolean

getInstance()

getInstance(string  $class, array  $params = array()) : mixed

Parameters

string	$class
array	$params

Returns

mixed

getShared()

getShared(string  $name) : mixed

Parameters

string

$name

Returns

mixed

inject()

inject(string  $name, mixed  $target) : static

Parameters

string	$name
mixed	$target

Returns

static

__get()

__get(string  $name) : mixed

Magic method __get

Parameters

string

$name

Returns

mixed

__set()

__set(string  $name, mixed  $value) : void

Parameters

string	$name
mixed	$value

__isset()

__isset(string  $name) : boolean

Parameters

string

$name

Returns

boolean

attachEvent()

attachEvent(string  $event, callable  $handler, boolean  $appended = true) : static

Attach a listener to the events manager

Parameters

string	$event
callable	$handler
boolean	$appended

Returns

static

detachEvent()

detachEvent(string  $event, callable  $handler) : static

Parameters

string	$event
callable	$handler

Returns

static

peekEvent()

peekEvent(string  $group, callable  $handler) : static

Parameters

string	$group
callable	$handler

Returns

static

fireEvent()

fireEvent(string  $event, mixed  $data = array(), mixed  $source = null) : void

Fires an event in the events manager causing that the active listeners will be notified about it

Parameters

string	$event
mixed	$data
mixed	$source

on()

on(string  $event, callable  $handler) : static

Parameters

string	$event
callable	$handler

Returns

static

off()

off(string  $event = null, callable  $handler = null) : static

Parameters

string	$event
callable	$handler

Returns

static

emit()

emit(string  $event, array  $data = array()) : void

Parameters

string	$event
array	$data

__debugInfo()

__debugInfo() : array

Returns

array

dump()

dump() : array

Returns

array

toArray()

toArray() : array

Returns

array

jsonSerialize()

jsonSerialize()

getMetadata()

getMetadata(string  $source) : array

Parameters

string

$source

Throws

\ManaPHP\Data\Db\Exception

Returns

array

truncate()

truncate(string  $source) : static

Parameters

string

$source

Throws

\ManaPHP\Data\Db\Exception

Returns

static

drop()

drop(string  $source) : static

Parameters

string

$source

Throws

\ManaPHP\Data\Db\Exception

Returns

static

getTables()

getTables(string  $schema = null) : array

Parameters

string

$schema

Throws

\ManaPHP\Data\Db\Exception

Returns

array

tableExists()

tableExists(string  $source) : boolean

Parameters

string

$source

Throws

\ManaPHP\Data\Db\Exception

Returns

boolean

buildSql()

buildSql(  $params)

Parameters

$params

replaceQuoteCharacters()

replaceQuoteCharacters(string  $sql) : string

Parameters

string

$sql

Returns

string

bulkInsert()

bulkInsert(string  $table, array<mixed,array>  $records) : integer

Parameters

string	$table
array<mixed,array>	$records

Throws

\ManaPHP\Data\Db\Exception

Returns

integer

upsert()

upsert(string  $table, array  $insertFieldValues, array  $updateFieldValues = array(), string  $primaryKey = null) : integer

Updates data on a table using custom SQL syntax

Parameters

string	$table
array	$insertFieldValues
array	$updateFieldValues
string	$primaryKey

Returns

integer

_ping()

_ping() : boolean

Returns

boolean

_getPdo()

_getPdo() : \PDO

Returns

\PDO

_escapeIdentifier()

_escapeIdentifier(  $identifier)

Parameters

$identifier

_getPrepared()

_getPrepared(string  $sql) : \PDOStatement

Parameters

string

$sql

Returns

\PDOStatement

_execute()

_execute(string  $sql, array  $bind) : \PDOStatement

Parameters

string	$sql
array	$bind

Returns

\PDOStatement

_createContext()

_createContext() : object

Returns

object