/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 vote286 views1 answer
Remove default product data tabs
PHP
0 vote298 views5 answers
Django-tool-bar
PHP
0 vote290 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP
59 votes304 views6 answers
Laravel seeder
PHP
0 vote284 views1 answer
Return redirect to another url in controller laravel
PHP
0 vote276 views1 answer
Function wp_maintenance_mode() { 763
PHP
0 vote302 views1 answer
Laravel reload relationship
PHP
8 votes306 views2 answers
Eloquent get query log
PHP
-1 vote313 views1 answer
Sometimes validation in laravel
PHP
4 votes294 views1 answer
Php reading a file line by line
PHP