/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

4 votes420 views2 answers
Laravel attach
PHP Laravel
2 votes368 views3 answers
How get file size in laravel
PHP Laravel
0 vote380 views1 answer
How to display image from aws s3 in laravel blade
PHP Laravel
0 vote374 views1 answer
Unlink is a directory laravel
PHP Laravel
38 votes352 views6 answers
Create seed file laravel
PHP Laravel
1 vote396 views1 answer
Laravel migration add datetime column with default
PHP Laravel
5 votes411 views5 answers
Laravel file permissions
PHP Laravel
0 vote397 views1 answer
Change the date format in laravel view page
PHP Laravel
0 vote396 views1 answer
Set null on foreign key deletion in laravel
PHP Laravel
3 votes294 views2 answers
Laravel custom paginator links view
PHP Laravel