/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

0 vote141 views1 answer
Get records from Sunday to Sunday laravel
PHP Laravel
0 vote137 views2 answers
Laravel display category post by slug
PHP Laravel
0 vote148 views1 answer
Creating default object from empty value laravel
PHP Laravel
1 vote156 views1 answer
Laravel format number blade
PHP Laravel
0 vote161 views1 answer
Last page url in php laravel
PHP Laravel
0 vote101 views1 answer
Js function not defined laravel
PHP Laravel
3 votes247 views2 answers
Two condition in one laravel query
PHP Laravel
49 votes187 views6 answers
Laravel add column to existing table
PHP Laravel
0 vote138 views1 answer
Field doesn't have default value laravel
PHP Laravel
0 vote144 views1 answer
How to check if query is successfully inserted laravel
PHP Laravel