按类别格式化 rest Api 组字段

Question

我是 API 的新手，我使用 Codeigniter 从 MySql 数据库产品创建一个 API，该产品具有以下字段：Amount、quantity、customerName、CustomerPhone、CustomerAddress 结果看起来：```[    {        "Id": "1",        "Amount": "21542",        "quantity": "52",        "customerName": "John",        "CustomerPhone": "254215",        "CustomerAddress": "road tvz120",    },```但我希望它看起来像这样：```[    {        "Id": "1",        "Amount": "21542",        "quantity": "52",        "customerInfo":{        "customerName": "John",        "CustomerPhone": "254215",        "CustomerAddress": "rue tvz120"},    },```我的意思是用名称 customer info 将 3 个字段 concernign customers 分组我的PHP代码是```public function index_get($id = 0)    {        if(!empty($id)){            $data = $this->db->get_where("Products", ['Id' => $id])->row_array();        }else{            $data = $this->db->get("Products")->result();        }        $this->response($data, REST_Controller::HTTP_OK);    }```

Answer 1

你的 Products 格式是基于数据库的，因此如果你想改变结果格式，你必须手动构建它。您需要在返回数据之前循环结果。

if(!empty($id)){

    $data = $this->db->get_where("Products", ['Id' => $id])->row_array();

}else{

    $data = $this->db->get("Products")->result();

    $newdata = array();

    foreach($data as $row)

    {

        $newdata[] = array(

            "Id" => $row->id,

            "Amount" => $row->amount,

            "quantity" => $row->quantity,

            "customerInfo" => array(

                "customerName" => $row->customerName,

                "CustomerPhone" => $row->CustomerPhone,

                "CustomerAddress" => $row->CustomerAddress,

            )

        );

    }

    $data = $newdata;

}

$this->response($data, REST_Controller::HTTP_OK);

Answer 2

您不能通过查询执行此操作，您必须遍历结果并将其更改为所需的格式，就像这样 -

if(!empty($id)){

    $result = $this->db->get_where("Products", ['Id' => $id])->result(); 

    // I'll advise to use result() here instead of row_array() so that you don't face any issue when there's only one row.

}else{

    $result = $this->db->get("Products")->result();

}

foreach($result as $res){

    $new_result[] = array(

        "Id"           => $res->Id,

        "Amount"       => $res->Amount,

        "quantity"     => $res->quantity,

        "customerInfo" => array(

                                "customerName"    => $res->customerName,

                                "CustomerPhone"   => $res->CustomerPhone,

                                "CustomerAddress" => $res->CustomerAddress

                                )

                    );

}

$this->response($new_result, REST_Controller::HTTP_OK); // send newly created array instead

看看这是否对您有帮助。