/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

1 vote319 views1 answer
Program logic for second largest number in an array in php
PHP
1 vote370 views2 answers
Laravel log to console
PHP Laravel
1 vote332 views1 answer
Echo post content by slug
PHP
2 votes324 views1 answer
Php modules list ubuntu
PHP
46 votes384 views6 answers
Laravel make controller with model
PHP Laravel
0 vote336 views2 answers
Calculator in php
PHP
0 vote446 views1 answer
Cache.backend.null
PHP
1 vote362 views1 answer
Hex to dec php
PHP
0 vote330 views3 answers
Move_uploaded_file
PHP
0 vote313 views1 answer
Brew php version
PHP