$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)', 0 => 'SELECT name, colour, calories
FROM fruit
WHERE calories < ? AND colour = ?', 1 => [ 'PDO::ATTR_CASE' => 'PDO::CASE_UPPER', ], 'input_parameters' => [ 0 => 175, 1 => 'yellow', ], 'fetch_style' => 'PDO::FETCH_ASSOC', ] |
$test_output |
= |
[ 'result' => [ 'pdo' => 'PDO instance', 'int' => 7, 'pdostatement' => 'PDOStatement instance', 'bool' => true, 'rows' => [ 0 => [ 'NAME' => 'lemon', 'COLOUR' => 'yellow', 'CALORIES' => '25', ], ], ], 'php_version' => '7.1.33 Linux x86_64', ] |