BasePreparedQuery
in package
implements
PreparedQueryInterface
Base prepared query
Interfaces, Classes and Traits
- PreparedQueryInterface
- Prepared query interface
Table of Contents
- $db : BaseConnection
- A reference to the db connection to use.
- $errorCode : int
- The error code, if any.
- $errorString : string
- The error message, if any.
- $query : Query
- Holds the prepared query object that is cloned during execute.
- $statement : object|resource
- The prepared statement itself.
- __construct() : mixed
- Constructor.
- _execute() : bool
- The database dependant version of the execute method.
- _getResult() : mixed
- Returns the result object for the prepared query.
- _prepare() : mixed
- The database-dependent portion of the prepare statement.
- close() : void
- Explicitly closes the statement.
- execute() : ResultInterface
- Takes a new set of data and runs it against the currently prepared query. Upon success, will return a Results object.
- getErrorCode() : int
- Returns the error code created while executing this statement.
- getErrorMessage() : string
- Returns the error message created while executing this statement.
- getQueryString() : string
- Returns the SQL that has been prepared.
- hasError() : bool
- A helper to determine if any error exists.
- prepare() : mixed
- Prepares the query against the database, and saves the connection info necessary to execute the query later.
Properties
$db
A reference to the db connection to use.
protected
BaseConnection
$db
$errorCode
The error code, if any.
protected
int
$errorCode
$errorString
The error message, if any.
protected
string
$errorString
$query
Holds the prepared query object that is cloned during execute.
protected
Query
$query
$statement
The prepared statement itself.
protected
object|resource
$statement
Methods
__construct()
Constructor.
public
__construct(BaseConnection $db) : mixed
Parameters
- $db : BaseConnection
Return values
mixed —_execute()
The database dependant version of the execute method.
public
abstract _execute(array<string|int, mixed> $data) : bool
Parameters
- $data : array<string|int, mixed>
Return values
bool —_getResult()
Returns the result object for the prepared query.
public
abstract _getResult() : mixed
Return values
mixed —_prepare()
The database-dependent portion of the prepare statement.
public
abstract _prepare(string $sql[, array<string|int, mixed> $options = [] ]) : mixed
Parameters
- $sql : string
- $options : array<string|int, mixed> = []
-
Passed to the connection's prepare statement.
Return values
mixed —close()
Explicitly closes the statement.
public
close() : void
Return values
void —execute()
Takes a new set of data and runs it against the currently prepared query. Upon success, will return a Results object.
public
execute(array<string|int, mixed> ...$data) : ResultInterface
Parameters
- $data : array<string|int, mixed>
Return values
ResultInterface —getErrorCode()
Returns the error code created while executing this statement.
public
getErrorCode() : int
Return values
int —getErrorMessage()
Returns the error message created while executing this statement.
public
getErrorMessage() : string
Return values
string —getQueryString()
Returns the SQL that has been prepared.
public
getQueryString() : string
Return values
string —hasError()
A helper to determine if any error exists.
public
hasError() : bool
Return values
bool —prepare()
Prepares the query against the database, and saves the connection info necessary to execute the query later.
public
prepare(string $sql[, array<string|int, mixed> $options = [] ][, string $queryClass = 'CodeIgniter\Database\Query' ]) : mixed
NOTE: This version is based on SQL code. Child classes should override this method.
Parameters
- $sql : string
- $options : array<string|int, mixed> = []
-
Passed to the connection's prepare statement.
- $queryClass : string = 'CodeIgniter\Database\Query'