/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

12 votes337 views6 answers
Run seeder in migration laravel
PHP Laravel
3 votes409 views1 answer
Send multiple mail in laravel
PHP Laravel
0 vote415 views1 answer
Uncaught Error: Class 'Illuminate\Foundation\Application' in laravel bootstrap
PHP Laravel
3 votes366 views2 answers
Valdidate laravel if falid
PHP Laravel
0 vote356 views3 answers
GetClientOriginalExtension laravel
PHP Laravel
46 votes405 views6 answers
Clear laravel cache
PHP Laravel
53 votes472 views6 answers
Laravel where in
PHP Laravel
12 votes388 views3 answers
Laravel db::query update
PHP Laravel
0 vote363 views1 answer
Laravel vue browser cache auto clear
PHP Laravel
0 vote386 views1 answer
Creer un modele laravel
PHP Laravel