/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 vote272 views1 answer
Call to undefined function App\Http\Controllers\curl_init()
PHP
18 votes301 views6 answers
Set timezone in php
PHP
1 vote300 views2 answers
Get the current page id in wordpress
PHP
6 votes318 views2 answers
Laravel : commande introuvable
PHP Laravel
5 votes325 views2 answers
Current loggedin user laravel
PHP Laravel
57 votes312 views6 answers
File_get_contents php
PHP
0 vote294 views1 answer
Get data in array formate in Laravel
PHP
1 vote357 views1 answer
/laravel-2020-07-27.log" could not be opened
PHP Laravel
6 votes275 views1 answer
How to get input value in php variable
PHP
1 vote332 views1 answer
Laravel dusk run failed tests
PHP Laravel