insert array to database with query builder and unset array when find same value

Question

im want to insert array to db with query builder on laravel controller, and i get error, I also haven't found a way to prohibit the same data from entering the database

my foreach :

  $like = '123';
  foreach($list as $data) {
    $filter = array_filter($data, function ($item) use ($like) {
        if (stripos($item['number'], $like) !== false) {
           return true;
        }
        return false;
    });
  }

im trying to dd($filter); and get array like this :

^ array:3 [▼
1 => array:2 [▼
    "number" => "123"
    "desc" => "tester1"
]
2 => array:2 [▼
    "number" => "578"
    "desc" => "tester2"
]
4 => array:2 [▼
    "number" => "123"
    "desc" => "tester3"
]

my query builder

   DB::table('myData')->insert(
     ['number' => $filter['number'], 'desc' =>$filter['desc']
   );

error log in line $filter['number']:

Undefined index: number

Answer 1

You have to use foreach loop:

foreach($filter as $item)
{
    DB::table('myData')->insert(
         ['number' => $item['number'], 'desc' =>$item['desc']
    );
}