How to convert Laravel collection array to json

Question

How can i convert this Laravel collection array to json format like below.

//All records from users table.
$users = DB::table('users')->get();

// Required json format.
return '{
          "data": [

            {
              "DT_RowId": "row_1",
              "id": "Tiger",
              "clear": "Nixon",
              "fsssf": "System Architect",
              "tex": "t.nixon@datatables.net",
              "created_at": "Edinburgh",
              "updated_at": "Edinburgh"
            },
             {
              "DT_RowId": "row_2",
              "id": "Tiger",
              "clear": "Nixon",
              "fsssf": "System Architect",
              "tex": "t.nixon@datatables.net",
              "created_at": "Edinburgh",
              "updated_at": "Edinburgh"
            }

          ],
  "options": [],
  "files": []
}';

Sorry for the basic question,but i am unable to convert this into this jso.

In Laravel 9 you can still use the `@json` directive. Also you can find this in the Laravel docs: https://laravel.com/docs/9.x/blade#rendering-json — Rodrigo, Aug 14 '22 at 05:37

score 34 · Accepted Answer · edited Apr 21 '19 at 11:11

34

Have a look at the documentation.

You can use toJson(),to convert the collection to json object.

$users = DB::table('users')->get()->toJson();
dd($users);

You can also can do this in simple php way by using json_encode function

$users = json_encode($users);

Have a look at this link

Greetings and happy coding!

edited Apr 21 '19 at 11:11

Ahmed Aboud

1,232
16
19

answered Sep 18 '17 at 10:17

Asim Shahzad

1,438
11
18

score 11 · Answer 2 · edited Dec 18 '18 at 10:33

11

If you are looking into doing if for a blade template you can use the @json Blade directive, like so:

<script type="text/javascript">
    var PARAMS = @json($params)
</script>

P.S.Tested in Laravel 5.6

edited Dec 18 '18 at 10:33

aefxx

24,835
6
45
55

answered May 22 '18 at 00:45

Yevgeniy Afanasyev

37,872
26
173
191

Gaurav Gupta · Answer 3 · 2019-09-13T18:51:40.937

5

add "use Response;"

return Response::json([
    'data' => $value
], 200);

hope this helps!

edited Sep 13 '19 at 18:51

answered Sep 18 '17 at 09:58

Gaurav Gupta

1,588
2
14
21

this has to be the most useful, just add the response libraries and good to go – Herb Sep 13 '19 at 16:51

score 2 · Answer 4 · edited Sep 30 '20 at 09:50

2

Couple of things you can do, you can use default method ->toJson() with the user collection like this

$users = DB::table('users')->get();
$users->toJson();

If you do have troubles with it them you can php build in json_encode method here is the full documentation http://php.net/manual/en/function.json-encode.php

$users = DB::table('users')->get();
json_encode($users)

Hope this helps!

edited Sep 30 '20 at 09:50

STA

30,729
8
45
59

answered Sep 18 '17 at 09:24

Muaaz Rafi

1,469
2
15
23

score 1 · Answer 5 · answered Sep 18 '17 at 09:17

1

if we you laravel 5.5 then you should use eloquent-resources

answered Sep 18 '17 at 09:17

Tarun Saini

85
3

score 0 · Answer 6 · answered Oct 18 '20 at 21:56

in Laravel you can easily serialize your php object like so :

public static function getLocataireByCin($cin)
    {
        return Locataire::where('cin', $cin)
            ->first()
            ->toJson(JSON_PRETTY_PRINT);
    }

and then retrieve it on your frontEnd (using js/jquery for example ) :

$("#cinLocataire").keyup(function () {
        $.ajax({
            url: "{{ route('Caisse.store') }}",
            type: "POST",
            data: {
                cin: $(this).val()
            },
            success: function (locataireData) {
                var locataire = JSON.parse(locataireData); // <-- here
                console.log(
                    locataire.nom
                );
            },
        })
    });

How to convert Laravel collection array to json

6 Answers6