@php $q = request("q", ""); $results = collect(); if (strlen($q) >= 2) { $results = DB::table("content_article AS a") ->join("content_article_translation AS t", "a.article_id", "=", "t.article_translation_parent_id") ->where("a.article_portal_category", "redd-plus") ->where("a.article_status", "ACTIVE") ->whereNotIn("a.article_category", ["GLOSSARY", "ARTICLE"]) ->where(function($w) use ($q) { $w->where("t.article_translation_title", "LIKE", "%{$q}%") ->orWhere("t.article_translation_content", "LIKE", "%{$q}%"); }) ->select("a.article_id", "a.article_code", "t.article_translation_title", "t.article_translation_content", "t.article_translation_language") ->orderBy("a.article_date", "desc") ->limit(20) ->get(); foreach ($results as $r) { $clean = preg_replace('/]*>.*?<\/style>/si', '', $r->article_translation_content); $clean = preg_replace('/]*>.*?<\/script>/si', '', $clean); $clean = preg_replace('/]*>.*?<\/nav>/si', '', $clean); $r->clean_excerpt = strip_tags($clean); } }@endphp

Search

@if(strlen($q) >= 2) @if($results->count())

{{ $results->count() }} result(s) for "{{ $q }}"

@foreach($results as $r)

{{ $r->article_translation_title }}

{{ Str::limit($r->clean_excerpt, 200) }}

 @endforeach @else

No results found

No articles match "{{ $q }}". Try a different keyword.

@endif @elseif($q !== "")

Search term too short

Please enter at least 2 characters.

@else

Search REDD+ Articles

Enter a keyword above to search for articles, news and publications.

@endif