Best method for storing arrays in database

[sitestreet]

Following on from the excellent helpful thread here:

What's the technique for looping form fields and sending them to the API script?

I’m venturing slightly further than normal with repeats and arrays, etc. but need a steer from someone. Here’s my page code: <div class="container"> <form id="formQuestionnaire" is="dmx-serverconnect-form" method="post" action="/dmxConnect/api/AddEditQuestionnaire.php"> <div is="dmx-repeat" id="repeatquestions" dmx-bind:repeat="connQuestions.data.queryQuestions"> <div class="form-row"> <div class="col"> <h4 class="mt-3">{{$index + 1}}…

I am now working on the Server Connect API script.

My form is sending four arrays:
response[0]: na
scalevalue[0]: 5
questionid[0]: 1
comments[0]:
response[1]: answered
scalevalue[1]: 5
questionid[1]: 2
comments[1]:
etc.

I can set up a repeat for them individually but I want to store the four variables in a record for each one. So I want to process response[0], scalevalue[0], questionid[0] and comments[0] before moving onto all the [1] values, etc.

What's the technique for this?

[mebeingken]

Assuming there is ALWAYS a value for each and thus an equal length for each array, you can perform a repeat on one of the arrays, and then reference the other arrays value with $index.

For example:

And then in the insert:

ingredient get $value because it is the array being repeated. the other POST arrays are referenced using $index.

But again, this relies on each array being full, and being aligned by index.

[sitestreet]

That looks to be exactly what I need. Yes, the arrays will be aligned so that should work fine. Will give it a go. Big thanks Ken.