How to store multi select values in Laravel

Question

I have many to many relationship between categories and movies. When I check multiple values for categories and insert movie the result on home page selects only one category not all. I tried many things but I wasn't able to resolve this. Here is my code.

upload.blade.php:

<div class="form-group">
    {!! Form::label('category_id', 'Category:') !!}
    {!! Form::select('category_id', $categories, null, ['class'=>'form-control', 'multiple' => true]) !!}
</div>

Controller:

 public function index(Request $request)
{
    $categories = Category::pluck('category_name', 'id')->all();
    return view('movies.upload', compact('categories'));
}

public function upload(MovieUploadRequest $request)
{
    DB::beginTransaction();
    try {
        $movie = Movie::create($request->all());
        $movie->categories()->attach($request->get('category_id'));
        DB::commit();
    } catch (\Exception $e) {
        DB::rollBack();
    }

    return redirect('home');
}

Ole Haugset · Accepted Answer · 2018-07-25 12:33:09Z

2

To enable multiple selects, you first of need to change the name of the select input from category_id to category_id[]. This enables posting of multiple variables as an array.

The code should then look like:

<div class="form-group">
    {!! Form::label('category_id', 'Category:') !!}
    {!! Form::select('category_id[]', $categories, null, ['class'=>'form-control', 'multiple' => true]) !!}
</div>

In your controller, you will then need to loop through the posted id's:

public function upload(...){
    foreach( $request->input('category_id') AS $category_id ){
        $movie = Movie::create($request->all());
        $movie->categories()->attach($category_id);
        ...
    }
}

Edit:

The method attach() also accepts an array of ids as an argument. Thereby, you don't need to loop through the input as above, but can simply use:

public function upload(...){
    $movie = Movie::create($request->all());
    $movie->categories()->attach($request->input('category_id'));
    ...
}

answered Jul 25, 2018 at 12:33

Ole Haugset

3,8053 gold badges27 silver badges48 bronze badges

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

4 Comments

rose Over a year ago

It works, thank you very much! But now I have a small problem on home page. When I insert movie with eg. two categories then second category moves to the right and enters where it should be some other <td>, it doesn't print two categories next to each other, if you know what i mean. How to solve that?

Ole Haugset Over a year ago

@Gacho to answer that I would need to see the markup for it. However if it works, you should accept the answer, and create a new one for your "styling issue"

rose Over a year ago

@foreach($movies as $movie) <tr> <td><a href="{{ route('mov.edit', $movie->id) }}">{{$movie->name}}</a></td> @foreach($movie->categories as $category) <td><a href="{{ route('cat.edit', $category->id) }}">{{$category>category_name}}</a></td> @endforeach

Ole Haugset Over a year ago

Like I said. You should post this as its own question, since it has nothing to do with your original one. Comment fields are not ment to start new question threads. And ofcourse each category becomes a td, since you have <td></td> inside the foreach loop. <td>Name of movie</td><td>@foreach($category AS $cat) {{ $cat->name }} @endforeach</td>...

Arnaud LiDz · Accepted Answer · 2018-07-25 14:17:19Z

2

In your view, use a name like :

<select name="yourfiled[]"></select>.

In controller, to store it in database, just write

$movies->categories = json_encode(yourfield);

Done.

answered Jul 25, 2018 at 14:17

Arnaud LiDz

3113 silver badges11 bronze badges

Comments

Jahid Mahmud · Accepted Answer · 2018-07-25 12:32:01Z

0

You can write this. hopefully this will solve your problem

<div class="form-group">
    {!! Form::label('category_id', 'Category:') !!}
    {!! Form::select('category_id[]', $categories, null, ['class'=>'form-control', 'multiple' => true]) !!}
</div>

answered Jul 25, 2018 at 12:32

Jahid Mahmud

1,1361 gold badge12 silver badges34 bronze badges

Collectives™ on Stack Overflow

How to store multi select values in Laravel

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related