php - 通过 PHP 将 MySQL 转换为 JSON

Question

让我作为序言，我知道这个问题已经在这里被问过很多次了(即 here 在其他页面中)，我已经搜索了每个答案并尝试了解决方案，但不断得到一个空的 json 数组。

我有一个 mysql 查询，如下所示:

$myQuery = $wpdb->get_results('SELECT player_name, player_team, 
SUM(ruckContests) AS contests FROM afl_master 
WHERE player_team = "COLL" AND year = 2019 AND ruckContests > 0 
GROUP BY player_id ORDER BY contests DESC LIMIT 2');

此查询的输出如下:

Array ( [0] => stdClass Object ( [player_name] => Brodie Grundy [player_team] => COLL [contests] => 661 ) [1] => stdClass Object ( [player_name] => Mason Cox [player_team] => COLL [contests] => 51 ) )

我想要做的是将其转换为 php 中的以下 json 对象:

{
 player_name: "Brodie Grundy", 
 player_team: "COLL", 
 contests: 661
},
{
 player_name: "Mason Cox", 
 player_team: "COLL", 
 contests: 51
}

我已经使用方法 here 尝试过 mysql_fetch_array() 以及 fetch_assoc()但无济于事。如果您能提供任何帮助，我将不胜感激。

<小时/>

评论中推荐的这个简单解决方案有效:

json_encode($myQuery)

Answer 1

$JsonData=array();
foreach($myQuery as $val){


            $JsonData[]='
               {
                 "player_name": "'.$val->player_name.'", 
                 "player_team": "'.$val->player_team.'", 
                 "contests": $val->contests 
               }
             ';
}
$expectedJson=implode(',',$JsonData);