PHP MySQLデータをJSONで書き出し

PHP久しいので近いうち復習する。

<?php

ini_set('display_errors', "On");
ini_set('error_reporting', E_ALL);

ExecuteQuery("select * from test_table");

function Connection(){

  try{
    return new PDO("mysql:host=localhost;dbname=test_db;charset=utf8","usr","pwd");
  } catch (PDOException $e) {
    echo $e->getMessage();
    exit;
  }

}

function ExecuteQuery($sql){

  foreach(Connection()->query($sql) as $row){
    $result[]=array(
      'id'=>$row['id'],
      'name'=>$row['name'],
      'age'=>$row['age']
    );
  }
  header('Content-type: application/json');
  echo json_encode($result, JSON_UNESCAPED_UNICODE);
}

<?php

ini_set('display_errors', "On");

ini_set('error_reporting', E_ALL);

ExecuteQuery("select * from test_table");

function Connection(){

try{

return new PDO("mysql:host=localhost;dbname=test_db;charset=utf8","usr","pwd");

} catch (PDOException $e) {

echo $e->getMessage();

exit;

}

function ExecuteQuery($sql){

foreach(Connection()->query($sql) as $row){

$result[]=array(

'id'=>$row['id'],

'name'=>$row['name'],

'age'=>$row['age']

);

}

header('Content-type: application/json');

echo json_encode($result, JSON_UNESCAPED_UNICODE);

}