Creating an Associate array from Laravel db

Question

At the moment I am building an app with flutter but my Laravel api controller doesn't give the appropiate multidimensional array back. I would like to have { [0]=> array,[1]=>array, etc}. If anyone knows the fix for this it would be highly appreciated

public function index()
    {
        $payments = Payment::all();

        return $payments;
    }

And it returns this:

[
    {
        "id": 1,
        "description": "test",
        "price": "9.00",
        "currency": "EUR",
        "status": "open",
        "deleted_at": null,
        "created_at": "2020-08-10T09:50:52.000000Z",
        "updated_at": "2020-08-10T09:50:52.000000Z"
    },
    {
        "id": 2,
        "description": "test",
        "price": "3.00",
        "currency": "USD",
        "status": "open",
        "deleted_at": null,
        "created_at": "2020-08-13T19:06:23.000000Z",
        "updated_at": "2020-08-13T19:06:23.000000Z"
    }
]

I have tried a lot, this has got me the closest but then i got 1:{ARRAY}

code i tried:

public function index()
    {
        $data = [];
        $payments = Payment::all();
        $id=1;
        foreach($payments as $payment){
            array_push($data,[$id=>$payment]);
            $id++;
        }
        return $data;
    }

Outcome:

[
    {
        "1": {
            "id": 1,
            "description": "test",
            "price": "9.00",
            "currency": "EUR",
            "status": "open",
            "deleted_at": null,
            "created_at": "2020-08-10T09:50:52.000000Z",
            "updated_at": "2020-08-10T09:50:52.000000Z"
        }
    },
    {
        "2": {
            "id": 2,
            "description": "test",
            "price": "3.00",
            "currency": "USD",
            "status": "open",
            "deleted_at": null,
            "created_at": "2020-08-13T19:06:23.000000Z",
            "updated_at": "2020-08-13T19:06:23.000000Z"
        }
    }
    
]

I would like to have:

{
1:{
   "message":"test",
   "price":"9"
   "currency":"EUR"
  },
2:{
   "message":"test",
   "price":"9"
   "currency":"EUR"
}
}

please prove code which had tried – kamalesh kumar yadav Aug 14 '20 at 08:03 — kamalesh kumar yadav, Aug 14 '20 at 08:03
I provided 2 codes i tried but nothing worked – Thomas Wijnands Aug 14 '20 at 09:23 — Thomas Wijnands, Aug 14 '20 at 09:23

score 0 · Answer 1 · answered Aug 14 '20 at 06:06

0

Try this one

public function index()
{
    $payments = Payment::get()->toArray();

    return $payments;
}

answered Aug 14 '20 at 06:06

Amit Patel

167
2
12

That returns the same unfortunately – Thomas Wijnands Aug 14 '20 at 06:20

score 0 · Accepted Answer · answered Aug 14 '20 at 06:28

0

Try Also this

  public function index(){
    $payments = Payment::all();
    return response()->json([$payments]);
 }

answered Aug 14 '20 at 06:28

Kavindu Chathuranga

222
1
14

that returns the same with an extra [] in the beginning – Thomas Wijnands Aug 14 '20 at 06:37
what is the JSON format you need? [ { "codes":[], "names":[] } ] or any other? – Kavindu Chathuranga Aug 14 '20 at 06:43
i need an indexed multidimentional array, so [0]=>{"id": 1, "description": "test", "price": "9.00", "currency": "EUR", "status": "open", "deleted_at": null, "created_at": "2020-08-10T09:50:52.000000Z", "updated_at": "2020-08-10T09:50:52.000000Z" } – Thomas Wijnands Aug 14 '20 at 06:50

Creating an Associate array from Laravel db

2 Answers2