Rails 4.0 save arrays and strings to single column

Question

I am trying to save data from a dynamic form where the response saved can be either an array, or a string.

Using serialize in my model or using ':question_answer => []' in my permit tries to set every entry as an array. I need this to dynamically allow saving either as a string or an array to the MySQL DB.

Any help would be appreciated.

This seems to be a duplicate question with a good answer here: stackoverflow.com/a/21315340/260670 — Midwire
– Midwire, Commented May 25, 2016 at 18:20
This question is similar to: Storing arrays in database : JSON vs. serialized array. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. — user4157124
– user4157124, Commented Oct 6 at 1:48

Community · Accepted Answer · 2017-05-23 12:15:54Z

0

it's never a good way to save arrays in one column/field

better you make relations model/table with has and belongs to many

see here for more Save PHP array to MySQL?

here are the example that you can follow from railscasts

http://railscasts.com/episodes/17-habtm-checkboxes-revised

http://railscasts.com/episodes/196-nested-model-form-revised (about questions and answers too)

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered May 23, 2016 at 16:56

buncis

2,6221 gold badge28 silver badges26 bronze badges

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

1 Comment

Will Ross Over a year ago

My array is coming from a select field on a form with multiple: true Looking at those videos, they seem focused on the has and belongs to many aspect for the creation of the survey, not the response?

Collectives™ on Stack Overflow

Rails 4.0 save arrays and strings to single column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related