/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 vote109 views1 answer
Laravel change db connection on the fly
PHP
1 vote101 views1 answer
Sustituir caracteres especiales php
PHP
1 vote113 views1 answer
Wordpress get username
PHP
0 vote117 views1 answer
Get word between two characters php
PHP
92 votes167 views6 answers
Replace String in PHP
PHP
73 votes103 views6 answers
Iterate through array javascript
PHP
1 vote97 views1 answer
Feof
PHP
3 votes105 views5 answers
Implode and explode in php
PHP
0 vote106 views2 answers
"codeigniter 4" cart
PHP
27 votes100 views4 answers
How to color php text
PHP