1. interface
  2. Illuminate
  3. \
  4. Database
  5. \
  6. ConnectionInterface

ConnectionInterface

interface ConnectionInterface (View source)

Methods

Builder
table(string $table)

Begin a fluent query against a database table.

Expression
raw(mixed $value)

Get a new raw query expression.

mixed
selectOne(string $query, array $bindings = [])

Run a select statement and return a single result.

array
select(string $query, array $bindings = [])

Run a select statement against the database.

bool
insert(string $query, array $bindings = [])

Run an insert statement against the database.

int
update(string $query, array $bindings = [])

Run an update statement against the database.

int
delete(string $query, array $bindings = [])

Run a delete statement against the database.

bool
statement(string $query, array $bindings = [])

Execute an SQL statement and return the boolean result.

int
affectingStatement(string $query, array $bindings = [])

Run an SQL statement and get the number of rows affected.

bool
unprepared(string $query)

Run a raw, unprepared query against the PDO connection.

array
prepareBindings(array $bindings)

Prepare the query bindings for execution.

mixed
transaction(Closure $callback, int $attempts = 1)

Execute a Closure within a transaction.

void
beginTransaction()

Start a new database transaction.

void
commit()

Commit the active database transaction.

void
rollBack()

Rollback the active database transaction.

int
transactionLevel()

Get the number of active transactions.

array
pretend(Closure $callback)

Execute the given callback in "dry run" mode.

Details

at line 15
Builder table(string $table)

Begin a fluent query against a database table.

Parameters

string $table

Return Value

Builder

at line 23
Expression raw(mixed $value)

Get a new raw query expression.

Parameters

mixed $value

Return Value

Expression

at line 32
mixed selectOne(string $query, array $bindings = [])

Run a select statement and return a single result.

Parameters

string $query
array $bindings

Return Value

mixed

at line 41
array select(string $query, array $bindings = [])

Run a select statement against the database.

Parameters

string $query
array $bindings

Return Value

array

at line 50
bool insert(string $query, array $bindings = [])

Run an insert statement against the database.

Parameters

string $query
array $bindings

Return Value

bool

at line 59
int update(string $query, array $bindings = [])

Run an update statement against the database.

Parameters

string $query
array $bindings

Return Value

int

at line 68
int delete(string $query, array $bindings = [])

Run a delete statement against the database.

Parameters

string $query
array $bindings

Return Value

int

at line 77
bool statement(string $query, array $bindings = [])

Execute an SQL statement and return the boolean result.

Parameters

string $query
array $bindings

Return Value

bool

at line 86
int affectingStatement(string $query, array $bindings = [])

Run an SQL statement and get the number of rows affected.

Parameters

string $query
array $bindings

Return Value

int

at line 94
bool unprepared(string $query)

Run a raw, unprepared query against the PDO connection.

Parameters

string $query

Return Value

bool

at line 102
array prepareBindings(array $bindings)

Prepare the query bindings for execution.

Parameters

array $bindings

Return Value

array

at line 113
mixed transaction(Closure $callback, int $attempts = 1)

Execute a Closure within a transaction.

Parameters

Closure $callback
int $attempts

Return Value

mixed

Exceptions

Throwable

at line 120
void beginTransaction()

Start a new database transaction.

Return Value

void

at line 127
void commit()

Commit the active database transaction.

Return Value

void

at line 134
void rollBack()

Rollback the active database transaction.

Return Value

void

at line 141
int transactionLevel()

Get the number of active transactions.

Return Value

int

at line 149
array pretend(Closure $callback)

Execute the given callback in "dry run" mode.

Parameters

Closure $callback

Return Value

array