/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

1 vote364 views1 answer
Laravel eloquent get only field name
PHP Laravel
0 vote374 views1 answer
How use variable in string in laravel
PHP Laravel
0 vote379 views1 answer
Laravel eloquent save method return value
PHP Laravel
0 vote315 views1 answer
Laravel download file from storage with progress bar
PHP Laravel
13 votes313 views6 answers
Laravel array validation
PHP Laravel
18 votes364 views6 answers
Laravel unique validation
PHP Laravel
1 vote368 views1 answer
Laravel plural
PHP Laravel
1 vote391 views1 answer
$posts- links() laravel design error
PHP Laravel
2 votes365 views2 answers
Laravel insert timestamp now
PHP Laravel
7 votes337 views1 answer
Laravel auth user_id
PHP Laravel