MySql
in package
Table of Contents
Properties
Methods
- __construct() : mixed
- beginTransaction() : bool
- Starts a transaction
- commit() : bool
- Commits active transaction
- exec() : PDOStatement|false
- Executes a query
- getConnection() : PDO
- Returns PDO instance representing the connection
- insertMulti() : PDOStatement
- inTransaction() : bool
- Checks if transaction is active
- lastInsertId() : string
- Returns last insert id
- rollBack() : bool
- Rolls back active transaction
Properties
$config
private
Config
$config
$dbh
private
PDO
$dbh
$stmt
private
PDOStatement
$stmt
Methods
__construct()
public
__construct(Config $config[, string|null $conn = 'mysql' ]) : mixed
Parameters
- $config : Config
- $conn : string|null = 'mysql'
beginTransaction()
Starts a transaction
public
beginTransaction() : bool
Tags
Return values
boolcommit()
Commits active transaction
public
commit() : bool
Tags
Return values
boolexec()
Executes a query
public
exec(string $sql[, array<string, string|int|bool|null> $params = null ]) : PDOStatement|false
Parameters
- $sql : string
- $params : array<string, string|int|bool|null> = null
Tags
Return values
PDOStatement|falsegetConnection()
Returns PDO instance representing the connection
public
getConnection() : PDO
Return values
PDOinsertMulti()
public
insertMulti([string $sql = '' ][, array<int, array<string|int, mixed>> $data = [] ]) : PDOStatement
Parameters
- $sql : string = ''
- $data : array<int, array<string|int, mixed>> = []
Tags
Return values
PDOStatementinTransaction()
Checks if transaction is active
public
inTransaction() : bool
Tags
Return values
boollastInsertId()
Returns last insert id
public
lastInsertId() : string
Return values
stringrollBack()
Rolls back active transaction
public
rollBack() : bool