JsonFormBuilder

• FormItbuilder
• Demos
  • Basic Form
  • Complex Form
  • Matrix Elements
• Documentation
  • The FormItBuilder Object
  • Form Elements
  • Adding your own custom validation
  • Output form javascript into a placeholder
  • Recording form data into a database table
  • Setting up an Auto Responder
  • Using reCAPTCHA
• Download FormItBuilder
• ToDo List / Wish List
• It's not working! (FAQs)

Recording form data into a database table

As of version 0.1.8 you have the ability to map form fields to write to an xPDO table like so

//Demo Table Mapping (Allows auto entry of data into an mysql Table (xPDO object)
$o_form->setDatabaseObjectForInsert('tableClass',array(
    array($o_name,'name'),
    array($o_address,'address'),
    array($o_country,'country'),			
));

Of course to write to an xPDO object you need to first create one. There are many guides around but Bob Ray has a great example here http://bobsguides.com/custom-db-tables.html.

The tableClass would obviously relate to an existing and included table (modUser or modResource etc.). The second parameter of the setDatabaseObjectForInsert method needs to contain an array which maps each form object to a field key within the table.