/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

13 votes234 views6 answers
How to run laravel project
PHP Laravel
0 vote247 views1 answer
Multiplication des variables sur laravel
PHP Laravel
0 vote224 views1 answer
Laravel htaccess for aws ec2
PHP Laravel
0 vote239 views2 answers
Laravel insert multiple rows from form
PHP Laravel
0 vote324 views1 answer
Laravel Mix npm run production error
PHP Laravel
2 votes240 views1 answer
Set session after login with laravel
PHP Laravel
0 vote246 views1 answer
Populate old value of dropdown laravel
PHP Laravel
13 votes237 views6 answers
Laravel array validation
PHP Laravel
4 votes221 views2 answers
Ubuntu laravel storage permission
PHP Laravel
0 vote267 views1 answer
Laravel select error
PHP Laravel