Forums

Hi,
I've some problem with save DB action inside body of Loop Event.

Array
(
    [chronoform] => 2step
    [event] => submit
    [disservizio_subito] => y
    [passeggeri_coinvolti] => y
    [motivazione] => y
    [undefined] => 
    [InfoVoli] => Array
        (
            [0] => Array
                (
                    [airlines] => y
                    [datavolo] => 10/10/2017
                    [numvolo] => 55656
                )

            [1] => Array
                (
                    [airlines] => y
                    [datavolo] => 16/10/2017
                    [numvolo] => 123
                )

        )

    [email] => sdsdsdsd@fff.it
    [button29] => 
    [Itemid] => 542
    [option] => com_chronoforms6
    [view] => form
)

You can see that my "Model" name is InfoVoli
I set Event loop with: Data provider {data:InfoVoli}, Return the result as var? set OFF.
Inside Body i put Save Data Event in wich I configured data provider {var:loop_event12.row}
The configurations seems the manual says.. but this is the code:

Array
(
    [save_data14] => Array
        (
            [data] => Array
                (
                    [airlines] => y
                    [datavolo] => 10/10/2017
                    [numvolo] => 55656
                    [disservizio_subito] => y
                    [passeggeri_coinvolti] => y
                    [motivazione] => y
                    [] => Array
                        (
                            [chronoform] => 2step
                            [event] => submit
                            [disservizio_subito] => y
                            [passeggeri_coinvolti] => y
                            [motivazione] => y
                            [undefined] => 
                            [InfoVoli] => Array
                                (
                                    [0] => Array
                                        (
                                            [airlines] => y
                                            [datavolo] => 10/10/2017
                                            [numvolo] => 55656
                                        )

                                    [1] => Array
                                        (
                                            [airlines] => y
                                            [datavolo] => 16/10/2017
                                            [numvolo] => 123
                                        )

                                )

                            [email] => sdsdsdsd@fff.it
                            [button29] => 
                            [Itemid] => 542
                            [option] => com_chronoforms6
                            [view] => form
                        )

                    [email] => sdsdsdsd@fff.it
                    [radio14] => 
                    [radio15] => 
                )

            [_success] => Data saved successfully
            [log] => Array
                (
                    [0] => INSERT INTO `datavoli` (`airlines`, `datavolo`, `numvolo`, `disservizio_subito`, `passeggeri_coinvolti`, `motivazione`, `email`)  values  ('y', '10/10/2017', '55656', 'y', 'y', 'y', 'sdsdsdsd@fff.it');
                )

            [var] => Array
                (
                    [airlines] => y
                    [datavolo] => 10/10/2017
                    [numvolo] => 55656
                    [disservizio_subito] => y
                    [passeggeri_coinvolti] => y
                    [motivazione] => y
                    [email] => sdsdsdsd@fff.it
                    [id] => 11
                )

        )

)

The script write only one row.. it doesn't recognize the other row.. where I'm wrong?

Hi livingwebstudio,

The setup looks correct, what do you have exactly in the "data provider" and the "data override" fields in the "save data" action ?

Best regards