Menu
In Laravel how can I get specific columns using find? I know you can do it with get like this:
$user = User::where('u_id', '=', 1)
->get(['firstname', 'lastname']);
Is there a way to do it with find? This is what I currently have:
$user = User::find(1);
259
Select specific columns with Laravel Eloquent To get all of the columns from the users table, we would use the following: $user = User::where('username', 'bobbyiliev')->get(); However, if you wanted to get only a specific column, you could pass it as an argument to the get() method.
Eloquent ORM is best suited working with fewer data in a particular table. On the other side, query builder takes less time to handle numerous data whether in one or more tables faster than Eloquent ORM. In my case, I use ELoquent ORM in an application with tables that will hold less than 17500 entries.
Pluck function normally used to pull a single column from the collection or with 2 columns as key, value pairs, which is always be a single dimension array. Select will return all of the columns you specified for an entity in a 2 dimensional array, like array of selected values in an array.
Eloquent is an object relational mapper (ORM) that is included by default within the Laravel framework. An ORM is software that facilitates handling database records by representing data as objects, working as a layer of abstraction on top of the database engine used to store an application's data.
You have two options.
First, you can pass the columns to select as the second parameter to find():
$user = User::find(1, ['firstname', 'lastname']);
Second, although somewhat specialized, find() is just the method used to execute the query, so you can modify the query as normal beforehand (add selects, wheres, orders, etc.). Therefore, you can just add a select() before you execute the find():
$user = User::select(['firstname', 'lastname'])->find(1);
Here is another way, similar to @patricus.
$did = User::findOrFail($id, ['first_name', 'last_name']);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
