Laravel+jQuery地址联动时出现Trying to access array offset on value of type null错误如何解决
错误根因
当Profile表中province_id、city_id、barangay_id字段为null时,控制器中where()->first()查询无匹配数据会返回null,模板中直接读取null的数组属性就会触发报错;同时region下拉未设置默认选中值,导致已有region值时也不会自动触发联动。
解决方案
1 修改控制器edit方法
替换原有的省市区查询逻辑,查询不到数据时返回带空值属性的对象,避免返回null:
// 替换原有三行查询代码 $province_id = Province::where('province_id', $profile->province_id)->first() ?? (object)['province_id' => '']; $city_id = City::where('city_id', $profile->city_id)->first() ?? (object)['city_id' => '']; $code = Barangay::where('code', $profile->barangay_id)->first() ?? (object)['code' => ''];
2 修改模板region下拉默认值
给region下拉设置默认选中值,编辑时自动选中已有值触发联动:
// 替换原有region select代码 {{app('form')->select('region_id', $regions, old('region_id', $profile->region_id), ['class' => 'form-control', 'id' => 'region_id'])}}
3 修改模板JS容错逻辑
3.1 调整address对象赋值,增加空值兼容
var address = { province: '{{$province_id->province_id ?? ''}}', city: '{{$city_id->city_id ?? ''}}', barangay: '{{$code->code ?? ''}}', };
3.2 调整选中逻辑,空值不匹配默认选项
分别修改三个联动请求中的选中判断,增加空值前置判断:
// 省份选中判断修改为 if (address.province && data.province_id == address.province) { selected = ' selected '; } // 城市选中判断修改为 if (address.city && data.city_id == address.city) { selected = ' selected '; } // barangay选中判断修改为 if (address.barangay && data.code == address.barangay) { selected = ' selected '; }
修改完成后,字段为null时不会再触发报错,已有region值时会自动选中并联动加载对应省市区数据,无值时等待用户选择region后再联动加载。
内容的提问来源于stack exchange,提问作者SleepWalker
相关产品推荐
相关产品推荐

