将结果查询到 JSON Laravel 5 - query results to json laravel 5

我希望能够在应用程序视图的级联下拉列表中使用来自 laravel 的查询结果。

首先，我只想看到查询结果转换为我可以在 laravel 的下拉列表中使用的内容。

我有以下代码：

$accounts = json_encode(DB::table('accounts')->join('Bookmakers', 'bookmakers.id', '=', 'accounts.bookmaker_id')->get());

这会产生：（来自 dd（$accounts））

"[{"id":"1","customer_id":"1","bookmaker_id":"1","balance":"0","profit":"0","created_at":"2016-01-28 17:44:33","updated_at":"2016-01-28 17:44:33","name":"William Hill","type":"Bookmaker","commission":"0"},{"id":"2","customer_id":"1","bookmaker_id":"2","balance":"0","profit":"0","created_at":"2016-01-28 17:44:33","updated_at":"2016-01-28 17:44:33","name":"Betfred","type":"Bookmaker","commission":"0"},{"id":"3","customer_id":"1","bookmaker_id":"3","balance":"0","profit":"0","created_at":"2016-01-28 17:44:33","updated_at":"2016-01-28 17:44:33","name":"Skybet","type":"Bookmaker","commission":"0"},{"id":"1","customer_id":"2","bookmaker_id":"1","balance":"0","profit":"0","created_at":"2016-01-28 17:44:33","updated_at":"2016-01-28 17:44:33","name":"William Hill","type":"Bookmaker","commission":"0"},{"id":"2","customer_id":"2","bookmaker_id":"2","balance":"0","profit":"0","created_at":"2016-01-28 17:44:33","updated_at":"2016-01-28 17:44:33","name":"Betfred","type":"Bookmaker","commission":"0"},{"id":"3","customer_id":"2","bookmaker_id":"3","balance":"25","profit":"0","created_at":"2016-01-28 17:44:33","updated_at":"2016-01-28 17:44:33","name":"Skybet","type":"Bookmaker","commission":"0"},{"id":"6","customer_id":"2","bookmaker_id":"6","balance":"100","profit":"0","created_at":"2016-01-28 17:44:33","updated_at":"2016-01-28 17:44:33","name":"DS","type":"Exchange","commission":"2"}]"

这看起来基本上没问题。

我

正在尝试将其分配给我视图中的 javascript 变量：

var accountData = {{ $accounts }};

但它是这样出来的...

var accountData =     [{&quot;id&quot;:&quot;1&quot;,&quot;customer_id&quot;:&quot;1&quot;,&quot;bookmaker_id&quot;:&quot;1&quot;,&quot;balance&quot;:&quot;0&quot;,&quot;profit&quot;:&quot;0&quot;,&quot;created_at&quot;:&quot;2016-01-28 17:44:33&quot;,&quot;updated_at&quot;:&quot;2016-01-28 17:44:33&quot;,&quot;name&quot;:&quot;William Hill&quot;,&quot;type&quot;:&quot;Bookmaker&quot;,&quot;commission&quot;:&quot;0&quot;},{&quot;id&quot;:&quot;2&quot;,&quot;customer_id&quot;:&quot;1&quot;,&quot;bookmaker_id&quot;:&quot;2&quot;,&quot;balance&quot;:&quot;0&quot;,&quot;profit&quot;:&quot;0&quot;,&quot;created_at&quot;:&quot;2016-01-28 17:44:33&quot;,&quot;updated_at&quot;:&quot;2016-01-28 17:44:33&quot;,&quot;name&quot;:&quot;Betfred&quot;,&quot;type&quot;:&quot;Bookmaker&quot;,&quot;commission&quot;:&quot;0&quot;},{&quot;id&quot;:&quot;3&quot;,&quot;customer_id&quot;:&quot;1&quot;,&quot;bookmaker_id&quot;:&quot;3&quot;,&quot;balance&quot;:&quot;0&quot;,&quot;profit&quot;:&quot;0&quot;,&quot;created_at&quot;:&quot;2016-01-28 17:44:33&quot;,&quot;updated_at&quot;:&quot;2016-01-28 17:44:33&quot;,&quot;name&quot;:&quot;Skybet&quot;,&quot;type&quot;:&quot;Bookmaker&quot;,&quot;commission&quot;:&quot;0&quot;},{&quot;id&quot;:&quot;1&quot;,&quot;customer_id&quot;:&quot;2&quot;,&quot;bookmaker_id&quot;:&quot;1&quot;,&quot;balance&quot;:&quot;0&quot;,&quot;profit&quot;:&quot;0&quot;,&quot;created_at&quot;:&quot;2016-01-28 17:44:33&quot;,&quot;updated_at&quot;:&quot;2016-01-28 17:44:33&quot;,&quot;name&quot;:&quot;William Hill&quot;,&quot;type&quot;:&quot;Bookmaker&quot;,&quot;commission&quot;:&quot;0&quot;},{&quot;id&quot;:&quot;2&quot;,&quot;customer_id&quot;:&quot;2&quot;,&quot;bookmaker_id&quot;:&quot;2&quot;,&quot;balance&quot;:&quot;0&quot;,&quot;profit&quot;:&quot;0&quot;,&quot;created_at&quot;:&quot;2016-01-28 17:44:33&quot;,&quot;updated_at&quot;:&quot;2016-01-28 17:44:33&quot;,&quot;name&quot;:&quot;Betfred&quot;,&quot;type&quot;:&quot;Bookmaker&quot;,&quot;commission&quot;:&quot;0&quot;},{&quot;id&quot;:&quot;3&quot;,&quot;customer_id&quot;:&quot;2&quot;,&quot;bookmaker_id&quot;:&quot;3&quot;,&quot;balance&quot;:&quot;25&quot;,&quot;profit&quot;:&quot;0&quot;,&quot;created_at&quot;:&quot;2016-01-28 17:44:33&quot;,&quot;updated_ ...etc

谁能告诉我应该怎么做才能将数据转换为 json 格式？

这应该有帮助：

var accountData = {!! $accounts !!};

使用{!! $var !!}时，刀片引擎不会转义您的数据。