/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

2 votes134 views2 answers
Laravel custom model primary Key
PHP Laravel
46 votes158 views6 answers
Laravel make controller with model
PHP Laravel
1 vote131 views3 answers
Laravel invoice toturial
PHP Laravel
1 vote122 views2 answers
Laravel add attribute to model
PHP Laravel
0 vote120 views1 answer
How to put external file in laravel listener class
PHP Laravel
0 vote124 views1 answer
Laravel face-auth
PHP Laravel
14 votes135 views6 answers
Redirect back laravel
PHP Laravel
2 votes124 views1 answer
Laravel crud generator
PHP Laravel
0 vote126 views1 answer
Error: Class '\App\Models\User' not found in file D:\teraNinga\mazadat\vendor\laravel\framework\src\Illuminate\Auth\EloquentUserProvider.php on line 183
PHP Laravel
7 votes157 views3 answers
Laravel seed migrate
PHP Laravel