convert json array to json object in laravel 5.7

Question

I am getting data from database using join query in laravel & pass to json and getting some result in array but I want object that I given below

Controller code:

$resultPastActivity= DB::table('table_user_create_activity')
                            ->join('table_sub_category','table_user_create_activity.selected_activity_id', '=', 'table_sub_category.sub_category_id')
                            ->select('sub_category_name','area','activity_type','activity_date','start_time','end_time')
                            ->whereDate('activity_date', '<', $todayDate)
                            ->where('user_id',$user_id)
                            ->get();

 return response()->json(['success' => '1','data' =>$resultPastActivity]);

The above code will give following json that is in array actually i want json in object

{
    "success": "1",
    "data": [
        {
            "sub_category_name": "Badminton",
            "area": "Rankala lake",
            "activity_type": "1",
            "activity_date": "2018-01-12",
            "start_time": "15:04:49",
            "end_time": "20:05:69"
        },
        {
            "sub_category_name": "Football",
            "area": "Devakar panad",
            "activity_type": "1",
            "activity_date": "2018-01-15",
            "start_time": "15:04:49",
            "end_time": "20:05:69"
        },
    ]
}



i want json as follows
{
    "success": "1",
    "data": {
        {
            "sub_category_name": "Badminton",
            "area": "Rankala lake",
            "activity_type": "1",
            "activity_date": "2018-01-12",
            "start_time": "15:04:49",
            "end_time": "20:05:69"
        },
        {
            "sub_category_name": "Football",
            "area": "Devakar panad",
            "activity_type": "1",
            "activity_date": "2018-01-15",
            "start_time": "15:04:49",
            "end_time": "20:05:69"
        },
    }
}

quick way to do this `$obj = json_decode(json_encode($array));` — Sunil Kashyap, May 23 '19 at 12:12
Possible duplicate of [how to convert multidimensional array to object in php?](https://stackoverflow.com/questions/9169892/how-to-convert-multidimensional-array-to-object-in-php) — Sunil Kashyap, May 23 '19 at 12:13
i tried but get same json with array? suggest another method — smita patil, May 23 '19 at 12:20
That is not valid json, to have multiple objects in a structure you need to wrap it in an array, you want an object of multiple objects which is not possible — mrhn, May 23 '19 at 12:28

Palak Jadav · Answer 1 · 2019-05-23T12:48:43.160

0

try this, json_encode($json, JSON_FORCE_OBJECT) JSON_FORCE_OBJECT

$result=array();
$result["0"]=$resultPastActivity;
$json=json_encode((object)$result,JSON_FORCE_OBJECT);
return response()->json(['success' => '1','data' =>$json]);

edited May 23 '19 at 12:48

answered May 23 '19 at 12:07

Palak Jadav

1,202
1
11
23

i tried but can not get expected result plz need another solutions – smita patil May 23 '19 at 12:10
yes This is result contain "\0" that is not expected { "success": "1", "data": "{\"0\":{\"0\":{\"sub_category_name\":\"Badminton\",\"area\":\"Rankala lake\",\"activity_type\":\"1\",\"activity_date\":\"2018-01-12\",\"start_time\":\"15:04:49\",\"end_time\":\"20:05:69\"},\"1\":{\"sub_category_name\":\"Football\",\"area\":\"Devakar panad\",\"activity_type\":\"1\",\"activity_date\":\"2018-01-15\",\"start_time\":\"15:04:49\",\"end_time\":\"20:05:69\"},}}}" – smita patil May 23 '19 at 12:40
Please show the updated answer add $json=json_encode((object)$result,JSON_FORCE_OBJECT); type cast $result with (object) @smitapatil – Palak Jadav May 23 '19 at 12:49

score 0 · Answer 2 · answered May 23 '19 at 13:48

0

The one you want is not a valid JSON, you can check it here: https://jsonformatter.curiousconcept.com/

So, you cannot create such an output, and, if you force it, the application that will receive it won't parse it correctly, so it doesn't make sense.

answered May 23 '19 at 13:48

Leonardo Rossi

2,922
2
20
28

convert json array to json object in laravel 5.7

2 Answers2