/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 vote119 views1 answer
Undefined type excel
PHP
1 vote115 views1 answer
Get value by today yesterday in laravel
PHP
-2 votes134 views3 answers
Laravel where condition with if
PHP Laravel
2 votes123 views2 answers
Sort a multidimensional array by date element in php
PHP
1 vote99 views1 answer
Laravel http request plain text
PHP Laravel
0 vote118 views1 answer
Symfony 5 server start php bin cosleole
PHP
0 vote118 views1 answer
Infyom Generate From Table
PHP
3 votes132 views1 answer
Laravel Auth Redirect based on role
PHP
0 vote128 views1 answer
Cors prevention
PHP
6 votes116 views3 answers
Laravel ide-helper
PHP