/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

9 votes242 views4 answers
Php reverse array
PHP
1 vote305 views2 answers
Laravel sail alias
PHP Laravel
2 votes239 views2 answers
Filename php
PHP
2 votes255 views5 answers
Add key value array php
PHP
0 vote286 views1 answer
Disable laravel cors
PHP Laravel
0 vote267 views1 answer
Mysqldump is not recognized as an internal or external command laravel
PHP Laravel
0 vote333 views2 answers
From user id to user role wordpress
PHP Wordpress
0 vote289 views1 answer
@lang laravel blade
PHP Laravel
5 votes274 views2 answers
Laravel filter
PHP Laravel
1 vote269 views1 answer
Codeigniter distinct
PHP