PreparableInterface
Joomla Database Query Preparable Interface.
Adds bind/unbind methods as well as a getBounded() method to retrieve the stored bounded variables on demand prior to query execution.
| since |
1.0 |
|---|---|
| package |
Joomla Framework |
Methods
bind
Method to add a variable to an internal array that will be bound to a prepared SQL statement before query execution. Also removes a variable that has been bounded from the internal bounded array when the passed in value is null.
bind(string|int key = null, mixed &value = null, int dataType = PDO::PARAM_STR, int length, array driverOptions = array()) : \Joomla\Database\Query\PreparableInterface
| since |
1.0 |
|---|
Arguments
- key
string|intThe key that will be used in your SQL query to reference the value. Usually of the form ':key', but can also be an integer.- value
mixedThe value that will be bound. The value is passed by reference to support output parameters such as those possible with stored procedures.- dataType
intConstant corresponding to a SQL datatype.- length
intThe length of the variable. Usually required for OUTPUT parameters.- driverOptions
arrayOptional driver options to be used.
Response
\Joomla\Database\Query\PreparableInterface
getBounded
Retrieves the bound parameters array when key is null and returns it by reference. If a key is provided then that item is returned.
getBounded(mixed key = null) : mixed
| since |
1.0 |
|---|
Arguments
- key
mixedThe bounded variable key to retrieve.
Response
mixed