$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 FROM fruit', 'driver_options' => [ 'PDO::ATTR_CASE' => 'PDO::CASE_UPPER', ], ] |
$test_output |
= |
[ 'result' => [ 'pdo' => 'PDO instance', 'int' => 7, 'pdostatement' => 'PDOStatement instance', 'bool' => true, 'array' => [ 0 => [ 'NAME' => 'apple', 0 => 'apple', 'COLOUR' => 'red', 1 => 'red', ], 1 => [ 'NAME' => 'banana', 0 => 'banana', 'COLOUR' => 'yellow', 1 => 'yellow', ], 2 => [ 'NAME' => 'kiwi', 0 => 'kiwi', 'COLOUR' => 'brown', 1 => 'brown', ], 3 => [ 'NAME' => 'lemon', 0 => 'lemon', 'COLOUR' => 'yellow', 1 => 'yellow', ], 4 => [ 'NAME' => 'orange', 0 => 'orange', 'COLOUR' => 'orange', 1 => 'orange', ], 5 => [ 'NAME' => 'pear', 0 => 'pear', 'COLOUR' => 'green', 1 => 'green', ], 6 => [ 'NAME' => 'watermelon', 0 => 'watermelon', 'COLOUR' => 'pink', 1 => 'pink', ], ], ], 'php_version' => '7.1.33 Linux x86_64', ] |