将结果查询到 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 = [{"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_ ...etc
谁能告诉我应该怎么做才能将数据转换为 json 格式?
这应该有帮助:
var accountData = {!! $accounts !!};
使用{!! $var !!}
时,刀片引擎不会转义您的数据。
相关文章:
- Laravel数据表无效的JSON响应
- Laravel数组转换为json格式
- Laravel-在文本区域中包装JSON响应
- 在Morris.js和Laravel 5中循环JSON数据
- 为什么这个 Angular 脚本无法检索 Laravel 4 生成的 JSON
- Laravel 将 json 传递给 vue.js
- 如何在Laravel + AngularJs上的脚本标签中读取JSON
- 将结果查询到 JSON Laravel 5
- Laravel PHP-从DB到PHP再到JS到HTML的自定义JSON对象
- Laravel:在view blade中解析这个json数据
- AngularJS(前端)和Laravel(后端)中的JSON/Arrays中为NULL
- JavaScript/jQuery问题使用AJAX/JSON在Laravel 4
- 通过POST将JSON数据从AngularJS传递到Laravel Controller
- 从laravel控制器访问json/object到ajax调用时未定义错误
- 使用Laravel 5.3, json withCallback添加了奇怪的斜杠和星号
- 使用laravel从json中删除“quot”
- 清晰地将大型JSON数组从Laravel传递到Javascript
- 从laravel中的控制器返回JSON响应
- 在laravel上返回json
- Laravel 3 JSON and jQuery getJSON