/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 vote204 views1 answer
Fetch method and class in codeigniter
PHP
0 vote223 views1 answer
How to disable auto prediction html input in laravel
PHP
8 votes257 views4 answers
If user logged in wordpress
PHP Wordpress
5 votes207 views2 answers
Autoload.php
PHP
0 vote174 views1 answer
Display product page title in field cf7
PHP
0 vote233 views1 answer
Laravel collection nth method
PHP Laravel
9 votes215 views2 answers
Laravel query count raw
PHP
3 votes226 views1 answer
Laravel send post request from controller
PHP
0 vote247 views1 answer
Wp mail
PHP Wordpress
2 votes218 views2 answers
Get message validator failed laravel
PHP