/PHP/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

22 votes292 views6 answers
Laravel 6 auth
PHP
1 vote338 views1 answer
Wordpress display post comment number
PHP Wordpress
0 vote287 views1 answer
Laravel eloquent relationships count
PHP
0 vote287 views1 answer
New return type php 8.1
PHP
0 vote289 views1 answer
Acf wp_query custom field
PHP
0 vote343 views3 answers
Laravel pagination with search filter
PHP Laravel
4 votes348 views1 answer
Get client size in laravel
PHP Laravel
0 vote282 views1 answer
How we show full name of month in posts
PHP
2 votes277 views1 answer
Get user ip laravel
PHP
1 vote294 views3 answers
Pdo fetch
PHP