Creating online form with fields filled up with membership details

$this->execPieceByName('ff_InitLib'); $db = JFactory::getDbo(); $db->setQuery("Select * From #__osmembership_subscribers Where user_id = " . $db->quote(JFactory::getUser()->get('id'))); $subscriber = $db->loadObject(); ff_setValue('last_name', $subscriber->last_name); ff_setValue('first_name', $subscriber->first_name); ff_setValue('membership_id', $subscriber->membership_id); $query = $db->getQuery(true) ->select('a.name, b.field_value') ->from('#__osmembership_fields AS a') ->innerJoin('#__osmembership_field_value AS b ON a.id = b.field_id') ->where('b.subscriber_id = ' . $subscriber->id); $db->setQuery($query); $fieldValues = $db->loadObjectList('name'); if (isset($fieldValues['test_field_1'])) { $testField1Value = $fieldValues['test_field_1']->field_value; } else { $testField1Value = ''; } if (isset($fieldValues['test_field_2'])) { $testField2Value = $fieldValues['test_field_2']->field_value; } else { $testField2Value = ''; }

ff_setValue('idnumber', $idnumberValue);