mysql - 加入 mySQL 表并为 Ionic 2 应用程序输出 JSON

Question

我正在尝试连接下面的两个表示例；

            demo_one
----------------------------------------
id |    name      | position |     phone
----------------------------------------
 1 |    Moby Dick | Whale    | 1-403-651-4000
 2 |    Jaws      | Shark    | 1-403-651-4000


            demo_two
---------------------------------------------------
id |    name             | type     |   cell
---------------------------------------------------
 1 |    Son of Moby Dick | Whale    | 1-403-651-4000
 2 |    Son of Jaws      | Shark    | 1-403-651-4000

这是我正在寻找的 json 结果

{
"demo_one":[
    {"name":"Moby Dick", "position":"Whale", "phone":"1-403-651-4000"},
    {"name":"Jaws", "position":"Shark", "phone":"1-403-651-4000"}
],

"demo_two":[
    {"name":"Son of Moby Dick", "type":"Whale", "cell":"1-403-651-4000"},
    {"name":"Son of Jaws", "type":"Shark", "cell":"1-403-651-4000"}
]
}

我已经看过一些有关堆栈溢出的示例，但我的 Ionic 2 应用程序需要此 json 输出。

Answer 1

这不需要联接，只需要两个单独的查询。他们的结果被放入 JSON 结果的不同属性中。

$result = array();
$query1 = $pdoconn->query("SELECT * FROM demo_one");
$result['demo_one'] = $query1->fetchAll(PDO::FETCH_ASSOC);
$query2 = $pdoconn->query("SELECT * FROM demo_two");
$result['demo_two'] = $query2->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($result);