ConnectionInterface
interface ConnectionInterface (View source)
Methods
Get a new raw query expression.
Run a select statement and return a single result.
Run a select statement against the database.
Run a select statement against the database and returns a generator.
Run an insert statement against the database.
Run an update statement against the database.
Run a delete statement against the database.
Execute an SQL statement and return the boolean result.
Run an SQL statement and get the number of rows affected.
Run a raw, unprepared query against the PDO connection.
Prepare the query bindings for execution.
Start a new database transaction.
Commit the active database transaction.
Rollback the active database transaction.
Get the number of active transactions.
Details
Builder
table(Closure|Builder|string $table, string|null $as = null)
Begin a fluent query against a database table.
Expression
raw(mixed $value)
Get a new raw query expression.
mixed
selectOne(string $query, array $bindings = [], bool $useReadPdo = true)
Run a select statement and return a single result.
array
select(string $query, array $bindings = [], bool $useReadPdo = true)
Run a select statement against the database.
Generator
cursor(string $query, array $bindings = [], bool $useReadPdo = true)
Run a select statement against the database and returns a generator.
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.
Laravel Cloud is the best place to deploy Laravel, Nuxt, Express, Hono, Node.js, Bun, Go, Flask, Python, and more, with dedicated infrastructure available on AWS through Laravel Private Cloud.