$input |
= |
[ 'exec_statement' => 'CREATE TABLE fruit
(name, color, calories];
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, color, calories
FROM fruit
ORDER BY name', 'fetch_style' => 'PDO::FETCH_ASSOC', ] |
$test_output |
= |
[ 'result' => [ 'object' => 'PDO instance', 'int' => 7, 'pdostatement' => 'PDOStatement instance', 'rows' => [ 0 => [ 'name' => 'apple', 'color' => 'red', 'calories' => '150', ], 1 => [ 'name' => 'banana', 'color' => 'yellow', 'calories' => '250', ], 2 => [ 'name' => 'kiwi', 'color' => 'brown', 'calories' => '75', ], 3 => [ 'name' => 'lemon', 'color' => 'yellow', 'calories' => '25', ], 4 => [ 'name' => 'orange', 'color' => 'orange', 'calories' => '300', ], 5 => [ 'name' => 'pear', 'color' => 'green', 'calories' => '150', ], 6 => [ 'name' => 'watermelon', 'color' => 'pink', 'calories' => '90', ], ], ], 'php_version' => '7.1.33 Linux x86_64', ] |