dongwen9947 2016-01-06 12:21
浏览 22
已采纳

如果找不到数组项,则跳过插入?

I am currently inserting data from json api url into my database, except some arrays are not completed filled out resulting in 'undefined index' errors.

Is there a good way to deal with this? Ofcourse checking each item index with an if isset statement and only setting it if it is available would work but that would be quite tedious for each entry.

        foreach($items['response']['groups'] as $item) {
            foreach($item['items'] as $item) {
                Bar::firstOrCreate([
                    'lat' => $item['venue']['location']['lat'],
                    'long' => $item['venue']['location']['lng'],
                    'postalCode' => $item['venue']['location']['postalCode'],
                    'city' => $item['venue']['location']['city'],
                    'state' => $item['venue']['location']['state'],
                    'country' => $item['venue']['location']['country'],
                    'address' => $item['venue']['location']['address'],
                    'rating' => $item['venue']['rating'],
                    'website' => $item['venue']['url'],
                ]);
            }
        }
  • 写回答

5条回答 默认 最新

  • dongshijiao6890 2016-01-06 12:32
    关注

    use simplest way like:

    foreach($items['response']['groups'] as $item1) {
                foreach($item1['items'] as $item) {
                    Bar::firstOrCreate([
                        'lat' => isset($item['venue']['location']['lat'])?$item['venue']['location']['lat'] : '',
                        'long' => isset($item['venue']['location']['lng'])?$item['venue']['location']['lng'] : '',
                        'postalCode' => isset($item['venue']['location']['postalCode'])?$item['venue']['location']['postalCode'] : '',
                        'city' => isset($item['venue']['location']['city'])?$item['venue']['location']['city'] : '',
                        'state' => isset($item['venue']['location']['state'])?$item['venue']['location']['state'] : '',
                        'country' => isset($item['venue']['location']['country'])?item['venue']['location']['country'] : '',
                        'address' => isset($item['venue']['location']['address'])?$item['venue']['location']['address'] : '',
                        'rating' => isset($item['venue']['rating'])?$item['venue']['rating'] : '',
                        'website' => isset($item['venue']['url'])?$item['venue']['url'] : '',
                    ]);
                }
            }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(4条)

报告相同问题?

悬赏问题

  • ¥15 CST仿真别人的模型结果仿真结果S参数完全不对
  • ¥15 误删注册表文件致win10无法开启
  • ¥15 请问在阿里云服务器中怎么利用数据库制作网站
  • ¥60 ESP32怎么烧录自启动程序
  • ¥50 html2canvas超出滚动条不显示
  • ¥15 java业务性能问题求解(sql,业务设计相关)
  • ¥15 52810 尾椎c三个a 写蓝牙地址
  • ¥15 elmos524.33 eeprom的读写问题
  • ¥15 用ADS设计一款的射频功率放大器
  • ¥15 怎么求交点连线的理论解?