• 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Get ALL user data when user is logged in?

Get ALL user data when user is logged in? 5 years 3 months ago #39729

  • serazoo
  • serazoo's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
Hello all and thanks in advance!

I'm using RSForm joomla registration plugin, works great!
I've added extra fields like « age » and « Hobby »
When a user registers, values of these extra fields are stored in RSForm submissions.

I've created a form/questionnaire that my logged users, will fill out and send in, each month.

In RSForm User and Admin emails, I want to include : name, email, hobby, age... without the user having to re-write them again, since all these infos are stored in Database.

I got the « name » and « email » working since they're in Joomla's Users infos

The question : how do I grab values of « age » and « Hobby » that are stored in RSForm submissions?

Here's code for the email and name that are working great!

//<code>
$user = JFactory::getUser(); return $user->get('name');
//</code>

//<code>
$user = JFactory::getUser(); return $user->get('email');
//</code>

Thanks so much :kiss:
Sandra
The administrator has disabled public write access.

Get ALL user data when user is logged in? 5 years 3 months ago #39730

  • serazoo
  • serazoo's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
I've created a hidden field called «hobby»
and in Default value, with the script

//<code>
$db = JFactory::getDbo();
$db->setQuery("SELECT `hobby` FROM `#__rsform_submission_values` WHERE `hobby`='value' LIMIT 1");
return $db->loadResult();
//</code>

and in the Admin email to show the result, I put : {hobby:value}

I was pretty sure this was gonna make it :(

I get he error in the frontend of my website : Unknown column 'hobby' in 'field list'

This is driving mad for a week now!

Please somebody shed some light :)
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!