How to store multi select values in Laravel 5.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);
}
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();