How to update Community Builder fields of user with RSFORM

Question

I have Joomla 3.8.11 and RSFORM 2.0.14.

I want to update the Community Builder fields of the logged-in user.

The main fields that I am trying to update are via some checkboxes:

The checkbox field from RSFORM has exactly the same values that the checkbox fields from Community Builder have.

I tried this method: https://www.rsjoomla.com/support/documentation/rsform-pro/custom-scripting/update-a-field-from-community-builder.html

And this method: https://www.rsjoomla.com/blog/view/314-rsformpro-user-profile-community-builder-and-mappings.html

But it doesn't work. When I go to see the profile, I don't see the fields updated and there is no error message.

Here is the code that I added in php option "Script called on form process":

$db = JFactory::getDBO();
$user = JFactory::getUser();
$db->setQuery("UPDATE njhggy_comprofiler SET cb_skills = '".$db->escape($_POST['form']['skills'])."' WHERE user_id = '".$db->escape($user->id)."'");
$db->query();

Does anyone know what I am doing wrong?

Answer 1

There may or may not be addition issues with your attempt, but I can tell at first glance that you are not executing your UPDATE query.

https://docs.joomla.org/Inserting,_Updating_and_Removing_data_using_JDatabase#Updating_a_Record

$db = JFactory::getDBO();
$user = JFactory::getUser();
$db->setQuery("UPDATE #__comprofiler SET cb_skills = " . $db->q($_POST['form']['skills']) . " WHERE user_id = " . (int)$user->id);
$db->execute();

or with an object:

$object = (object)['user_id' => JFactory::getUser()->id, 'cb_skills' => $_POST['form']['skills']];
JFactory::getDBO()->updateObject('#__comprofiler', $object, 'user_id');