Support the ongoing development of Laravel.io →
Database Eloquent

Hey guys, im running the following Query: $user = User::where('active', '=', '1')->get();

Then in my blade template i use: {{ Form::select('product_id', $users, null, array('class' => 'form-control')) }}

This will put in all database values. How can i say that the value is the id and the text of the option is Username like:

<option value="user_id'>Donny5300</option>
Last updated 3 years ago.
0

You could just use:

 $user = User::lists('name','id');

Then in your view

 {{ Form::select('name', $user, null, ['class' => 'form-hoirzontal']) }}
Last updated 3 years ago.
0

What if i want the option be like

<option value="user_id'>Username here, date of birth here</option>
Last updated 3 years ago.
0

Sign in to participate in this thread!

PHPverse

Your banner here too?

Donny5300 donny5300 Joined 3 May 2014

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.