Laravel,将数据从原始查询转换为JSON [英] Laravel, converting data from raw query to JSON
本文介绍了Laravel,将数据从原始查询转换为JSON的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
总而言之,任何人都可以帮我转换一些将从模型(基于RAW查询)返回到JSON的数据。
所以在我的控制器中有类似的东西:
public function get_index(){
$ data = Something :: getDataFromRawQuery();
返回View :: make('....') - > with('data',$ data);
}
所以我的问题是如何将JSON数据从控制器转发到视图?<这是查询:
$ apps = DB :: query ('SELECT a.name,
a.desc,
a.sig,
ar.rate
FROM
INNER JOIN something_else ar
ON (a.id = ar.something_id)
ORDER BY ar.rate DESC'
);
返回$ apps;
解决方案
DB :: query
返回一个简单的数组,所以直接在它上面调用 json_encode
:
$ data = Something :: getDataFromRawQuery();
返回View :: make('....') - > with('data',json_encode($ data));
Hy all, can anyone help me with converting some data which will be return from model(based on the RAW query) into JSON.
So in my controller i have something like:
public function get_index() {
$data = Something::getDataFromRawQuery();
return View::make('....')->with('data', $data);
}
So my question is how to forward JSON data to the view from controller?
Here is the query:
$apps = DB::query('SELECT a.name,
a.desc,
a.sig,
ar.rate
FROM something a
INNER JOIN something_else ar
ON (a.id=ar.something_id)
ORDER BY ar.rate DESC'
);
return $apps;
解决方案
DB::query
returns a simple array, so just call json_encode
directly on it:
$data = Something::getDataFromRawQuery();
return View::make('....')->with('data', json_encode($data));
这篇关于Laravel,将数据从原始查询转换为JSON的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文