Insert multiple values as array into one column

Question

I have a checkbox with multiple values to be selected. So far I got it working and the data is inserting into the database but it's in this format,

My issue is that I want the data to be in this format ["value1","value2","value3"]. I'm using Laravel and this is the code in my controller:

public function store(NewsRequest $request) //ive removed most of the unnecessary code like the image upload and all to make this clean.
{
    $news = new News($request->except('files', 'image'));
    $serialize = implode(",", $news->majors); //this is my focus to change the format to ["value1","value2","value3"]

    //ready data for insertion
    $data = array(
        "name" => $news->name,
        "article_type_id" => $request->category,
        "majors" => $serialize,
        "content" => $news->content
    );

    DB::table('articles')->insert($data); //insert into database
}

Currently I'm only able to insert the data with a comma separating them but I want the data to be inserted like the following:

I tried looking around the internet but I couldn't find anything that could help besides JSON.stringify. I'm hoping to get the format in my controller itself. I'm hoping to get some insight for this. Thank you in advance.

just add quotation marks as part of implode string - implode('","', $news->majors); and concatenate same quotation marks at beginning and end of the produced string. — mitkosoft
– mitkosoft, Commented Jan 14, 2020 at 9:50
Thank you both! '['.implode('","', $news->majors).']' did the trick! :) — Vaulient
– Vaulient, Commented Jan 14, 2020 at 9:56
Do not do this. Data in a database needs to be normalised otherwise you will have problems further down the road. Use relationships — apokryfos
– apokryfos, Commented Jan 14, 2020 at 9:57

mitkosoft · Accepted Answer · 2020-01-14 09:53:43Z

2

adding quotation marks at the beginning , within implode() and at the end will do the magic.

$serialize = '["'.implode('","', $news->majors).'"]';

answered Jan 14, 2020 at 9:53

mitkosoft

5,3361 gold badge15 silver badges32 bronze badges

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

Comments

knubbe · Accepted Answer · 2020-01-14 09:54:55Z

0

You can consider using json attribute for column in migration file and then in related model you can cast that column as array

answered Jan 14, 2020 at 9:54

knubbe

1,2022 gold badges13 silver badges24 bronze badges

Collectives™ on Stack Overflow

Insert multiple values as array into one column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related