Saving multiple records in 1 table

ww

wwgg 13 Feb, 2017

Gr

GreyHead 13 Feb, 2017

Hi wwgg ,

You can do this with one table but it will take more work.

You'd have to use a Custom Code action to loop through the $form->data['Naam'] entries and add all the other data to them, then use a DB Save with the Multi Save setting enabled to save all the records.

Better to save the basic data to table 1, then add the new record ID to the $form->data['Naam'] entries and save those in a second table.

Adding a Debugger to your form on Submit event will let you see the data you have to save.

Bob

ww

wwgg 14 Feb, 2017

Can you give me a hint on the loop through ??

The guy I make this site for needs ONE excell file with the data.
Do for me personally it is easier to provide one tabel.

I really don't know where to start

My array:

    [chronoform] => Inschrijven-mei-2017
    [event] => submit
    [team] => Test Team 123
    [captain] => 123
    [captainmail] => 123@123.ll
    [captainphone] => 123
    [opmerking] => 123 test
    [nix18] => 1
    [Naam] => Array
        (
            [0] => Array
                (
                    [data] => SDeelenemr 12
                )

            [1] => Array
                (
                    [data] => Deelenemr 345
                )

        )

    [button5] => Schrijf in!

Max_admin 15 Feb, 2017

1 Likes

Hi wwgg,

in a custom code action before the db save:


<?php
$form->data["rows"] = array();
foreach($form->data["Naam"] as $k => $name){
$form->data["rows"][$k]["contestant"] = $name;
$form->data["rows"][$k]["captainphone"] = $form->data["captainphone"];
//other fields
}

Then in the db save, choose to save multiple records, and the data path is "rows".

Best regards,
Max

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

Forums

Saving multiple records in 1 table