Hi Wesley,
I can't understand what you need, can you show me some example data ?
Regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Hi Wesley,
I think I understand you now, you need 2 tables, a "students" table which would be the "basic" fields like "id" or "cf_id"..etc + any student info like "name" and "email".
then you need a second table called for example "student_data", this 2nd table will have all the fields can be seen in the screenshot you attached, I think 10 fields ? + some primary key field, like "id" or "cf_id" + a field named "student_id" to assign any record to the "students" table, now every student should have 1 record at the students table and may have 0 or more records at the "students_data" table, good ?
here is how to do this, you will need Chronoforms V4 RC1.2 installed and working.
Your form code (according to the screenshot) will have 2 fields for the "name" and "email" (students table), then say 10 fields field1, field2, field3..etc (students_data table), your form fields name will be "name" and "email" + an array of fields for the others, how ? by attaching a "[]" to the field name, so its expected to have 25 fields named "field1[]" and 25 fields named "field2[]"..etc
save your form code in a new form then go to the wizard, drag a "show HTML" action to the "onLoad" event, and in the "on submit" you will drag 2 things, a "DB Save" action, click the "config" icon and select your "students" table, insert the "model id" as "student", then click "apply", then drag a "Custom code" action to the onsubmit event, in the "Custom code", show the "code" box by clicking the "show/hide" link and insert this code:
<?php
//get the student_id
$form->data['student_id'] = $form->data['student_id']; // this depends on the primary key of your students table, if its "id" and the Model id was "student" then it will be like above.
//start the loop
$mydata = $form->data;
foreach($mydata['field1'] as $k => $v){
$form->data = $mydata;
$form->data['field1'] = $mydata['field1'][$k];
$form->data['field2'] = $mydata['field2'][$k];
//then all the fields here
//start the save process
$db_save_details = new stdClass();
$db_save_details->type = 'db_save';
$db_save_details->params = 'table_name=YOUR_TABLE_NAME_HERE'; //insert your table name
$form->runAction($db_save_details);
//end the save process
}
$form->data = $mydata;
?>
That's it, that should save the student name, email in the 1st table and all his details in the 2nd table, I wish that was helpful🙂
Regards,
Max
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Thanks Max, this is exactly what I was needing!! The field "[]" is awesome! Pulling up my form now to give it a try.
Thanks again and for your time!,
Wesley
Hi hominid4,
I have no experience in doing this with CF v4 so can't help much :-(
The error message suggests that $mydata['field1'] isn't an array. I'd add a line of debug code to display the contents of &mydata to see exactly what is there. This ought to work OK:$mainframe->enqueuemessage('$mydata: '.print_r($mydata, true));
Bob
Hi Bob, I'm sorry, when I insert that code it receives a:
Fatal error: Call to a member function enqueuemessage() on a non-object in /administrator/components/com_chronoforms/form_actions/custom_code/custom_code.php(15) : eval()'d code
I've inserted it in my above PHP code, is that correct?
Thank you!,
Wesley
Hi wesley,
Sorry, you need global $mainframe; on the preceding line to make the method available.
Bob
That's a neat little script, thanks.
This is the results it returned:
$mydata: Array ( [name] => Wesley [email] => [email]wesley@myemail.com[/email] [field1] => Field One A Test, Field One B Test [field2] => Field Two A Test, Field Two B Test [input_submit_3] => Submit [student] => Array ( [name] => Wesley [email] => [email]wesley@myemail.com[/email] [field1] => Field One A Test, Field One B Test [field2] => Field Two A Test, Field Two B Test [input_submit_3] => Submit ) [student_cf_id] => 17 [student_id] => 17 )
Hi hominid4,
You need similar code to explode the field2 data back into an array I think.
There is something odd with $mydata though, it appears to have a second copy of the data as a 'student' array inside itself.
$mydata: Array (
[name] => Wesley
[email] => wesley@myemail.com
[field1] => Field One A Test, Field One B Test
[field2] => Field Two A Test, Field Two B Test
[input_submit_3] => Submit
[student] => Array (
[name] => Wesley
[email] => wesley@myemail.com
[field1] => Field One A Test, Field One B Test
[field2] => Field Two A Test, Field Two B Test
[input_submit_3] => Submit
)
[student_cf_id] => 17
[student_id] => 17
)
Puzzled . . .
Bob
I'm sorry, wish I could be more help, maybe Max can help elaborate on the $mydata. The idea is for cf_id,name,email dump into table "form_student_info", and cf_id,field1,field2,student_id" dump into table "form_student_data". With the current code it seems to be doing that correctly, the "form_student_info" is populated correctly, just when it gets to the student data table is the error.
My current code:<?php
//get the student_id
$form->data['student_id'] = $form->data['student_cf_id']; // this depends on the primary key of your students table, if its "id" and the Model id was "student" then it will be like above.
//start the loop
$mydata['field1'] = explode(', ', $mydata['field1']);
foreach($mydata['field1'] as $k => $v){
$form->data = $mydata;
$form->data['field1'] = $mydata['field1'][$k];
$form->data['field2'] = $mydata['field2'][$k];
//then all the fields here
//start the save process
$db_save_details = new stdClass();
$db_save_details->type = 'db_save';
$db_save_details->params = 'table_name=form_student_data'; //insert your table name
$form->runAction($db_save_details);
//end the save process
}
$form->data = $mydata;
?>
Thank you!,
Wesley
Hi Max, would you by chance have a second before the weekend to help with this? My client keeps asking me when the form will be functional and was needing to have it going this weekend.
Thank you!!,
Wesley
Hi Wesley,
Sorry not to be more help. I'm just not familiar enough with the v4 code. Do send Max a message through the Contact Us form here.
Bob
Thanks Bob, I contacted Max and he fixed me right up!! Below is the code that works:
<?php
//get the student_id
$form->data['student_id'] = $form->data['student_cf_id'];
$mydata = $form->data;
foreach($mydata['field1'] as $k => $v){
$form->data = $mydata;
$form->data['field1'] = $mydata['field1'][$k];
$form->data['field2'] = $mydata['field2'][$k];
//start the save process
$db_save_details = new stdClass();
$db_save_details->type = 'db_save';
$db_save_details->params = 'table_name=form_student_data';
$form->runAction($db_save_details);
//end the save process
}
$form->data = $mydata;
?>
Thanks to both of you!!,
Wesley
