/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

24 votes176 views6 answers
For each php
PHP
1 vote165 views1 answer
Read pdf text php
PHP
43 votes149 views5 answers
Laravel create controller command
PHP
0 vote195 views1 answer
Textarea laravel migration
PHP Laravel
0 vote165 views1 answer
H1 wordpress theme php
PHP
7 votes167 views3 answers
Disable admin bar wordpress
PHP
1 vote156 views1 answer
Php load specific post id on language
PHP
0 vote224 views1 answer
How to set timezone for iran in laravel
PHP Laravel
2 votes173 views5 answers
Add key value array php
PHP
0 vote196 views1 answer
Laravel relationship retrieve data
PHP Laravel