html
<!-- 动态加载下拉选项 -->
<div class="layui-inline">
<label class="layui-form-label">类型:</label>
<div class="layui-input-inline">
<select name="platform_name" class="select_wd120">
<option value="">全部</option>
</select>
</div>
</div>
js
// 返回值
$.ajax({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
},
url: "../../query/grecord/name",
method: 'get',
dataType: 'json',
success: function(res) {
status = res.status;
mer_name = res.data;
if (status == 200) {
options = "<option value=''>全部</option>";
for (var i = 0; i < mer_name.length; i++) {
var t = mer_name[i];
options += '<option value="' + t.platform_name + '">' + t.platform_name + '</option>';
}
$("select[name='platform_name']").html(options);
form.render('select');
} else if (res.status == 403) {
layer.msg('错误', {
offset: '15px',
icon: 2,
time: 3000
})
}
}
});
控制器中
public function quenameGrecord()
{
$data= DB::table('bg')->groupBy('name')->get('name')->toArray();
if ($data) {
return response()->json(['status'=>200,'data'=>$data]);
}else{
return response()->json(['status'=>403]);
}
}