Laravel post request search query

public function search(Request $request){
    // Get the search value from the request
    $search = $request['search'];

    // Search in the title and body columns from the posts table
    $posts = Post::query()
        ->where('title', 'LIKE', "%{$search}%")
        ->orWhere('body', 'LIKE', "%{$search}%")
        ->get();

    // Return the search view with the resluts compacted
    return view('search', compact('posts'));
}

Similar codes

3 votes270 views1 answer
Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add index `users_userable_type_userable_id_index`(`userable_type`, `userable_id`)
PHP
1 vote237 views2 answers
Laravel collection
PHP
3 votes274 views2 answers
Sum of multidimensional array in php
PHP
0 vote344 views2 answers
How to pass bearer token in swagger in laravel
PHP Laravel
20 votes283 views5 answers
Carbon date from format
PHP
17 votes278 views6 answers
Php migrate
PHP
0 vote282 views1 answer
Php slim inspect request method
PHP
8 votes269 views3 answers
Laravel model::query
PHP
1 vote310 views1 answer
Laravel fixed character limit
PHP Laravel
0 vote270 views2 answers
Php json request get value
PHP