Display RSForm Pro form submissions outside component

Display submissions outside of the RSForm Pro component.

There is probably a helper file in there somewhere for this. but here we go.

$submission->values = array(); //Create an arry to put all our submissions in 
$db = &JFactory::getDBO(); //Get Joomla Database
$db->setQuery("    
    SELECT s. * , v . *
    FROM #__rsform_submissions s
    LEFT JOIN #__rsform_submission_values v ON ( v.SubmissionId = s.SubmissionId )
    WHERE s.FormId =5
    AND v.FormId =5
    ORDER BY s.DateSubmitted DESC
"); // s.FormId and v.FormId equal the form id we want our submissions from

$fields = $db->loadObjectList();
foreach ($fields as $field){
        $submission->values[$field->SubmissionId][$field->FieldName] = $field->FieldValue;
}
print_r($submission->values);

You may be interested in...



Had enough browsing?

Get in touch

Get in touch

We wont charge you for the inital project meeting. So really you have nothing to lose.

Fill out the form below with as much information as you can provide and we will be in touch with you asap to discuss.

Name(*)
Please type your full name. Also only allowing alpha numeric characters here. Why do you have all this fancy stuff in your name anyway?

Email(*)
Invalid email address.

Phone
Please enter a valid phone number.

Enquiry Type(*)
Invalid Input

Message(*)
Please only use alphanumeric characters in your message

Invalid Input