php_mysql_web json格式返回所有表中记录

<?php
//echo 'Mysqli操作数据库演示<br/><br/>' ;
//【数据库基本信息】连接数据库所需要的
$db_host ='localhost';  
//注意127.0.0.1与localhost在mysql连接中是不一样的
$db_user ='root';
$db_password ='root';
$db_name ='php';
$db_port = 3306;
//【mysqli方式】连接数据库
$mysqli = new mysqli($db_host, $db_user, $db_password, $db_name, $db_port);

//如果连接不成功的代码处理
if($mysqli->connect_error) {
    echo '数据库连接失败';
    echo '<br />';
    echo '错误编号: '.$mysqli->connect_errno;
    echo '<br />';
    echo '错误描述: '.$mysqli->connect_error;
    exit();
}

$query ='SELECT * FROM t1 ORDER BY id ASC';
$stmt = $mysqli->prepare($query);
$stmt->execute();
$result =$stmt->get_result();
$query_rows = $result->fetch_all(MYSQLI_ASSOC);

//断开数据库连接
$pdo = null;

$result = [
    'success' => true,
    'msg' => '获取数据成功',
    'data' => $query_rows
];

http_response_code(200);
header("Content-type:application/json;charset=UTr-8");
echo json_encode($result);

http://localhost:8080/mysql-web-api.php

{
  "success": true,
  "msg": "获取数据成功",
  "data": [
    {
      "demo": "hello",
      "name": "zt",
      "id": 1
    },
    {
      "demo": "world",
      "name": "lsf",
      "id": 2
    },
    {
      "demo": "mm",
      "name": "zlz",
      "id": 3
    }
  ]
}