7

I'm trying to populate a drop down menu with database results in Laravel 4. I'm extremely new to Laravel. This is actually my first site and I'm learning as I go. So, please tell me if I'm using the wrong terminology or not enough information.

I've got a database of company info and I need users to be able to choose a company from a dropdown. Or if the company isn't in the database to add it.

For the select menu, it needs to go like this:

[company name result]

And I'm using this code in my controller:

$companies = RecordCompany::get();
$company_selector = array();

foreach($companies as $company) {
   $company_selector[$company->id] = $company->id;
   $company_selector[$company->company_name] = $company->company_name;
}

return View::make('admin.record_new', array('company_selector' => $company_selector));

And this is what I've got in my view:

@if(count($client_selector)>0)
   {{ Form::select('company_id', $company_selector, array_values($company_selector)[0]) }}
@endif

Disclaimer: I found this code online.

First, I don't understand how it will populate the value and option text without my telling it where to put the data.

Second, the error that's coming back is unexpected . When I take out the [0] in the form code, it tells me that $company_selector is undefined.

What am I doing wrong here?

Improve this question

3 Answers 3

Reset to default
15

In order to populate a dropdown menu with all the records from the RecordCompany model, you can do the following, in your view:

{{ Form::select('company_id', RecordCompany::lists('company_name', 'id')) }}

Note: In Laravel 5, the method lists has been deprecated. Use pluck instead.

Explanation of the code:

  1. The Form::select methods creates a HTML select tag.
  2. company_id is the name of the select tag.
  3. The second parameter is the options for the select tag. The lists method in any model (RecordCompany in this case) generates an associative array containing the parameters passed to that method (id and company_name in this case) of all the records in the model's database table.

If you want, you can also call the lists method from the controller and then pass the value to the view, like following:

In Controller

$company_lists = RecordCompany::lists('company_name', 'id');

return View::make('admin.record_new', array('company_lists' => $company_lists));

In View

{{ Form::select('company_id', $company_lists) }}

You can view the Laravel 4 documentation for generating a drop down list here: http://laravel.com/docs/html#drop-down-lists

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

Comments

0

I'm severelly against using DB calls in views. And here is why:

It ain't made for that!.
Period.

If I where you (note the if clause) I'd like better to fulfill a regular array, being the company->id the array key and any other information you may wanna for that especific key as a value. On my blade code, I'd made that way:

{{ Form::select('company_id', $companies) }}

Where "companies" would be a array passed as argument to the view by the controller.

Views aren't made to make DB consults. They are made to display data. JUST IT!

That being said:

  • The first argument on the Form::select is the selector's name. The one you get on the Input::get.
  • The second argument is the list for fulfill the select attribute (we already talked about it up there!)
  • And the third, non less important, is where you say which one comes selected on loading page (used for editions). You have to reference the identifier (the company id, in that case). It's optional, for obvious reasons.

If I didn't made myself clear, please ask down here! =D

Improve this answer

4 Comments

Thanks for the response. Just to confirm, is my code correct in the controller for setting the array?
Theres no need for a multi dimencional array. A bi-dimensional would do the job.
Okay, so this is what I did in the controller: $companies = RecordCompany::lists('company_name', 'id'); return View::make('admin.record_new', array('companies' => $companies)); And it's still giving me an undefined variable companies error. What am I doing wrong?
You need to change that array_value of yours. It only accept one identifier for previous select. Doesn't work with an array.
0

For Laravel 5, you can code like this :-

Controller Code

$company_lists = RecordCompany::pluck('company_name', 'id');
return View::make('admin.record_new', $company_lists);

View Code

{{ Form::select('company_id', $company_lists) }}
Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.