Forums

Hi at this page, I'm trying to use a repeater area, but I've some issue appear load data from database:
​
http://ciccr.f14web.pro/livelli-lago-riepilogo
​
How you can see the load data are stored into extralaghi array but I don't understand why the repeater area don't read this data.
​
Please could you help me to resolve this issue?
​
Regards.
Emanuele
​

[var] => Array
                (
                    [0] => Array
                        (
                            [extralaghi] => Array
                                (
                                    [aid] => 1
                                    [user_id] => 31
                                    [created] => 2018-06-08 14:52:19
                                    [data] => 2018-06-08 16:52:00
                                    [lago] => Lago di Como
                                    [idro] => 20
                                    [note] => PIENA STRAORDINARIA
                                )

                        )

                    [1] => Array
                        (
                            [extralaghi] => Array
                                (
                                    [aid] => 2
                                    [user_id] => 31
                                    [created] => 2018-06-08 14:59:59
                                    [data] => 08/06/2018
                                    [lago] => Lago di Como
                                    [idro] => 20
                                    [note] => 
                                )

                        )

​

replace {data:extralaghal} in the repeater area data provider with {var:read_data4}

Then all the values will need to be {var:area_repeater5.row.extralaghi.valueYouWant}

Great! Work fine!
​
I've another question:
If I try to modify the record loaded work fine, instead when I insert a new record the system don't save into db. Why?
​
This configuration into footer area repeter




Rergards
Emanuele

Could you to help me please?
Emanuele

Post your debug

The link of page is
​
http://ciccr.f14web.pro/accedi-2
​
​
Here the debug:
​
​

Array
(
    [_ga] => GA1.2.371091234.1528460153
    [adcf749bbd5f64903947be2e21155320] => vimi1egl5q9dnf718ei13jotr2
    [Itemid] => 117
    [option] => com_chronoforms6
    [view] => form
)

Array
(
    [read_data4] => Array
        (
            [log] => Array
                (
                    [0] => SELECT COUNT(`extralaghi`.`aid`) AS `extralaghi.count` FROM `u53uf_chronoforms_data_rilievi-idrometrici-laghi-inserimento` AS `extralaghi`;
                    [1] => SELECT `extralaghi`.`aid` AS `extralaghi.aid`, `extralaghi`.`user_id` AS `extralaghi.user_id`, `extralaghi`.`created` AS `extralaghi.created`, `extralaghi`.`modified` AS `extralaghi.modified`, `extralaghi`.`data` AS `extralaghi.data`, `extralaghi`.`lago` AS `extralaghi.lago`, `extralaghi`.`idro` AS `extralaghi.idro`, `extralaghi`.`note` AS `extralaghi.note` FROM `u53uf_chronoforms_data_rilievi-idrometrici-laghi-inserimento` AS `extralaghi` ORDER BY `extralaghi.aid` DESC LIMIT 3;
                )

            [var] => Array
                (
                    [0] => Array
                        (
                            [extralaghi] => Array
                                (
                                    [aid] => 11408
                                    [user_id] => 31
                                    [created] => 2018-05-24 00:00:00
                                    [modified] => 2018-06-12 02:19:56
                                    [data] => 24/05/2018
                                    [lago] => Lago di Iseo
                                    [idro] => 108.5
                                    [note] => aid
                                )

                        )

                    [1] => Array
                        (
                            [extralaghi] => Array
                                (
                                    [aid] => 11407
                                    [user_id] => 31
                                    [created] => 2018-05-24 00:00:00
                                    [modified] => 2018-06-12 02:19:56
                                    [data] => 24/05/2018
                                    [lago] => Lago di Como
                                    [idro] => 63.3
                                    [note] => 
                                )

                        )

                    [2] => Array
                        (
                            [extralaghi] => Array
                                (
                                    [aid] => 11406
                                    [user_id] => 31
                                    [created] => 2018-05-23 00:00:00
                                    [modified] => 2018-06-12 02:19:56
                                    [data] => 25/05/2018
                                    [lago] => Lago di Como
                                    [idro] => 105.2
                                    [note] => prova al 25 maggio 
                                )

                        )

                )

        )

)

I need the debug from the submit event, not the load event.

Ok!🙂
​
​

Array
(
    [chronoform] => rilievi-idrometrici-laghi-tabella
    [event] => submit
    [Model] => Array
        (
            [0] => Array
                (
                    [data] => 24/05/2018
                    [lago] => Lago di Iseo
                    [idro] => 108.5
                    [aid] => 11408
                    [note] => aid
                )

            [1] => Array
                (
                    [data] => 24/05/2018
                    [lago] => Lago di Como
                    [idro] => 63.3
                    [aid] => 11407
                    [note] => 
                )

            [2] => Array
                (
                    [data] => 25/05/2018
                    [lago] => Lago di Como
                    [idro] => 105.2
                    [aid] => 11406
                    [note] => prova al 25 maggio 
                )

        )

    [data] => 13/06/2018
    [lago] => 
    [idro] => 
    [note] => 
    [button7] => 
    [_ga] => GA1.2.371091234.1528460153
    [78f1bfe75faa4fc86eec21112d3f6c0e] => 4rv98t0r6hbb79i47sn4qdfmb6
    [adcf749bbd5f64903947be2e21155320] => oc45anqdcr5tsg5gnre4gcava1
    [Itemid] => 117
    [option] => com_chronoforms6
    [view] => form
)

Array
(
    [save_data11] => Array
        (
            [data] => Array
                (
                    [data] => 25/05/2018
                    [lago] => Lago di Como
                    [idro] => 105.2
                    [aid] => 11406
                    [note] => prova al 25 maggio 
                    [modified] => 2018-06-13 09:52:32
                )

            [_success] => Data saved successfully
            [log] => Array
                (
                    [0] => UPDATE `u53uf_chronoforms_data_rilievi-idrometrici-laghi-inserimento` AS `Data11` SET `data` = '25/05/2018', `lago` = 'Lago di Como', `idro` = '105.2', `note` = 'prova al 25 maggio ', `modified` = '2018-06-13 09:52:32' WHERE `aid` = '11406';
                )

            [var] => Array
                (
                    [data] => 25/05/2018
                    [lago] => Lago di Como
                    [idro] => 105.2
                    [note] => prova al 25 maggio 
                    [modified] => 2018-06-13 09:52:32
                )

        )

)

So what's happening, it updates existing entries but it doesn't insert new ones?
​
If that's the case try splitting it into 3 segments:
​
a read_data action that looks for an entry where aid:{var:loop_event14.row.aid}
In the FOUND event, have a save data set to UPDATE
In the NOT FOUND event, have a save data set to INSERT