Insert values from an array into the database

[Valtenci]

how to save data from an array in the database…

[twinklemagoo]

Have a look here for a detailed breakdown of doing just that.

Multi-Select Inputs - How to Write an Array to the Database

So you may have an input that can have more than one value. You can use the article from Wappler Docs to see how to create a nice interface for selecting the multiple values, which is linked to below. You then end up with an array of values. But how do you write that array to your database, maybe along with other single dimensional data? Let’s assume you have: An array to write to the database called my_array A form that writes the other data to your database too You want to insert a row…

[Teodor]

Well maybe explain more detailed what exactly would you like to insert where in what format.

[Valtenci]

hello Teodor, it’s been two weeks since I’ve been breaking my head with this, in fact I want to save this data from this array in a subtable as shown in the images

my subtable

my array

my server action

I don’t know how to pass these values ​​to my subtable.

I’m very grateful if you can help me.

thanks.

[Teodor]

I don’t really understand where your data comes from exactly, but check the docs explaining how to insert data in the main and subtable:

Inserting Data in Main and Sub Table using App Connect Form Repeat

Intro App Connect Form repeat makes it easy to insert or update nested data in your database tables using a single insert or update action. This way you can easily insert data in your main table as well as in its sub tables. In this tutorial we will show you how to store a user and its contacts. The user will be stored in the main table, while its contacts will be stored in a sub table. Database Structure Our database structure is quite simple. We have a main table called users, having an un…

[Valtenci]

this data and a textarea that is inside a form

[Teodor]

There is something weird in your logic. Why would you add json code in a textarea in a form? What is the idea? Probably your whole logic is wrong.

[Valtenci]

I’ll send you a video

[Valtenci]

the products are added to a datastore that feeds the textarea, I used this textarea to try to save in the subtable.

did you understand ?

Gravar_2023_08_21_07_23_39_902

[Teodor]

You should not send all the data, especially prices from your data store to the database, as it can easily be changed in the dev tools. All you need to send to your server action is the product ID and product quantity. The rest can be calculated on the server side and inserted in the required tables.

[Valtenci]

Do you have a tutorial showing how to do this?

[Teodor]

You need a repeat in your form and add 2 hidden inputs there one for product id and one for the quantity.
Example:

<form ...>

<div is="dmx-repeat" id="repeatItemsCart" dmx-bind:repeat="dsCart.data.reverse()">
    <input id="product_id" name="product_id" dmx-bind:name="repeatItemsCart[{{$index}}][product_id]" type="hidden" dmx-bind:value="prd_id">
    <input id="product_qty" name="product_qty" dmx-bind:name="repeatItemsCart[{{$index}}][product_qty]" type="hidden" dmx-bind:value="quantity">
...
other info here
...
</div>
</form>

Then in your server action you have these available as:

so you can do whatever you like with them - filter a query, get product price, details etc. then insert data wherever is needed.
But this is basically what you do with the form repeat component - so follow the tutorial Inserting Data in Main and Sub Table using App Connect Form Repeat

[Valtenci]

thank you very much friend this tip will help me a lot

[Valtenci]

I don’t know why it’s repeating the first id and qty

[famousmag]

use $index instead of 0 in value

OR just $id and vQTDE would be enough (without datastore1.data[$index])

[Teodor]

@famousmag

OR just $id and vQTDE would be enough (without datastore1.data[$index])

That’s the correct way, you just picked the data from the wrong place.

[Valtenci]

success.!

thank you so much Teodor and famousmag