Hello!
I'm quite new to ChronoForms, and I'd like to understand if it's possibile to save the content of a CheckBoxes Group in multiple columns in the database table (one choice/check -> one column) instead of just one column.
It's easier for me to make sql analysis having many columns than having all data in one comma-separated-text column.
How can I do this?
Thank you for your help!
Hi clovo,
Yes you can. There are two ways I can think of.
a) Give each of the checkboxes a different name - effectively using a lot of single checkboxes rather that a checkbox group. This is going to be messy if you have more than a handful of checkboxes.
b) Add custom code in the On Submit event to read the checkbox results and write them to separately names variables to save in the table columns.
Bob
Hi ciovo,
What is the Source code for your check box group?
Bob
Hi ciovo,
Please try this in a Custom Code action, it should be before any Handle Arrays action.<?php
$regions = JRequest::getVar('region', array(), 'post', 'array');
$region_values = array('one' => 'one', 'two' => 'two', 'three' => 'three');
foreach ( $region_values as $k => $v ) {
if ( in_array( $k, $regions ) ) {
$form->data['region_'.$k] = $v;
}
}
?>
This will put the values from the $region_values array into three form variables: region_one, region_two and region_three.
NB Not tested and may need debugging!
Bob
Hi wydo,
There's a ')' missing near the end of line 5 <?php
$categ = JRequest::getVar('input_discipline_categ', array(), 'post', 'array');
$categ_values = array('1' => '1', '2' => '2', '3' => '3','4' => '4','5' => '5','6' => '6','7' => '7','8' => '8','9' => '9');
foreach ( $categ_values as $k => $v ) {
if ( in_array( $k, $categ ) ) {
$form->data['input_discipline_categ_'.$k] = $v;
}
}
?>I'll fix my original post
Bob
Thanks a lot Bob,
Sorry, I know nothing about php :?
now I get a warning 9 times (as I have 9 fields I guess) :
Warning: in_array() [function.in-array]: Wrong datatype for second argument in ....../administrator/components/com_chronoforms/form_actions/custom_code/custom_code.php(18) : eval()'d code on line 5
and still no values in my fields in the table (I created them at the end of the field list, and they are named input_discipline_categ_1, input_discipline_categ_2 etc..)
Thank you!
Hi again,
I found the problem :
the parameters for in_array function are switched. It should be first the value searched ($k) then the array $categ
I is working, I'm really happy! thank you!
Hi wydo,
Well found :-( and apologies for my bug :-(
Bob
PS I'll correct my earlier post for other readers.
Hi Terejima ,
The values you have in the HTML are like value="langages_0" but in the code you are checking for the equivalent of value='0'
You need to change either the HTML to value='0', etc. or the array to$langages_values = array('langages_0' => '0', 'langages_1' => '1', 'langages_2' => '2');
Either change is OK but they must both use the same set of values.
Bob
Hi, Bob!
Having difficulties. Data from check group isn't divided.
Here's my checkbox group code, the Custom Code and event tab scrennshot:
<div class="ccms_form_element cfdiv_checkboxgroup radios_over" id="input_checkbox_group_141_container_div" style=""><input type="hidden" name="input_checkbox_group_14" value="" alt="ghost" />
<div><input type="checkbox" name="input_checkbox_group_14[]" id="input_checkbox_group_14_0" title="Must select" value="общение между мужчиной + женщиной" class="validate['group[14]']" />
<label for="input_checkbox_group_14_0">„общение между мужчиной + женщиной“</label>
</div><div><input type="checkbox" name="input_checkbox_group_14[]" id="input_checkbox_group_14_1" title="Must select" value="отношения родители и дети" class="validate['group[14]']" />
<label for="input_checkbox_group_14_1">„отношения родители и дети“</label>
</div><div><input type="checkbox" name="input_checkbox_group_14[]" checked="checked" id="input_checkbox_group_14_2" title="Must select" value="коммуникативные ситуации на работе" class="validate['group[14]']" />
<label for="input_checkbox_group_14_2">„коммуникативные ситуации на работе“</label>
</div><div><input type="checkbox" name="input_checkbox_group_14[]" checked="checked" id="input_checkbox_group_14_3" title="Must select" value="разные бытовые ситуации общения" class="validate['group[14]']" />
<label for="input_checkbox_group_14_3">„разные бытовые ситуации общения“</label>
</div><div><input type="checkbox" name="input_checkbox_group_14[]" checked="checked" id="input_checkbox_group_14_4" title="Must select" value="избавление от комплексов и страхов" class="validate['group[14]']" />
<label for="input_checkbox_group_14_4">„избавление от комплексов и страхов“</label>
</div><div><input type="checkbox" name="input_checkbox_group_14[]" id="input_checkbox_group_14_5" title="Must select" value="адаптация в чужой стране" class="validate['group[14]']" />
<label for="input_checkbox_group_14_5">„адаптация в чужой стране“</label>
</div><div><input type="checkbox" name="input_checkbox_group_14[]" id="input_checkbox_group_14_6" title="Must select" value="общение с представителем другой культуры" class="validate['group[14]']" />
<label for="input_checkbox_group_14_6">„общение с представителем другой культуры“</label>
</div><div><input type="checkbox" name="input_checkbox_group_14[]" id="input_checkbox_group_14_7" title="Must select" value="other" class="validate['group[14]']" />
<label for="input_checkbox_group_14_7">other</label>
</div></div>
Custom code:
<?php
$check_group = JRequest::getVar('input_checkbox_group_14', array(), 'post', 'array');
$check_group_values = array('0' => '0', '1' => '1', '2' => '2', '3' => '3', '4' => '4', '5' => '5', '6' => '6', '7' => '7');
foreach ( $check_group_values as $k => $v ) {
if ( in_array( $k, $check_group ) ) {
$a = check_group_.$k = $v;
print_r($a);
$form->data['check_group_'.$k] = $v;
}
}
?>
The new array is empty😟 and the data is still separated by comma
[attachment=1]first.png[/attachment]
[attachment=0]second.png[/attachment]
Thank you!
Hi 01,
What are you actually trying to do?
The values of your checkboxes are strings like 'отношения родители и дети' so they will never match the digits (0, 1, 2 . . .) you are comparing them to.
Bob
Hi Bob!
Now all values are written to DB in a one row, and values from checkbox are written with comma separator. For better statistics I need to write each selected value from checkbox group separately (in another row or probable DB(but in would be harder to implement))
Hi 01,
OK that's what the code does, but you need to match it to your set of options. The code was written for a set of options that look like:1=„отношения родители и дети“
2=„общение между мужчиной + женщиной“
. . .your options look like:
отношения родители и дети=„отношения родители и дети“
общение между мужчиной + женщиной=„общение между мужчиной + женщиной“
. . .
You need either to change the keys (the part before the =) in your options to make them simpler, or you have to modify the code to work with your string keys.
Bob
Hi, Bob!
Thank you for explanations!
I will try to get it working🙂
