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 Database|null
connection(string|null $name = null)
Connection, starts the connection on the DB
static string|null
getConnectionName()
Get connexion name
static AbstractConnection|null
getAdapterConnection()
Get adapter connexion instance
static int
update(string $sql_statement, array $data = [])
Execute an UPDATE request
static mixed
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 int
insert(string $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 int
delete(string $sql_statement, array $data = [])
Execute a delete request
static QueryBuilder
table(string $table)
Load the query builder factory on table name
static void
startTransaction(callable|null $callback = null)
Starting the start of a transaction
static bool
inTransaction()
Check if database execution is in transaction
static void
commit()
Validate a transaction
static void
rollback()
Cancel a transaction
static int|string
lastInsertId(string|null $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