how populate select box with database in Laravel 5.4?

Question

I have an edit page where the data of a product is passed, on this page I have a select box for the category change, in it I need to insert all the categories registered in my database but only shows the category related to the product of the page.

Select Box of Edit view

<select class="selectpicker" data-live-search="true">
          @foreach($produtos->categoria as $categoria)
          <option data-tokens="{{$categoria->erp_name}}" value="{{$categoria->erp_categoryid}}">{{$categoria->erp_name}}</option>
          @endforeach
          </select>

ProdutosController

public function edit($id)
    {
        $produtos = Produtos::find($id);

        return view('functions.edit')->with('produtos', $produtos);
    }

Routes

Route::get('/product/update/{id}', 'ProdutosController@edit')->name("product::updateGet");
Route::post('/product/update/{id}', 'ProdutosController@update')->name("product::updatePost");

Any suggestions?

Grab all of the categories, assign it to another variable, and pass that in as well. Then use that for the select instead. — aynber
– aynber, Commented Apr 17, 2017 at 13:55
Fetch using $categories = Categoria::all() and pass ->with('categories ', $categories ) then use that in view. — siddiq
– siddiq, Commented Apr 17, 2017 at 13:58

Farzin Farzanehnia · Accepted Answer · 2017-04-17 13:57:39Z

2

The problem is you are looping through the categories of that product, not all categories. Here is a solution:

public function edit($id)
{
    $produtos = Produtos::find($id);
    $categories = Category::all();

    return view('functions.edit', compact('produtos', 'categories'));
}

then in your view:

<select class="selectpicker" data-live-search="true">
      @foreach($categories as $categoria)
          <option data-tokens="{{$categoria->erp_name}}" value="{{$categoria->erp_categoryid}}">{{$categoria->erp_name}}</option>
      @endforeach
</select>

answered Apr 17, 2017 at 13:57

Farzin Farzanehnia

1,0608 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

how populate select box with database in Laravel 5.4?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related