/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

29 votes117 views6 answers
Where like laravel
PHP Laravel
0 vote120 views2 answers
Share to facebook from website laravel
PHP Laravel
24 votes110 views6 answers
Validation error message in laravel
PHP Laravel
0 vote113 views3 answers
Laravel public ParseError syntax error, unexpected '$conversion' (T_VARIABLE), expecting ',' or ')' /
PHP Laravel
1 vote127 views2 answers
Laravel model is dirty
PHP Laravel
0 vote123 views1 answer
Change the date format in laravel view page
PHP Laravel
0 vote116 views2 answers
Laravel retain old value
PHP Laravel
0 vote117 views3 answers
Laravel get all records order by
PHP Laravel
0 vote120 views1 answer
Laravel filesystem link
PHP Laravel
1 vote120 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP Laravel