Laravel: Populate Form dropdown from database

Question

First Laravel Project.

I want to make a form drop-down list what is populated from mysql database. I found this on the documentation:

Form::select('size', array('L' => 'Large', 'S' => 'Small'))

and I tried this:

{{Form::select('size', array(
                @foreach ($suppliers as $supplier)
                $supplier->id => $supplier->name
                @endforeach
))
}}

But I got syntax error:

ErrorException in e34a9587ee23853b6d4c489cc0ed13515fad9c06.php line 23: Parse error: syntax error, unexpected '<', expecting ')' (View: /var/www/html/project/laravel/leltar/resources/views/invoice.blade.php)

What did I wrong?

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

Pluck returns a collection from laravel version 5.3 and that answer is wrong, it wont show the select box right!

Here is the right solution!

$suppliers = Supplier::pluck('name', 'id')->toArray();

and in view call it like this:

{!! Form::select('supplier', $suppliers, null, ['class' => 'form-control']) !!}

update for Laravel 5.5

Just tested this and in Laravel 5.5 pluck() works without appending toArray() on it like this:

$tags = Tag::pluck('name', 'id');

or for this question;

$tags = Supplier::pluck('name', 'id');

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Mar 24, 2017 at 22:08

lewis4u

15.3k22 gold badges116 silver badges161 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mihai Matei · Accepted Answer · 2017-03-24 13:40:32Z

2

Try the pluck method:

Form::select('size', $suppliers->pluck('name', 'id')->all())

answered Mar 24, 2017 at 13:40

Mihai Matei

24.3k5 gold badges34 silver badges50 bronze badges

4 Comments

Feralheart Over a year ago

I got an another error message: "Call to a member function pluck() on array (View: /var/www/html/project/laravel/leltar/resources/views/invoice.blade.php)"

Mihai Matei Over a year ago

how do you send $suppliers from controller?

Feralheart Over a year ago

$suppliers = DB::select('select * from supplier'); return view('invoice',['suppliers'=>$suppliers]);

Mihai Matei Over a year ago

$suppliers = SupplierModel::all(); try it using the model instead of a raw query

Collectives™ on Stack Overflow

Laravel: Populate Form dropdown from database

2 Answers 2

update for Laravel 5.5

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

update for Laravel 5.5

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related