1. class
  2. Lemonade
  3. \
  4. Framework
  5. \
  6. Database
  7. \
  8. Driver
  9. \
  10. Mysql
  11. \
  12. MysqlDatabaseDriver

MysqlDatabaseDriver

final class MysqlDatabaseDriver implements DatabaseDriverInterface (View source)

Traits

EscapesValues
ManagesTransactions

Methods

string from EscapesValues
escape(mixed $value)
string
string from EscapesValues
escape_like_str(string $value)
string
string
escape_str(string $value, bool $like = false)
string
void from ManagesTransactions
trans_off()
void
void from ManagesTransactions
trans_strict(bool $mode = true)
void
bool from ManagesTransactions
trans_start(bool $testMode = false)
bool
bool from ManagesTransactions
trans_complete()
bool
bool from ManagesTransactions
trans_status()
bool
bool from ManagesTransactions
trans_active()
bool
bool from ManagesTransactions
trans_begin(bool $testMode = false)
bool
bool from ManagesTransactions
trans_commit()
bool
bool from ManagesTransactions
trans_rollback()
bool
void from ManagesTransactions
markTransactionFailure()
void
void
beginTransaction()
void
void
commitTransaction()
void
void
rollbackTransaction()
void
__construct(MysqlConnectionInterface $connection, DatabaseConfig $config, IdentifierEscaperInterface $identifierEscaper, IdentifierProtector $identifierProtector)
bool
initialize()
bool
void
reconnect()
void
void
close()
void
string
platform()
string
string
version()
string
bool
db_select(string $database = '')
bool
bool
db_set_charset(string $charset)
bool
DatabaseResultInterface|bool
query(string $sql, array|false $binds = false)
DatabaseResultInterface|bool
Generator
cursor(string $sql, array|false $binds = false)
Generator
bool
simple_query(string $sql)
bool
int
affected_rows()
int
int|string|null
insert_id()
int|string|null
array
error()
array
string
escape_identifiers(string $item)
string
string
protect_identifiers(string $item, bool $prefixSingle = false, bool|null $protectIdentifiers = null, bool $fieldExists = true)
string
string|false
primary(string $table)
string|false
int
count_all(string $table = '')
int
array
list_tables(bool $constrainByPrefix = false)
array
bool
table_exists(string $tableName)
bool
array
list_fields(string $table)
array
bool
field_exists(string $fieldName, string $tableName)
bool
array
field_data(string $table)
array

Details

escape

string escape(mixed $value)
in EscapesValues at line 9

No description

Parameters

mixed $value

Return Value

string

escape_like_str

string escape_like_str(string $value)
in EscapesValues at line 30

No description

Parameters

string $value

Return Value

string

escape_str

string escape_str(string $value, bool $like = false)
at line 167

No description

Parameters

string $value
bool $like

Return Value

string

trans_off

void trans_off()
in ManagesTransactions at line 21

No description

Return Value

void

trans_strict

void trans_strict(bool $mode = true)
in ManagesTransactions at line 26

No description

Parameters

bool $mode

Return Value

void

trans_start

bool trans_start(bool $testMode = false)
in ManagesTransactions at line 31

No description

Parameters

bool $testMode

Return Value

bool

trans_complete

bool trans_complete()
in ManagesTransactions at line 40

No description

Return Value

bool

trans_status

bool trans_status()
in ManagesTransactions at line 59

No description

Return Value

bool

trans_active

bool trans_active()
in ManagesTransactions at line 64

No description

Return Value

bool

trans_begin

bool trans_begin(bool $testMode = false)
in ManagesTransactions at line 69

No description

Parameters

bool $testMode

Return Value

bool

trans_commit

bool trans_commit()
in ManagesTransactions at line 94

No description

Return Value

bool

trans_rollback

bool trans_rollback()
in ManagesTransactions at line 116

No description

Return Value

bool

markTransactionFailure

protected void markTransactionFailure()
in ManagesTransactions at line 138

No description

Return Value

void

beginTransaction

protected void beginTransaction()
at line 319

No description

Return Value

void

commitTransaction

protected void commitTransaction()
at line 324

No description

Return Value

void

rollbackTransaction

protected void rollbackTransaction()
at line 329

No description

Return Value

void

__construct

__construct(MysqlConnectionInterface $connection, DatabaseConfig $config, IdentifierEscaperInterface $identifierEscaper, IdentifierProtector $identifierProtector)
at line 26

No description

Parameters

MysqlConnectionInterface $connection
DatabaseConfig $config
IdentifierEscaperInterface $identifierEscaper
IdentifierProtector $identifierProtector

initialize

bool initialize()
at line 33

No description

Return Value

bool

reconnect

void reconnect()
at line 40

No description

Return Value

void

close

void close()
at line 45

No description

Return Value

void

platform

string platform()
at line 50

No description

Return Value

string

version

string version()
at line 55

No description

Return Value

string

db_select

bool db_select(string $database = '')
at line 64

No description

Parameters

string $database

Return Value

bool

db_set_charset

bool db_set_charset(string $charset)
at line 78

No description

Parameters

string $charset

Return Value

bool

query

DatabaseResultInterface|bool query(string $sql, array|false $binds = false)
at line 90

No description

Parameters

string $sql
array|false $binds

Return Value

DatabaseResultInterface|bool

cursor

Generator cursor(string $sql, array|false $binds = false)
at line 118

No description

Parameters

string $sql
array|false $binds

Return Value

Generator

simple_query

bool simple_query(string $sql)
at line 134

No description

Parameters

string $sql

Return Value

bool

affected_rows

int affected_rows()
at line 149

No description

Return Value

int

insert_id

int|string|null insert_id()
at line 154

No description

Return Value

int|string|null

error

array error()
at line 162

No description

Return Value

array

escape_identifiers

string escape_identifiers(string $item)
at line 178

No description

Parameters

string $item

Return Value

string

protect_identifiers

string protect_identifiers(string $item, bool $prefixSingle = false, bool|null $protectIdentifiers = null, bool $fieldExists = true)
at line 183

No description

Parameters

string $item
bool $prefixSingle
bool|null $protectIdentifiers
bool $fieldExists

Return Value

string

primary

string|false primary(string $table)
at line 192

No description

Parameters

string $table

Return Value

string|false

count_all

int count_all(string $table = '')
at line 199

No description

Parameters

string $table

Return Value

int

list_tables

array list_tables(bool $constrainByPrefix = false)
at line 240

No description

Parameters

bool $constrainByPrefix

Return Value

array

table_exists

bool table_exists(string $tableName)
at line 252

No description

Parameters

string $tableName

Return Value

bool

list_fields

array list_fields(string $table)
at line 261

No description

Parameters

string $table

Return Value

array

field_exists

bool field_exists(string $fieldName, string $tableName)
at line 266

No description

Parameters

string $fieldName
string $tableName

Return Value

bool

field_data

array field_data(string $table)
at line 274

No description

Parameters

string $table

Return Value

array