/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

0 vote182 views1 answer
Onclick call route laravel
PHP Laravel
-1 vote181 views2 answers
Laravel updateorcreate multiple records
PHP
3 votes154 views1 answer
Laravel remove controller
PHP Laravel
6 votes173 views6 answers
Laravel folder permission
PHP Laravel
0 vote148 views1 answer
Wordpress php query randomise
PHP
0 vote212 views1 answer
Guzzlehttp/guzzle version with laravel-websockek
PHP Laravel
0 vote129 views1 answer
Run php server mac
PHP
0 vote149 views1 answer
Laravel eloquent difference create and insert
PHP
1 vote262 views1 answer
Drupal 9 enable PHP errors
PHP Drupal
8 votes153 views3 answers
Validate time in laravel
PHP Laravel