/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 vote106 views1 answer
Laravel collection all
PHP
0 vote150 views1 answer
Learndash edit profile link
PHP
1 vote148 views1 answer
Strpos codeigniter php 7
PHP CodeIgniter
0 vote142 views1 answer
How to add recaptcha validation in php
PHP
1 vote111 views2 answers
Php strtotime plus 1 day
PHP
11 votes116 views6 answers
Redirect route with parameters laravel
PHP
5 votes125 views2 answers
A non well formed numeric value encountered laravel
PHP
0 vote114 views1 answer
Switch php version ubuntu 20.04 site:stackoverflow.com
PHP
0 vote115 views1 answer
Wp ajax error handling
PHP Wordpress
0 vote106 views1 answer
Laravel array length
PHP