PHP laravel DB join field name modification

Laravel

$houses = DB::table('houses')->join('status', 'houses.status_id', '=', 'status.id')->get()

housesTable has a status_id field, corresponding to the need to query to the status table name field;

What $houses gets inside is the status field in the table name , how do you change the name to one status_name ?

Add

Currently houses there is no name field in this table, so there is no error in checking the status name

You can take the status name field out of the table directly, but if houses the table also has a name field, how to handle it.

Because a houses field is built in the table, title if you houses add a field to the table, you name will see an error in the Join status form!

Reply content:

Laravel

$houses = DB::table('houses')->join('status', 'houses.status_id', '=', 'status.id')->get()

housesTable has a status_id field, corresponding to the need to query to the status table name field;

What $houses gets inside is the status field in the table name , how do you change the name to one status_name ?

Add

Currently houses there is no name field in this table, so there is no error in checking the status name

You can take the status name field out of the table directly, but if houses the table also has a name field, how to handle it.

Because a houses field is built in the table, title if you houses add a field to the table, you name will see an error in the Join status form!

DB::table('houses')->select('*','name as status_name')->join('status', 'houses.status_id', '=', 'status.id')->get();

DB::table('houses')->select('name as status_name')->join('status', 'houses.status_id', '=', 'status.id')->get()

As keyword, you can take an alias.

