/PHP/Laravel/Get data from 2 table in response laravel

Get data from 2 table in response laravel

$p1 = DB::table('properties')
        ->where('address', 'test')
        ->select('name', 'address');

$p2 = DB::table('properties_x')
         ->where('address', 'test')
         ->select('name', 'address');

$p = $p1->unionAll($p2);

DB::table(DB::raw("({$p->toSql()}) AS p"))
->mergeBindings($p)
->select('name', 'address')
->paginate(10);

Source: stackoverflow.com

Similar codes

4 votes305 views2 answers
Laravel eloquent get data without duplicates
PHP Laravel
1 vote298 views1 answer
How get the latest arraye value in laravel
PHP Laravel
0 vote309 views2 answers
Unique sql queries laravel
PHP Laravel
3 votes323 views2 answers
Different days in carbon laravel between different dates
PHP Laravel
2 votes356 views1 answer
Go back URL in Laravel
PHP Laravel
0 vote310 views2 answers
Loop foreach laravel with number
PHP Laravel
1 vote325 views2 answers
Laravel eloquent with query extra parameter
PHP Laravel
18 votes319 views1 answer
Schema::default string laravel
PHP Laravel
0 vote318 views1 answer
Laravel console example
PHP Laravel
1 vote305 views1 answer
Check if delete query was successful laravel
PHP Laravel