javascript - 如何在 php 中使用 json_encode 方法发送行？

Question

我的投资表中有行数。我需要检索所有这些内容并使用 json_encode 将它们发回。
这是我的代码

$project_code = $_GET['id'];    
$sql = "select * from investment where project_code = '$project_code'";
        $result = mysql_query($sql);
        while($x1 = mysql_fetch_array($result))
        {   $detail = $x1['detail'];
            $sector = $x1['sector'];
        }   
        echo json_encode(array(
            'a' => $detail,
            'b' => $sector
            ));

在 javascript 中我编写了以下脚本:

$('#myHref').change(function(){
        var value = $('#myHref').val();
        $.get('display_acc.php',{id:value},function(data)
         {
    data = JSON.parse(data); 
     $( '#a' ).html(data.a);
     $( '#b' ).html(data.b);
    });
       });  

这里我的问题是它只返回最后一行的数据。我想接收所有行的数据。

我必须在此处显示 id a 和 b 我用表格来显示它。提前致谢

Answer 1

这应该可以解决问题:

--OP解释后编辑--

PHP

$project_code = (int)$_GET['id'];    //better put (int) before to avoid SQL Injection
$sql = "select detail, sector from investment where project_code = '$project_code'"; //better to maintain if you set only the fields you will use
    $result = mysql_query($sql);
    $return = array('detail'=> array(), 'sector' => array()); //here you can put empty return array or set detail and sector key. Your choice will have impact in your front-end

    $return['my_extra_var' ] = $my_extra_var;
    $i = 0;
    while($x1 = mysql_fetch_array($result))
    {
        $return['table'][$i]['detail'] = $x1['detail'];
        $return['table'][$i]['sector'] = $x1['sector'];
        $i++;
    }   
    echo json_encode($return);

Javascript

... your ajax request ...
data = JSON.parse(data);
var tableData = data.table;
$.each(tableData, function(index, value) {
    $('#tableData').append('<tr><td>'+value.detail+'</td><td>'+value.sector+'</td></tr>'); //append row to tbody
});

HTML

<table>
    <thead>
        <th>Details</th>
        <th>Sector of Investment</th>
    </thead>
    <tbody id="tableData">
    </tbody>
 </table>