检索到的 JSON 冗余数据 - json redundant data retrieved

json redundant data retrieved

本文关键字：冗余数据 JSON 检索 | 更新日期: 2023-09-26

$('.editBtn').click(function(){//EDIT BUTTON EVENT
        $.getJSON('edit.php?url='+encodeURI($(this).siblings('a').attr('id'))+'&action=edit',function(data){
           $.each(data, function(key, val) {
               alert(key+': '+val);
            });
        });
    });//EDIT BUTTON END

这是有问题的PHP部分：

elseif($_GET['action']=='edit'){
$output=$mysql->getDb()->query("select * from video
    where url='{$_GET['url']}'")->fetchAll();
header("content-type: application/json");
echo json_encode($output[0]);
}

发生的情况是，单击.editBtn按钮时，警报会弹出0:value0, 1:value1,...然后再次出现，但以一种我只希望它被name0:value0, name1:value1,...的方式

这是怎么回事？

附言.php独立运行：

{"url":"www.vimeo.com'/20721308","0":"www.vimeo.com'/20721308","title":"Dis-patch Festival R.I.P.","1":"Dis-patch Festival R.I.P.","description":"Sadly, the last goodbyes to the Dis-patch Festival Belgrade edition in this tribute '"R.I.P.'" video collage. The end is always the beginning...","2":"Sadly, the last goodbyes to the Dis-patch Festival Belgrade edition in this tribute '"R.I.P.'" video collage. The end is always the beginning...","country":"serbia","3":"serbia","postDate":"2011-05-07 05:56:04","4":"2011-05-07 05:56:04","views":null,"5":null}

不完全确定此处返回的格式。通常框架SQL对象以自己的对象格式返回数据集。您可能希望将 SQL 数据传递到数组对象中，然后将数组json_encode回客户端。

$returnData = array(
    'name' => $output[0]->name,
    'videopath' => $output[1]->videopath 
);
echo json_encode(array('success'=>1, 'data'=>$returnData));