#1
|
PDOStatement::fetch
|
(/* $exec_statement = "CREATE TABLE fruit (name, colour, calories INT); INSERT INTO fruit VALUES ('apple', 'red', 150), ('banana', 'yellow', 250), ('kiwi', 'brown', 75), ('lemon', 'yellow', 25), ('orange', 'orange', 300), ('pear', 'green', 150), ('watermelon', 'pink', 90)" */ /* $statement = "SELECT name, colour, calories FROM fruit" */ PDO::FETCH_ASSOC)
|
#2
|
PDOStatement::fetch
|
(/* $exec_statement = "CREATE TABLE fruit (name, colour, calories INT); INSERT INTO fruit VALUES ('apple', 'red', 150), ('banana', 'yellow', 250), ('kiwi', 'brown', 75), ('lemon', 'yellow', 25), ('orange', 'orange', 300), ('pear', 'green', 150), ('watermelon', 'pink', 90)" */ /* $statement = "SELECT name, colour, calories FROM fruit" */ PDO::FETCH_BOTH)
|
#3
|
PDOStatement::fetch
|
(/* $exec_statement = "CREATE TABLE fruit (name, colour, calories INT); INSERT INTO fruit VALUES ('apple', 'red', 150), ('banana', 'yellow', 250), ('kiwi', 'brown', 75), ('lemon', 'yellow', 25), ('orange', 'orange', 300), ('pear', 'green', 150), ('watermelon', 'pink', 90)" */ /* $statement = "SELECT name, colour, calories FROM fruit" */ /* $driver_options = [PDO::ATTR_CASE => PDO::CASE_UPPER] */ PDO::FETCH_OBJ)
|
#4
|
PDOStatement::fetch
|
(/* $exec_statement = "CREATE TABLE fruit (name, colour, calories INT); INSERT INTO fruit VALUES ('apple', 'red', 150), ('banana', 'yellow', 250), ('kiwi', 'brown', 75), ('lemon', 'yellow', 25), ('orange', 'orange', 300), ('pear', 'green', 150), ('watermelon', 'pink', 90)" */ /* $statement = "SELECT name, colour, calories FROM fruit WHERE calories <= :calories AND colour = :colour" */ /* $input_parameters = [":calories" => 150, ":colour" => "red"] */ PDO::FETCH_ASSOC)
|
#5
|
PDOStatement::fetch
|
(/* $exec_statement = "CREATE TABLE fruit (name, colour, calories INT); INSERT INTO fruit VALUES ('apple', 'red', 150)" */ /* $statement = "SELECT name, colour, calories FROM fruit WHERE calories 150 AND colour = 'red'" */ /* $driver_options = [PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL] */)
|