/PHP/Laravel/How to alias table name in laravel model

How to alias table name in laravel model

Item
    ::from( 'items as items_alias' )
    ->join( 'attachments as att', DB::raw( 'att.item_id' ), '=', DB::raw( 'items_alias.id' ) )
    ->select( DB::raw( 'items_alias.*' ) )
    ->get();

Source: stackoverflow.com

Similar codes

1 vote135 views1 answer
Laravel s3 presigned url
PHP Laravel
0 vote158 views3 answers
Laravel sync with attributes
PHP Laravel
0 vote140 views1 answer
Show data from a table in laravel 8
PHP Laravel
1 vote132 views1 answer
Delete record using laravel
PHP Laravel
0 vote142 views1 answer
Laravel change string to text
PHP Laravel
6 votes146 views4 answers
Illuminate database queryexception could not find driver laravel
PHP Laravel
0 vote133 views1 answer
Get the user detail inside the constructor Laravel
PHP Laravel
3 votes126 views1 answer
Sms laravel
PHP Laravel
2 votes98 views1 answer
How to use model method in controller in laravel
PHP Laravel
0 vote144 views1 answer
Show selected value in dropdown laravel
PHP Laravel