FETCH_TYPE_NUM
FETCH_TYPE_NUM = 'num' : string
Used to designate that numeric indexes be returned in a result when calling fetch methods
Represents a database statement. Concrete implementations can either use PDOStatement or a native driver
bindValue(string|integer $column, mixed $value, string $type = 'string') : void
Assign a value to a positional or named variable in prepared query. If using positional variables you need to start with index one, if using named params then just use the name in any order.
It is not allowed to combine positional and named variables in the same statement
$statement->bindValue(1, 'a title');
$statement->bindValue('active', true, 'boolean');
$statement->bindValue(5, new \DateTime(), 'date');
string|integer | $column | name or param position to be bound |
mixed | $value | The value to bind to variable in query |
string | $type | name of configured Type class |
execute(array|null $params = null) : boolean
Executes the statement by sending the SQL query to the database. It can optionally take an array or arguments to be bound to the query variables. Please note that binding parameters from this method will not perform any custom type conversion as it would normally happen when calling `bindValue`
array|null | $params | list of values to be bound to query |
true on success, false otherwise
fetch(string $type = 'num') : array|false
Returns the next row for the result set after executing this statement.
Rows can be fetched to contain columns as names or positions. If no rows are left in result set, this method will return false
$statement = $connection->prepare('SELECT id, title from articles');
$statement->execute();
print_r($statement->fetch('assoc')); // will show ['id' => 1, 'title' => 'a title']
string | $type | 'num' for positional columns, assoc for named columns |
Result array containing columns and values or false if no results are left
fetchAll(string $type = 'num') : array
Returns an array with all rows resulting from executing this statement
$statement = $connection->prepare('SELECT id, title from articles');
$statement->execute();
print_r($statement->fetchAll('assoc')); // will show [0 => ['id' => 1, 'title' => 'a title']]
string | $type | num for fetching columns as positional keys or assoc for column names as keys |
list of all results from database for this statement
lastInsertId(string|null $table = null, string|null $column = null) : string
Returns the latest primary inserted using this statement
string|null | $table | table name or sequence to get last insert value from |
string|null | $column | the name of the column representing the primary key |
Loading…