@php $q = request("q", ""); $results = collect(); if (mb_strlen($q) >= 3) { $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 = $r->article_translation_content; $clean = preg_replace('/\x40php.*?\x40endphp/si', ' ', $clean); $clean = preg_replace('/\x7B!!.*?!!\x7D/s', ' ', $clean); $clean = preg_replace('/\x7B\x7B.*?\x7D\x7D/s', ' ', $clean); $clean = preg_replace('/]*>.*?<\/style>/si', ' ', $clean); $clean = preg_replace('/]*>.*?<\/script>/si', ' ', $clean); $clean = preg_replace('/]*>.*?<\/nav>/si', ' ', $clean); $clean = strip_tags($clean); $clean = html_entity_decode($clean, ENT_QUOTES, 'UTF-8'); $clean = preg_replace('/(?clean_excerpt = trim(preg_replace('/\s+/', ' ', $clean)); } }@endphp

Search

@if(mb_strlen($q) >= 3) @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 3 characters.

@else

Search REDD Plus Articles

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

@endif