#1
|
PDO::prepare
|
(/* $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)" */ "SELECT name, colour, calories FROM fruit WHERE calories <= :calories AND colour = :colour", /* $input_parameters = [":calories" => 150, ":colour" => "red"] */ /* $fetch_style = PDO::FETCH_ASSOC */)
|
#2
|
PDO::prepare
|
(/* $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)" */ "SELECT name, colour, calories FROM fruit WHERE calories < ? AND colour = ?", /* $input_parameters = [0 => 175, 1 => "yellow"] */ /* $fetch_style = PDO::FETCH_ASSOC */)
|
#3
|
PDO::prepare
|
(/* $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)" */ "SELECT name, colour, calories FROM fruit WHERE calories < ? AND colour = ?", [PDO::ATTR_CASE => PDO::CASE_UPPER], /* $input_parameters = [0 => 175, 1 => "yellow"] */ /* $fetch_style = PDO::FETCH_ASSOC */)
|