尝试在PHP中使用json_encode [英] Trying to json_encode in PHP

问题描述

这是我的小剧本

$item="Inception";

$query="SELECT * FROM items WHERE item = '{$item}' LIMIT 1";
$result=mysql_query($query);
while ($row = mysql_fetch_array($result)) { 
    $item_id = $row['items_id'];
}   

$sql="SELECT AVG(rating) AS AverageRating FROM ratings WHERE item_id = '{$item_id}'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

print(json_encode($row));

输出是这样的:

 {"0":"4.5","AverageRating":"4.5"}

我的问题是:"0"行来自哪里?这正常吗?

My question is: Where is row "0" coming from? Is this normal?

推荐答案

mysql_fetch_array返回一个字符串关联和一个数字关联.单独尝试mysql_fetch_assoc或mysql_fetch_row.

mysql_fetch_array returns both a string association and a numeric association. Try mysql_fetch_assoc or mysql_fetch_row alone.

这篇关于尝试在PHP中使用json_encode的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！