СА
Size: a a a
СА
ДК
public function searchEvents(Request $request)
{
$count = Event::where('name', 'like', '%' . $request->keywords . '%')
->orWhere('description', 'like', '%' . $request->keywords . '%')->count();
$partip_arr = explode(" ", $request->keywords);
// $events = Event::where('name', 'like', '%' . $request->keywords . '%')
// ->orWhere('description', 'like', '%' . $request->keywords . '%')
// ->orWhere('participants', 'like', '%' . mb_strtolower($request->keywords) . '%')
// ->offset(request('offset'))
// ->take(20)
// ->latest()->get();
$events = Event::where('name', 'like', '%' . $partip_arr[0] . '%' )
->orWhere('description', 'like', '%' . $partip_arr[0] . '%')
->orWhere('participants', 'like', '%' . mb_strtolower($partip_arr[0]) . '%');
foreach ($partip_arr as $index => $value) {
if ($index === 0) {
continue;
}
$events->orWhere('name', 'like', '%' . $value . '%' )
->orWhere('description', 'like', '%' . $value . '%')
>orWhere('participants', 'like', '%' . mb_strtolower($value) . '%');
}
$events = $events->offset(request('offset'))
->take(20)
->latest()->get();
// $events = Event::where('name', 'like', '%' . $request->keywords . '%')
// ->orWhere('description', 'like', '%' . $request->keywords . '%')
// ->latest()->get();
return response()->json(['events' => $events, 'count' => $count]);
}
AS
T
ДК
T
СА
ДК
СА
AS
AS
ДК
ДК
AS
ЕК
T
ЕК
AS
ДК