#1
|
PDOStatement::execute
|
(/* $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" */)
|
#2
|
PDOStatement::execute
|
(/* $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" */ [":calories" => 150, ":colour" => "red"])
|
#3
|
PDOStatement::execute
|
(/* $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 <= ? AND colour = ?" */ [0 => 150, 1 => "red"])
|