使用getJSON函数从while循环读取数据

Using getJSON function to read from while loop data

本文关键字:循环 读取 数据 while getJSON 函数 使用      更新时间:2023-09-26
<?
    while ($row_previous_bill = $res_previous_bill->fetchRow()) { 
        $bill = $row_previous_bill[6];
        $bill_2 = $row_previous_bill[2];
        $bill_3 = $row_previous_bill[3];
        $bill_4 = $row_previous_bill[1];
        $hotspot_location = $row_previous_bill[5];
        $data[] = array("result_paid" => $bill, "err_code" => 0, "result_payment_details" => $bill_3, "result_time" => $bill_4, "result_location" => $hotspot_location);
    }
    $name = array("response" => $data);
    //sets the response format type
    header("Content-Type: application/json");
    //converts any PHP type to JSON string
    echo json_encode($name);
?>

我正在使用上面的while循环来获取JSON格式,然后我使用这个

$(function() {
    //Set Url of JSON data. make sure callback is set   with a '?' to overcome the cross domain problems with JSON
    var url = "http://127.0.0.1/olem.app/tab/api/js_on.php?get=json&subscribers=incomplete";
    //Use jQuery getJSON method to fetch the data from the url and then create our unordered list with the relevant data.$(username)
    $.getJSON(url,function(json){
        var html = "" + json.result_paid + "";
        //A little animation once fetched
        $('#js_inc_month').animate({ opacity: 0 }, 5, function(){
            $('#js_inc_month').html(html);  
        });
        $('#js_inc_month').animate({ opacity: 1 }, 5);
    });
});

显示<div id="js_inc_month"></div>到目前为止,我没有定义,我如何扭转这个

因为:

$name = array("response" => $data);

你必须像这样访问数据:

json.response[0].result_paid

如果有不清楚的地方,你可以简单地:

console.log(json)