/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 vote224 views2 answers
Upload video in laravel
PHP
0 vote226 views1 answer
Wordpresss loop through object
PHP
3 votes169 views2 answers
Php link to page
PHP
0 vote256 views1 answer
Wordpress disable file mods
PHP Wordpress
1 vote243 views2 answers
Laravel Cannot add foreign key constraint
PHP
0 vote213 views1 answer
Valid image extensions in php
PHP
48 votes280 views6 answers
Laravel joins
PHP Laravel
0 vote250 views1 answer
Laravel list unique indexes
PHP
1 vote232 views2 answers
Javascript php loop
PHP
0 vote210 views1 answer
Test not found page symfiny in dev
PHP