Loop where like % in query ()

You sure you want AND not Or ? Its pretty easy : It ok. thanks

$query = Article::query()
   >where("ar_type_id = '$type_id'")
  ->andWhere("ar_active = 'Y'")
  ->orderBy("ar_view_count DESC")
  ->limit(9);
   foreach($arr_tag as $tag) {
            $query->andWhere("ar_name LIKE '%$tag' ");
  };
  $result = $query->execute();

Also you should use bound parameters.

You can set the search as function; Below is some code just like above.

 public function search($search)
    {
        $bits = explode(' ',trim($search));
        $query = $this->query()->orderBy('id')->where('title like :search:',['search'=>'%'.array_shift($bits).'%']);

        foreach($bits as $key => $bit){
            $query->andWhere("title like :search{$key}:",["search{$key}"=>'%'.$bit.'%']);
        }
        return $query->execute();
    }