从数据库获取数据插入页面

控制器中代码 记得在路由表中添加路由：

public function postCategoryList(){$result = DB::connection('news')->table('categories')->select('id','pid','name')->where('is_delete',0)->whereIn('pid',[12,18,28])->get();$ret = new \stdclass;$ret->ret = 0;$ret->msg= '';$ret->data=$result;return response()-> json($ret);}

js中的文件：

for(var i = 0; i < (data.length > 5 ? 5 : data.length); i++){newsStr += '<div class="file">\<span>\<img src="'+ ptr.resUrl +'images/textimg/icon_txt.gif" style="vertical-align: middle; margin-right: 2px;">\<a target="_blank" href="'+ ptr.baseUrl +'/newsinfomation?id='+ data[i].id +'">'+ data[i].title +'</a>\</span> \<span style="float:right;">'+ data[i].created_at.substr(0,10) +'</span>\</div>'}

newStr暂时存放代码

$('.postWrap‘ ).html(newsStr);输出到页面上