/PHP/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 vote293 views1 answer
Php validate phone number
PHP
3 votes198 views1 answer
Insert rows in migrations laravel
PHP
7 votes174 views2 answers
Php laravel between dates
PHP
0 vote287 views1 answer
Env clear cache laravel
PHP Laravel
0 vote192 views1 answer
Print prety php
PHP
50 votes184 views2 answers
Display errors in codeigniter
PHP
1 vote205 views1 answer
How to alias table name in laravel model
PHP
0 vote243 views1 answer
Search query codeigniter
PHP CodeIgniter
6 votes276 views2 answers
Laravel migration integer
PHP Laravel
0 vote180 views1 answer
Show user only those products which he hasn't buyed laravel eloquent
PHP