Level 34
@bgweb can you try ->get()[0] instead of first()?
Mar 9, 2021
4
Level 7
first() method returning null values
I currently have a function that is returning an ID to collect the appropriate information for a vehicle. I am using the first() method to collect the first record that the function finds. However, it is pulling in rows where the ID doesn't exist. I've been wracking my brain researching this to find that best way to continue to pull the first record that is not null. Any ideas would be appreciated.
public function getVehicleToEngineConfigIdAttribute() { $vehicleToEngineConfig = Db::connection('vcdb') ->table('VehicleToEngineConfig') ->where('VehicleID', $this->vehicle_id) ->where('EngineConfigID', $this->engine_config_id) ->first();
return $vehicleToEngineConfig->VehicleToEngineConfigID;
}
Level 2
// Example $item = Item::find($id); // you will get the first one
// Or // whereId means 'where'is condition 'Id' is actual column name 'id' we should give first letter in capital $item = Item::whereId($id)->first();
// Or $item = Item::whereId($id)->limit(1)->get(); $item[0]->columnName;
i hope this will help. thank you.
Level 122
You are doing it right, perhaps this is not the code being executed? dd the result before returning and check. With first() you should always have a single result.
Level 80
@bgweb That’s how first works: it either returns the first matching result, or null if no rows matched your query.
Also, consider using Eloquent models in your application instead of writing our your queries long-hand using the DB facade. It’ll make your code easier to read and reason about.
Please or to participate in this conversation.