How to store multi select values in Laravel 5.2

Question

I have a form which stores News.

Here I am using Multiselect and I want to save all the selected option in the table as say Users,staff,cinemahall as a string.

My controller function to store values is

 public function store(Request $request)
{

    $input=$request->all();

    General_news::create($input);
    return redirect()->back();
}

This function store the all submitted fields but for multiselect it stores only last option i.e cinemahall

When form is submitted all selected options are displayed but it's not saving in database table properly.

help me to solve this issue.

Can you please update your question with the html markup ?

Aniruddha Chakraborty
– Aniruddha Chakraborty

2016-07-10 05:43:28 +00:00
Commented Jul 10, 2016 at 5:43 — Aniruddha Chakraborty
– Aniruddha Chakraborty, Commented Jul 10, 2016 at 5:43

Chay22 · Accepted Answer · 2016-07-10 05:51:30Z

41

Make sure you set the name attribute to an array

<select multiple="multiple" name="news[]" id="news">

To store it as string separated by commas

$news = $request->input('news');
$news = implode(',', $news);

You have a string which will look like Users,staff,cinemahall. Now, instead to retrieve all input, you may need to retrieve it one by one, since you need to mutate the news value. Additionally, you can also use except() method to exclude news from mass getting all value.

$news = $request->input('news');
$news = implode(',', $news);

$input = $request->except('news');
//Assign the "mutated" news value to $input
$input['news'] = $news;

General_news::create($input);
return redirect()->back();

answered Jul 10, 2016 at 5:51

Chay22

2,9042 gold badges19 silver badges25 bronze badges

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

2 Comments

dollar Over a year ago

Thanks for the help, one more query, can you please assist me doing reverse of this, now while editing I want to fetch the string from table and show it as multiselect.

Chay22 Over a year ago

To convert a string into array, you can use explode(',', $string);

Bdwey · Accepted Answer · 2017-05-04 19:45:11Z

2

Thanks @Chay22

you could also use Mutators and Accessor https://laravel.com/docs/5.4/eloquent-mutators#defining-an-accessor

public function setFooAttribute($value)
{
    $this->attributes['foo'] = implode(',',$value);
}

public function getFooAttribute($value)
{
    return explode(',',$value);
}

answered May 4, 2017 at 19:45

Bdwey

2,0332 gold badges17 silver badges19 bronze badges

Comments

Davor Minchorov · Accepted Answer · 2016-07-10 07:35:46Z

0

If you are using a multiselect, that probably means that you need a many to many relationship and a pivot table. Kind of like how posts can belong to many tags and tags can belong to many posts.

In your case this would probably be between news and the news_types tables.

answered Jul 10, 2016 at 7:35

Davor Minchorov

2,0761 gold badge16 silver badges20 bronze badges

1 Comment

dollar Over a year ago

thanks for your answer but I want to store this as a string in single table instead of maintaining multiple tables and their relationship.... I know my approach doesn't fit when it comes to Normalization of Database....

Collectives™ on Stack Overflow

How to store multi select values in Laravel 5.2

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related