How to convert array to a json object?

Question

I am trying to push values in an array and it comes like

[{"Monday":"11:30"},{"Monday":"12:00"},{"Monday":"23:00"},{"Tuesday":"11:30"},{"Tuesday":"12:00"},{"Tuesday":"23:00"}]

But I want it to be an object like


{

"Monday" : [ "11:30", "12:00", "23:00"]

"Tuesday" : ["11:30","12:00","23:00"]

}

Here is my code snippet

$timings = DoctorTimings::where('doctor_id', '=', $input['doctor_id'])->get();
$doctor_timings = [];

foreach($timings as $timing) {
    $day_id = $timing->day_id;
    $time_slot_id = $timing->time_slot_id;
    $day_id =  Days::where('id', '=', $day_id)->first()->day;
    $time_id = DB::table('time_slot')->where('id', '=', $time_slot_id)->select('time')->first()->time;  
    array_push($doctor_timings, array($day_id => $time_id));
}

$doctorTimings = json_encode($doctor_timings);

echo $doctorTimings;

Instead of json_encode($doctor_timings); try collect($doctor_timings)->toJson() — Digvijay
– Digvijay, Commented May 29, 2020 at 13:52
collect($doctor_timings)->toJson() is same as json_encode($doctor_timings) ... just another way to converting it. — Ryuk
– Ryuk, Commented May 29, 2020 at 14:29

Ersoy · Accepted Answer · 2020-05-31 04:22:36Z

1

You may use mapToGroups to get in the requested format. But i don't know your table structure so i got these;

[{"Monday":"11:30"},{"Monday":"12:00"},{"Monday":"23:00"},{"Tuesday":"11:30"},{"Tuesday":"12:00"},{"Tuesday":"23:00"}]

put into the collection (assuming your eloquent collection returns like that)

$timings = collect([
        ["Monday" => "11:30"],
        ["Monday" => "12:00"],
        ["Monday" => "23:00"],
        ["Tuesday" => "11:30"],
        ["Tuesday" => "12:00"],
        ["Tuesday" => "23:00"]
    ]);

    return $timings->mapToGroups(function ($item) {
        $day = array_key_first($item);

        return [$day => $item[$day]];
    });

which prints these;

{
  "Monday": [
    "11:30",
    "12:00",
    "23:00"
  ],
  "Tuesday": [
    "11:30",
    "12:00",
    "23:00"
  ]
}

Edit: (the same array you posted in online used here + same function i used for solution)

$days = ["Monday", "Monday"];
$time = ["11:30", "12:30"];
$doctor_timings = [];
for ($i = 0; $i < sizeof($days); $i++) {
    $day_id = $days[$i];
    $time_id = $time[$i];
    array_push($doctor_timings, [$day_id => $time_id]);
}

return collect($doctor_timings)->mapToGroups(function ($item) {
    $day = array_key_first($item);

    return [$day => $item[$day]];
});

which prints

{"Monday":["11:30","12:30"]}

edited May 31, 2020 at 4:22

answered May 29, 2020 at 17:42

Ersoy

9,8046 gold badges40 silver badges54 bronze badges

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

8 Comments

Ryuk Over a year ago

$doctor_timings=[]; $day_id =  Monday  ; $time_id = 11:30  ; array_push($doctor_timings, array($day_id => $time_id)) ; result = [ { "Monday" : "11:30" } ]

.... Instead of returning an array like ["Monday" => "11:30"] it gives me the above result

Ersoy Over a year ago

@Demon37 i don't get what do you mean ?

Ryuk Over a year ago

I didn't work for me. I am obtaining $day and $time from 2 different tables based on user_id and then pushing it into an empty array. There is a difference between your and mine array structure e.g. my $day_id = Monday; $time_id=11:30; array_push($doctor_timings, $day_id => $time_id); gives me this [ { " Monday " : " 11:30 " } ] thing not this [ ["Monday"=>"11:30"] ]

Ryuk Over a year ago

Can you please elaborate here sandbox.onlinephpfunctions.com/code/…

Ersoy Over a year ago

@Demon37 i edited and used your function + with my "same" solution

|

Collectives™ on Stack Overflow

How to convert array to a json object?

1 Answer 1

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related