Hi Guys,

I'm trying to extra information from my RSForm! Pro form after submission and use it to query the Joomla database, and display it back to the user as follows:

1) Script called on form process ($POST)

---

// retrieve form data (container numer)
$container = JRequest::getVar('ContainerName');

// create reference to global database
$db =& JFactory::getDBO();

// create query
$query = "SELECT * FROM jos_tracking a".
"INNER JOIN jos_tracking_location b ON a.container = b.container".
"WHERE a.container LIKE '" . $container . "'";


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

// return results
$containers = $db->loadObjectList();


2) Script called after form has been processed ($thankYouMessage)

---

// Thank you message
$thankYouMessage = "Unfortunately, we don't have information at the moment for the container number you've provided. Please do try again later";

// if the container variable is not empty, loop through it and display output
if(count($containers)){

foreach($containers as $container){

echo "<p>". JText::_($container->container) . "</p>";

}

}else{

echo "<p>".$thankYouMessage."</p>";

}

As you can see my script is not functioning. I'm missing something somewhere. I'd be very grateful if someone can put me back on track.

Thank you in advance

Hello,

Variables defined in one scripting section can't be used in another section. You could simply move the whole thing in the Scripts called after form process area.

Thanks for your quick response, Admin. I'll use your suggestion. Once more thank you.

Hi Guys,

I'm trying to write a php script that would extra information from a submitted RSForm! Pro form and use it to query the Joomla Database. Below is a screenshot of what i'm trying to do with RSForm! Pro.

@ankush1,

Note that you can't add attachments. Please use a sharing service and post the URL.