classe Database (Voir la source)

Méthodes

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

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

Détails

static Database configure(array $config)

Load configuration

Paramètres

array $config

Valeur de retour

Database

static Database getInstance()

Returns the Database instance

Valeur de retour

Database

static null|Database connection(null $name = null)

Connection, starts the connection on the DB

Paramètres

null $name

Valeur de retour

null|Database

Exceptions

ConnectionException

static string|null getConnectionName()

Get connexion name

Valeur de retour

string|null

static AbstractConnection getConnectionAdapter()

Get adapter connexion instance

Valeur de retour

AbstractConnection

static bool update(string $sql_statement, array $data = [])

Execute an UPDATE request

Paramètres

string $sql_statement
array $data

Valeur de retour

bool

static mixed|null select(string $sql_statement, array $data = [])

Execute a SELECT request

Paramètres

string $sql_statement
array $data

Valeur de retour

mixed|null

static mixed|null selectOne(string $sql_statement, array $data = [])

Executes a select query and returns a single record

Paramètres

string $sql_statement
array $data

Valeur de retour

mixed|null

static null insert($sql_statement, array $data = [])

Execute an insert query

Paramètres

$sql_statement
array $data

Valeur de retour

null

static bool statement(string $sql_statement)

Executes a request of type DROP | CREATE TABLE | TRUNCATE | ALTER Builder

Paramètres

string $sql_statement

Valeur de retour

bool

static bool delete($sql_statement, array $data = [])

Execute a delete request

Paramètres

$sql_statement
array $data

Valeur de retour

bool

static QueryBuilder table(string $table)

Load the query builder factory on table name

Paramètres

string $table

Valeur de retour

QueryBuilder

static startTransaction(callable $callback = null)

Starting the start of a transaction

Paramètres

callable $callback

static bool inTransaction()

Check if database execution is in transaction

Valeur de retour

bool

static commit()

Validate a transaction

static rollback()

Cancel a transaction

static int lastInsertId(string $name = null)

Retrieves the identifier of the last record.

Paramètres

string $name

Valeur de retour

int

static PDO getPdo()

PDO, returns the instance of the connection.

Valeur de retour

PDO

static setPdo(PDO $pdo)

Modify the PDO instance

Paramètres

PDO $pdo

mixed __call(string $method, array $arguments)

__call

Paramètres

string $method
array $arguments

Valeur de retour

mixed

Exceptions

DatabaseException