PdoService
in package
PDO Service - Replaces QubitPdo Uses Laravel Query Builder but provides PDO-style interface
Table of Contents
Methods
- execute() : bool
- Execute statement
- fetchAll() : array<string|int, mixed>
- Fetch all rows
- fetchColumn() : mixed
- Fetch single column value
- fetchOne() : object|null
- Fetch single row
- getConnection() : PDO
- Get raw PDO connection (for edge cases)
Methods
execute()
Execute statement
public
static execute(string $sql[, array<string|int, mixed> $params = [] ]) : bool
Parameters
- $sql : string
- $params : array<string|int, mixed> = []
Return values
boolfetchAll()
Fetch all rows
public
static fetchAll(string $sql[, array<string|int, mixed> $params = [] ][, array<string|int, mixed> $options = [] ]) : array<string|int, mixed>
Parameters
- $sql : string
- $params : array<string|int, mixed> = []
- $options : array<string|int, mixed> = []
Return values
array<string|int, mixed>fetchColumn()
Fetch single column value
public
static fetchColumn(string $sql[, array<string|int, mixed> $params = [] ]) : mixed
Parameters
- $sql : string
- $params : array<string|int, mixed> = []
fetchOne()
Fetch single row
public
static fetchOne(string $sql[, array<string|int, mixed> $params = [] ]) : object|null
Parameters
- $sql : string
- $params : array<string|int, mixed> = []
Return values
object|nullgetConnection()
Get raw PDO connection (for edge cases)
public
static getConnection() : PDO