$statement
$statement : resource|\mysqli_stmt
The prepared statement itself.
Prepared query for SQLite3
$query : \CodeIgniter\Database\Query
Holds the prepared query object that is cloned during execute.
$db : \CodeIgniter\Database\BaseConnection|\CodeIgniter\Database\MySQLi\Connection
A reference to the db connection to use.
__construct(\CodeIgniter\Database\ConnectionInterface $db)
Constructor.
| \CodeIgniter\Database\ConnectionInterface | $db |
prepare(string $sql, array $options = array(), string $queryClass = 'CodeIgniter\\Database\\Query') : mixed
Prepares the query against the database, and saves the connection info necessary to execute the query later.
NOTE: This version is based on SQL code. Child classes should override this method.
| string | $sql | |
| array | $options | Passed to the connection's prepare statement. |
| string | $queryClass |
_prepare(string $sql, array $options = array()) : mixed
Prepares the query against the database, and saves the connection info necessary to execute the query later.
NOTE: This version is based on SQL code. Child classes should override this method.
| string | $sql | |
| array | $options | Passed to the connection's prepare statement. Unused in the MySQLi driver. |
execute(array $data) : \CodeIgniter\Database\ResultInterface
Takes a new set of data and runs it against the currently prepared query. Upon success, will return a Results object.
| array | $data |