Laravel Searching multiple tables with one query

Today, We want to share with you Laravel Searching multiple tables with one query.In this post we will show you wordpress plugin require another plugin, hear for laravel eloquent join 3 tables we will give you demo and example for implement.In this post, we will learn about how to fetch data from multiple table in laravel with an example.

Laravel Searching multiple tables with one query

There are the Following The simple About Laravel Search in multiple tables Full Information With Example and source code.

As I will cover this Post with live Working example to develop Searching multiple tables with one query with Laravel, so the Searching through multiple table using laravel eloquent is used for this example is following below.

READ :  Advanced Search using Laravel 5.8 Example

laravel 6 search engine Examples

Searching through multiple table using laravel eloquent

$products = Tamilrokers::whereHas('bollywood', function($query) use($querystr) {
    $query->where('bollywood_name', 'like', '%'.$querystr.'%');
})->orWhere('movie_name','LIKE','%'.$querystr.'%')->orderBy($order, 'asc')->get();

Search multiple tables for a search term in Laravel

Album::where('title', 'LIKE', '%' .$querystr. '%')
    ->orWhereHas('students', function($q) use ($querystr) {
        return $q->where('name', 'LIKE', '%' . $querystr . '%');
    })
    ->orWhereHas('teachers', function($q) use ($querystr) {
        return $q->where('title', 'LIKE', '%'. $querystr . '%');
    })->get();

E-junkie: Sell digital downloads online

E-junkie Provides a Copy-paste buy-now, and cart buttons for selling downloads, codes and tangible products on any website, blog, social media, email and messenger!

Also see:

  1. The Top 10+ Best Webinar Software Platforms For 2020-2021
  2. Build Your Future Godaddy Careers And Jobs
  3. Introduction To Web Hosting Services

Using Joins in Laravel Eloquent Queries

$productCategory = Tamilrokers::where('id', $moviId)
    ->leftJoin('bollywood', 'movies.bollywood', '=', 'bollywood.id')
    ->select('movies.id','bollywood.name')->first();

Laravel search from two tables

$licenses = Tamilrokers::where('pname','like','%'.$querystr.'%')
    ->orWhere('licenseNumber','like','%'.$querystr.'%')
    ->orWhereHas('client', function ($query) use ($querystr) {
        $query->where('name', 'like', '%'.$querystr.'%');
    })
    ->orderBy('id')
    ->paginate(20);

Laravel search DB with multiple tables

// Get the teacher ID
$teacher = DB::table('students')
                ->select(DB::raw('CONCAT_WS(" ",`firstname`,`lastname`) as `fullname`,id'))
                ->having('fullname', 'LIKE', '%'.$querystr.'%')
                ->first();

// $teacher output:
stdClass Object
(
    [fullname] => Modi Narendra
    [id] => 58
)

// Query the records using the gathered ID
$records->where('stud_id', $teacher->id)
        ->orWhere('title', 'LIKE', '%'.$querystr.'%');

Search in multiple tables by eloquent query

$results = DB::query('SELECT id, title FROM ( 
SELECT id, title,info_member FROM `members` where `info_member` LIKE "%'.$querystr.'%" OR `title_en` LIKE "%'.$querystr.'%"
UNION ALL
SELECT id, info_client FROM `clients` where `info_client` LIKE "%'.$querystr.'%" OR `content` LIKE "%'.$querystr.'%"
) temp_table
ORDER BY `id` desc
LIMIT 0, 10
')

Web Programming Tutorials Example with Demo

Read :

READ :  Angular ng blur Event Example

Summary

You can also read about AngularJS, ASP.NET, VueJs, PHP.

I hope you get an idea about laravel eloquent join 2 tables.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.