Php json_encode array and object array

Question

I need to create a json with this format:

{
  "reservs": [
    {
      "ResId": "58",
      "time": "2020-05-15 19:41:50",
      "boxEntering": null,
      "boxClosing": null,
      "active": "1",
      "UserId": "29",
      "BoxId": "4",
      "boxPlace": null,
      "box": {
        "id": "4",
        "Nom": "Hortillonages",
        "Lat": "49.8953",
        "Lng": "2.31034",
        "place": "0",
        "placeMax": "9"
      }
    }
  ]
}

in entries, a $header who check the user token(not use for my problem) $table the table returned from PDO::FETCHASSOC from sql SELECT request My php code:

function generateJson($table, headerChecker $header){
    $final = array();
    foreach ($table as $item) {
        $box = array(
            "id" => $item["id"],
            "Nom" => $item["Nom"],
            "Lat" => $item["Lat"],
            "Lng" => $item["Lng"],
            "place" => $item["place"],
            "placeMax" => $item["placeMax"]
        );
        $reserv = array(
            "ResId" => $item["ResId"],
            "time" => $item["time"],
            "boxEntering" => $item["boxEntering"],
            "boxClosing" => $item["boxClosing"],
            "active" => $item["active"],
            "UserId" => $item["UserId"],
            "BoxId" => $item["BoxId"],
            "boxPlace" => $item["boxPlace"],
        );
        $reserv["box"] = $box;
        array_merge($final,$reserv);
    }
    $arr = array("reservs" => $table);
    $header->tokenJson($arr);
    echo json_encode($arr);
}

I have this result

{"reservs": [
        {
            "ResId": "58",
            "time": "2020-05-15 19:41:50",
            "boxEntering": null,
            "boxClosing": null,
            "active": "1",
            "UserId": "29",
            "BoxId": "4",
            "boxPlace": null,
            "id": "4",
            "Nom": "Hortillonages",
            "Lat": "49.8953",
            "Lng": "2.31034",
            "place": "0",
            "placeMax": "9",
            "QRID": "",
            "boxToken": ""
        }]
}

I think the Json format eror is in the array_merge function. What add array function can I use to not remove the Box object

Not the problem, but you may be better off using $final[] = $reserv; — Nigel Ren
– Nigel Ren, Commented Jun 16, 2020 at 20:24
use $reserv['box'] = []; before you assigning the array to it, or cast it as array. — RST
– RST, Commented Jun 16, 2020 at 20:35

AbraCadaver · Accepted Answer · 2020-06-16 21:07:49Z

1

Your problem is that you are not assigning the return of array_merge and using the wrong variable $table. Just dynamically append to $final:

foreach ($table as $item) {
    // this all appears good
    //
    $reserv["box"] = $box;
    $final[] = $reserv;             // append to $final
}
$arr = array("reservs" => $final);  // use $final
$header->tokenJson($arr);
echo json_encode($arr);

Merge the new $reserv into $final and assign it to $final, then use $final.

edited Jun 16, 2020 at 21:07

answered Jun 16, 2020 at 20:27

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tom Jumel Over a year ago

It works! Thank you. Very early error: '( But now with multiple table data, the json output just one iteration

AbraCadaver Over a year ago

Fixed. I tried to use your code, but array_merge was not correct.

Razin Abid · Accepted Answer · 2020-06-16 20:31:50Z

Try this one

function generateJson($table, headerChecker $header){
    $final = array();
    foreach ($table as $item) {
        $box = array(
            "id" => $item["id"],
            "Nom" => $item["Nom"],
            "Lat" => $item["Lat"],
            "Lng" => $item["Lng"],
            "place" => $item["place"],
            "placeMax" => $item["placeMax"]
        );
        $reserv = array(
            "ResId" => $item["ResId"],
            "time" => $item["time"],
            "boxEntering" => $item["boxEntering"],
            "boxClosing" => $item["boxClosing"],
            "active" => $item["active"],
            "UserId" => $item["UserId"],
            "BoxId" => $item["BoxId"],
            "boxPlace" => $item["boxPlace"],
        );
        $reserv["box"] = $box;
        $final[] = $reserv;
    }
    $arr = array("reservs" => $final);
    $header->tokenJson($arr);
    echo json_encode($arr);
}

Collectives™ on Stack Overflow

Php json_encode array and object array

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related