$input |
= |
[ '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', ], 0 => 'PDO::FETCH_ASSOC', ] |
$test_output |
= |
[ 'result' => [ 'pdo' => 'PDO instance', 'int' => 7, 'pdostatement' => 'PDOStatement instance', 'bool' => true, 'mixed' => [ 'name' => 'apple', 'colour' => 'red', 'calories' => '150', ], ], 'php_version' => '7.1.33 Linux x86_64', ] |