/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 vote179 views2 answers
Php get embed code from youtube url
PHP
16 votes182 views3 answers
Year in php
PHP
9 votes209 views2 answers
A facade root has not been set laravel
PHP
6 votes192 views3 answers
Install php7.4 in linux server
PHP
1 vote185 views3 answers
Laravel auth check login
PHP
64 votes264 views6 answers
Delete cache laravel
PHP Laravel
0 vote181 views2 answers
Str lower laravel
PHP
0 vote212 views1 answer
Email configuration for gmail in laravel
PHP Laravel
0 vote190 views2 answers
Get page title, excerpt or content by Name of the Page
PHP
0 vote187 views1 answer
Laravel collection forPage
PHP