/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

0 vote308 views1 answer
Laravel php 8 ububtu
PHP Laravel
1 vote321 views2 answers
Get the unique rows from table laravel
PHP Laravel
0 vote280 views1 answer
Laravel breeze rquire
PHP Laravel
0 vote326 views1 answer
Laravel validatrion check should be null
PHP Laravel
1 vote335 views1 answer
Laravel add auto increment
PHP Laravel
0 vote325 views1 answer
Laravel database engine innodb
PHP Laravel
15 votes361 views3 answers
Pass data to blade laravel
PHP Laravel
1 vote303 views2 answers
Belongs to many laravel
PHP Laravel
1 vote352 views1 answer
Publish config laravel
PHP Laravel
47 votes408 views6 answers
Laravel create seeder
PHP Laravel