Database
class Database (View source)
Methods
Returns the Database instance
Connection, starts the connection on the DB
Get connexion name
Get adapter connexion instance
Execute an UPDATE request
Execute a SELECT request
Executes a select query and returns a single record
Execute an insert query
Executes a request of type DROP | CREATE TABLE | TRUNCATE | ALTER Builder
Execute a delete request
Load the query builder factory on table name
Starting the start of a transaction
Check if database execution is in transaction
Validate a transaction
Cancel a transaction
Retrieves the identifier of the last record.
__call
Details
static Database
configure(array $config)
Load configuration
static Database
getInstance()
Returns the Database instance
static null|Database
connection(null $name = null)
Connection, starts the connection on the DB
static string|null
getConnectionName()
Get connexion name
static AbstractConnection
getConnectionAdapter()
Get adapter connexion instance
static bool
update(string $sql_statement, array $data = [])
Execute an UPDATE request
static mixed|null
select(string $sql_statement, array $data = [])
Execute a SELECT request
static mixed|null
selectOne(string $sql_statement, array $data = [])
Executes a select query and returns a single record
static null
insert($sql_statement, array $data = [])
Execute an insert query
static bool
statement(string $sql_statement)
Executes a request of type DROP | CREATE TABLE | TRUNCATE | ALTER Builder
static bool
delete($sql_statement, array $data = [])
Execute a delete request
static QueryBuilder
table(string $table)
Load the query builder factory on table name
static
startTransaction(callable $callback = null)
Starting the start of a transaction
static bool
inTransaction()
Check if database execution is in transaction
static
commit()
Validate a transaction
static
rollback()
Cancel a transaction
static int
lastInsertId(string $name = null)
Retrieves the identifier of the last record.
static PDO
getPdo()
PDO, returns the instance of the connection.
static
setPdo(PDO $pdo)
Modify the PDO instance
mixed
__call(string $method, array $arguments)
__call