Forums

Hello,

I would like to create a form with a dynamic checkbox but when i submit , the page with the form is blank and the form don't appear.

This my code.

<div class="form-group gcore-form-row" id="form-row-nom"><label for="nom" class="control-label gcore-label-left">Nom</label>
<div class="gcore-input gcore-display-table" id="fin-nom"><input name="nom" id="nom" value="" placeholder="" maxlength="" size="" class="validate['required'] form-control A" title="" style="" data-inputmask="" data-load-state="" data-tooltip="" type="text" /></div></div><div class="form-group gcore-form-row" id="form-row-text2"><label for="text2" class="control-label gcore-label-left">Prénom</label>
<div class="gcore-input gcore-display-table" id="fin-text2"><input name="prenom" id="text2" value="" placeholder="" maxlength="" size="" class="form-control A" title="" style="" data-inputmask="" data-load-state="" data-tooltip="" type="text" /></div></div><div class="form-group gcore-form-row" id="form-row-email"><label for="email" class="control-label gcore-label-left">E-mail</label>
<div class="gcore-input gcore-display-table" id="fin-email"><input name="email" id="email" value="" placeholder="" maxlength="" size="" class="validate['required','email'] form-control A" title="" style="" data-inputmask="" data-load-state="" data-tooltip="" type="text" /></div></div><div class="form-group gcore-form-row" id="form-row-etablissement"><label for="etablissement" class="control-label gcore-label-left">Etablissement</label>
<div class="gcore-input gcore-display-table" id="fin-etablissement"><input name="etablissement" id="etablissement" value="" placeholder="" maxlength="" size="" class="form-control A" title="" style="" data-inputmask="" data-load-state="" data-tooltip="" type="text" /></div></div><div class="form-group gcore-form-row" id="form-row-formations"><label for="formations" class="control-label gcore-label-left gcore-label-checkbox">Formations</label>
<div class="gcore-input gcore-display-table" id="fin-formations"><div class="gcore-single-column" id="fclmn"><div class="gcore-checkbox-item" id="fitem"><?php
$requete = mysql_query("SELECT id,nom,titre FROM inkou_chronoengine_chronoforms_datatable_formations WHERE statut like 'd%'");
 
     
    <?php
    while ($donnees = mysql_fetch_array($requete)){
        ?>
        <input type="checkbox" name="formation[]" id="<?php echo $donnees['nom'] ?>" value="<?php echo $donnees['id'] ?>"/>
        <label for="<?php echo $donnees['nom'] ?>">
            <?php
            echo $donnees['titre'].' : ' .$donnees['nom']."<br/>";
            ?>
        </label>
        <?php
    }
     
    ?>
 echo'<input name = "formations[]" id = "formations" class = "validate['group:5'] A" title = "" style = "" data-load-state = "" data-tooltip = "" type = "checkbox" value = "{$d->nom}" />
<label class = "control-label gcore-label-checkbox" for = "formations">{$d->titre.} : {$d->nom}</label></div></div></div></div>';}?><input name="hidden6" id="hidden6" value="" type="hidden" class="form-control A" /><div class="form-group gcore-form-row" id="form-row-statut"><label for="statut" class="control-label gcore-label-left">Dropdown Label</label>
<div class="gcore-input gcore-display-table" id="fin-statut"><select name="statut" id="statut" size="" class="form-control A" title="" style="" data-load-state="" data-tooltip="">
<option value="0">No</option>
<option value="1">Yes</option>
</select></div></div>

in the setup i have DB read and array handdle and the debug show me that

Data Array
Array
(
    [option] => com_chronoforms5
    [chronoform] => inscription
    [Data0] => Array
        (
            [id] => 1
            [nom] => Module 1
            [description] => lorem lorem lorem
            [titre] => rehab_psy
            [category] => inter_etablissements
            [type] => atelier
            [annee] => 2015
            [formateurs] => farkas
            [niveau] => 1
            [statut] => disponible
            [file] => 
            [button12] => Enregistrer
        )

)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
    [0] => Array
        (
            [DB Read] => Array
                (
                    [Queries] => Array
                        (
                            [0] => SELECT `Data0`.`id` AS `Data0.id`, `Data0`.`nom` AS `Data0.nom`, `Data0`.`description` AS `Data0.description`, `Data0`.`titre` AS `Data0.titre`, `Data0`.`category` AS `Data0.category`, `Data0`.`type` AS `Data0.type`, `Data0`.`annee` AS `Data0.annee`, `Data0`.`formateurs` AS `Data0.formateurs`, `Data0`.`niveau` AS `Data0.niveau`, `Data0`.`statut` AS `Data0.statut`, `Data0`.`file` AS `Data0.file`, `Data0`.`button12` AS `Data0.button12` FROM `inkou_chronoengine_chronoforms_datatable_formations` AS `Data0`
                        )

                )

        )

)

Can you help me please

Thanks

simbur

Hello simbur,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How to post information from a Chronoform to ZoHo
What are the 'Easy Form' and 'Form' Wizards?
How can I add a mask to format a form input?
P.S: I'm just an automated service😉

And I have html render too

I found the solution but have a one more problem, when I submit he reporte me

Champ 'Array' inconnu dans field list SQL=INSERT INTO `inkou_chronoengine_chronoforms_datatable_inscription` (`nom`, `prenom`, `email`, `etablissement`, `formation`, `hidden6`, `user_id`, `uniq_id`, `created`)

but I have a handle arrau so i don't understand

Hi simbur,

You need to debug your PHP you have an un-closed <?php tag in there.

I can't work out what all of this is trying to do - it looks like a bit of a mess to me :-(

The ChronoForms CheckBox Group action can be used with a DB Read action to load dynamic options from a Database table.

If you have a Handle Arrays action then it may be after the DB Save - but the big problem is that you have used a Model ID Data0 in your form but haven't used that in the DB Save action.

Bob

Hi Bob

I would like a dynamic checkbox who uplaod the data of my database.I use code in PHP tag because Idon''t undertsnad very well how work the dynamic data option for checboxgroup.What can I put in path data, value key etc

my field name is formations[]
I want uplaod the data of the table inkou_chronoengine_chronoforms_datatable_formations .
the value of the <option> have to be the field 'nom' and the label have to be 'nom' : 'titre'
after submit i want register the data in a table inscription

I hope that it is more clear

Simbur

It's ok , I found the error but i have a last question if i want edit registering in the admin list and i write Model.field as field name he don't find de data for the checkbox formations[].I wrote Inscription[formations[]] but it does'nt work

simbur

Hi Simbur,

Please see this FAQ

Bob

PS Try Inscription[formations][]