how to send json object with arrays inside it by using laravel eloquent?other question for this is how to change json object to array?

Question

i was returning data in json format from controller,using eloquent and it was working fine.At one location i need to implement a further condition on data so i implement where condition on elequent's retrieved data and then implement toJson() on it and return data but data was not in previous format.

//in AppCategory model
public function products(){
      return $this->hasMany('App\AppProduct','category_id');
  }

//in controller
 public function category_products($id)
    {
        $category=AppCategory::where('status', 1)->findorfail($id);
        $result=$category->products->where('status',1);
        $result->toJson();
        return $result;
    }

//output
{
 "0": {
       "id": 13,
       "category_id": 1,
       "title": "shoe 1",
       "description": "test description",
       "price": "200",
       "status": 1,
       "created_at": "2019-09-11 12:33:51",
       "updated_at": "2019-09-07 17:00:19"
      }
}

//required output (enclosed data into '[]' instead of '{}')
[
 "0": {
       "id": 13,
       "category_id": 1,
       "title": "shoe 1",
       "description": "test description",
       "price": "200",
       "status": 1,
       "created_at": "2019-09-11 12:33:51",
       "updated_at": "2019-09-07 17:00:19"
      }
]

score 1 · Answer 1 · answered Sep 11 '19 at 20:30

you should use get method to return collections and return response as json ,so update your code to :

//in controller
 public function category_products($id)
    {
        $category=AppCategory::where('status', 1)->findorfail($id);
        $result=$category->products->where('status',1)->get();
        return response()->json($result);
    }

score 0 · Answer 2 · answered Sep 11 '19 at 19:55

0

You need to return the json object result:

return $result->toJson();

answered Sep 11 '19 at 19:55

Christopher Francisco

15,672
28
94
206

same result with this and 'json formatter' didn't work on return data too. – Rana Nadeem Sep 11 '19 at 20:35

score 0 · Answer 3 · answered Sep 11 '19 at 20:21

in AppCategory model

public function products(){
      return $this->hasMany('App\AppProduct','category_id')->where('status',1);
}

in controller

public function category_products($id)
    {
        $category=AppCategory::where('status', 1)->findorfail($id);
        $result=$category->products;
        $result->toJson();
        return $result;
    }

output

[
    {
     "id": 13,
     "category_id": 1,
     "title": "shoe 1",
     "description": "test description",
     "price": "200",
     "status": 1,
     "created_at": "2019-09-11 12:33:51",
     "updated_at": "2019-09-07 17:00:19"
    }
]

Note I am still confused that how to get required result without changing the model.Thanks in advanced to clear this.

how to send json object with arrays inside it by using laravel eloquent?other question for this is how to change json object to array?

3 Answers3