How to add hard coded values into a JSON response-CodePudding

I am trying to use PHP to generate JSON to specifically take a desired shape. Below is a snippet of my PHP code:

      if($con){
    $sql="select * from people";
    $result=mysqli_query($con,$sql);
    if($result){
          header("Content-Type: JSON");
        $i=0;
        while($row = mysqli_fetch_assoc($result)){
            $response[$i]['gender']=$row['gender'];
            $response[$i]['first']=$row['first'];
            
            $i  ;
        }
        echo json_encode($response, JSON_PRETTY_PRINT);
    }
}

Here is my current JSON response

  [
   {
      "gender":"male",
      "first":"Angela"
   },
   {
      "gender":"female",
      "first":"Krista"
   }
]

And here is my desired response:

{
    "inputs": [
      {

        "values": {
          "gender": "male",
          "first": "Angela"
        }
      },
      {
        "values": {
          "gender": "female",
          "first": "Krista"
        }
      }
    ]
  }

CodePudding user response：

Almost, add 'values', then your items then add $response to the items array, also the content type for json is application/json, and you should predefine $response as an array, else your get undefined warning and null value when using it in json_encode if the query is empty.

...
        header("Content-Type: application/json");
        $response = [];
        while($row = mysqli_fetch_assoc($result)){
            $response[]['values'] = [
                'gender' => $row['gender'],
                'first' => $row['first']
            ];
        }
        echo json_encode(['inputs' => $response], JSON_PRETTY_PRINT);
...

CodePudding user response：

This way:

if ($con) {
    $sql = "select * from people";
    $result = mysqli_query($con,$sql);
    if ($result) {
        header("Content-Type: JSON");
        $response = [
            "inputs" => []
        ];
        while ($row = mysqli_fetch_assoc($result)){
            $response["inputs"][] = [
                "values" => [
                    'gender' => $row['gender'],
                    'first' => $row['first']
                ]
            ];
        }
        echo json_encode($response, JSON_PRETTY_PRINT);
    }
}