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.

Asim Shahzad · Accepted Answer · 2017-09-18 10:17:30Z

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

$users = json_decode($users);

Have a look at this link

Greetings and happy coding!

Gaurav Gupta · Answer 2 · 2017-09-18 09:58:28Z

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

hope this helps!

Tarun Saini · Answer 3 · 2017-09-18 09:17:59Z

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

Muaaz Rafi · Answer 4 · 2017-09-18 09:24:53Z

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!

Yevgeniy Afanasyev · Answer 5 · 2018-05-22 00:45:45Z

If you are looking into doing if for a blade template you can use @json

like so

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

P.S.Tested in Laravel 5.6

You are here

How to convert Laravel collection array to json

5 Answers

来自 https://stackoverflow.com/questions/46274135/how-to-convert-laravel-collection-array-to-json

友情链接

搜索表单

用户登录

You are here

How to convert Laravel collection array to json

5 Answers

来自 https://stackoverflow.com/questions/46274135/how-to-convert-laravel-collection-array-to-json

友情链接