Laravel 4 - Get Array of Attributes from Collection

Yep, you can do it nice and easily. As the Laravel 4 Documentation states, you can do

Retrieving All Rows From A Table

$users = DB::table('users')->get();

foreach ($users as $user)
{
var_dump($user->name);
}

Retrieving A Single Row From A Table

$user = DB::table('users')->where('name', 'John')->first();

var_dump($user->name);

Retrieving A Single Column From A Row

$name = DB::table('users')->where('name', 'John')->pluck('name');

Retrieving A List Of Column Values

$roles = DB::table('roles')->lists('title');

This method will return an array of role titles. You may also specify a custom key column for the returned array:

$roles = DB::table('roles')->lists('title', 'name');

Specifying A Select Clause

$users = DB::table('users')->select('name', 'email')->get();

$users = DB::table('users')->distinct()->get();

$users = DB::table('users')->select('name as user_name')->get();

EDIT:

The above examples show how to access data with the help of Laravel's fluent query builder. If you are using models you can access the data with Laravel's Eloquent ORM

Because Eloquent is internaly using the query builder, you can without any problem do the following things:

$tag_names = $tags->lists('tag_name_label', 'tag_name_column')->get();

which could be also done with:

$tag_names = DB::table('tags')->lists('tag_name_label', 'tag_name_column')->get();

Here are a few snippets from my own experimentation on the matter this morning. I only wish (and maybe someone else knows the solution) that the Collection had a $collection->distinct() method, so I could easily generate a list of column values based on an already filtered collection.

Thoughts?

I hope these snippets help clarify some alternative options for generating a list of unique values from a Table, Collection, and Eloquent Model.

Using a Collection (Happy)

/**
 * Method A
 *     Store Collection to reduce queries when building multiple lists
 */
$people = Person::get();
$cities = array_unique( $people->lists('city') );
$states = array_unique( $people->lists('state') );
// etc...

Using an Eloquent Model (Happier)

/**
 * Method B
 *     Utilize the Eloquent model's methods
 *     One query per list
 */
// This will return an array of unique cities present in the list
$cities = Person::distinct()->lists('city');
$states = Person::distinct()->lists('state');

Using an Eloquent Model PLUS Caching (Happiest)

/**
 * Method C
 *     Utilize the Eloquent model's methods PLUS the built in Caching
 *     Queries only run once expiry is reached
 */
$expiry = 60; // One Hour
$cities = Person::remember($expiry)->distinct()->lists('city');
$states = Person::remember($expiry)->distinct()->lists('state');

I would love to hear some alternatives to this if you guys have one!

@ErikOnTheWeb

You could use array_column for this (it's a PHP 5.5 function but Laravel has a helper function that replicates the behavior, for the most part).

Something like this should suffice.

$tag_names = array_column($tags->toArray(), 'name');