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

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

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);输出到页面上