Submit external data to RSForms MySQL table

Question

I have a form on a non-Joomla website which has the following fields:

• Full Name
• Email Address
• Work In A Pub (Tick box)
• Supplier (Tick box)
• Over 18

I have the following code to send from the external form through to the Joomla database (Joomla is using RSForms to capture this exact data):

     // read form
     if(strcasecmp($_GET['method'],'subscribe') == 0){

         $fullName = $_POST['fullName'];
         $emailAddress = $_POST['emailAddress'];
         $worksInPub = ($_POST['workInPub']==='true');
         $isSupplier = ($_POST['isSupplier']==='true');
         $isOver18 = ($_POST['isOver18']==='true');

         // Do something here with the data. If it fails, modify $response['code'] accordingly

         $response['code'] = 1;

         $response['status'] = $api_response_code[ $response['code'] ]['HTTP Response'];
         $response['data'] = $api_response_code[ $response['code'] ]['Message'];

     } 

What code do I need to write to submit the above variables through to the RSForms table in the database?

If I use a sql statement then it won't have the SubmissionId in it (as this is from a different database table

Answer 1

All you need to do is write a database query. I would suggest importing the Joomla API and writing a Joomla styled query like so:

$fullName     = $_POST['fullName'];
$emailAddress = $_POST['emailAddress'];
$worksInPub   = ($_POST['workInPub']==='true');
$isSupplier   = ($_POST['isSupplier']==='true');
$isOver18     = ($_POST['isOver18']==='true');

$db = JFactory::getDbo();     
$query = $db->getQuery(true);

$columns = array('fullName', 'emailAddress', 'workInPub', 'isSupplier', 'isOver18');
$values = array($db->quote($fullName), $db->quote($emailAddress), $db->quote($workInPub), $db->quote($isSupplier), $db->quote($isOver18));

$query->insert($db->quoteName('#__rs_forms_table'))
      ->columns($db->quoteName($columns))
      ->values(implode(',', $values));

$db->setQuery($query);
$db->execute();

I have never used RSForms before so I don't know how the data for your forms is stored, so the above may be wrong. There may also be a few tweaks to make to the code, such as the database table name