/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 vote291 views1 answer
Laravel cmd add to column
PHP
0 vote265 views1 answer
Display elements of the array
PHP
0 vote261 views3 answers
Not Found The requested URL was not found on this server. Apache/2.4.48 (Win64) OpenSSL/1.1.1k PHP/8.0.8 Server at localhost Port 80
PHP
0 vote413 views1 answer
Wp query meta in array
PHP Wordpress
0 vote280 views1 answer
Unknown column type "double" requested. Any Doctrine type that you use has to be registered with \Doctrine\DBAL\Types\Type::addType
PHP
7 votes250 views2 answers
How to make a php info
PHP
7 votes335 views3 answers
Laravel seed migrate
PHP Laravel
1 vote348 views2 answers
Wp get meta field value
PHP Wordpress
3 votes316 views2 answers
Laravel validate telephone number
PHP
8 votes281 views3 answers
Php pretty json
PHP