Snippet: eFreg v 0.2 - eForm based Web User Registration (ppp enabled)

// save user attributes

		$values = '';
		$valuesFields = '';
		$preparedFieldNames = '';
		$preparedTableFields = '';
		
		if(is_array($efreg_inputs_opt)){
				$k=0;
				foreach($efreg_inputs_opt as $name => $value) {
					$valuesFields[] = $name;
					$values[] = trim($value);
					$values[$k] = "'" . $values[$k] . "'";
					$k++;
				}
				$preparedFieldNames = ", " . implode(', ', $valuesFields);
				$preparedTableFields = ", " . implode(', ',$values);
		}
		
    $sql = "INSERT INTO ".$modx->getFullTableName("web_user_attributes")." (internalKey, fullname, email $preparedFieldNames) 
            VALUES($key, '$fullname', '$email' $preparedTableFields);";

if ($_POST[$input_prefix.'country']) $country = $modx->db->escape($modx->stripTags($_POST[$input_prefix.'country']));
	if ($_POST[$input_prefix.'state']) $state = $modx->db->escape($modx->stripTags($_POST[$input_prefix.'state']));
	if ($_POST[$input_prefix.'zip']) $zip = $modx->db->escape($modx->stripTags($_POST[$input_prefix.'zip']));
	if ($_POST[$input_prefix.'phone']) $efreg_inputs_opt['phone'] = $modx->db->escape($modx->stripTags($_POST[$input_prefix.'phone']));
	if ($_POST[$input_prefix.'mobilephone']) $efreg_inputs_opt['mobilephone'] = $modx->db->escape($modx->stripTags($_POST[$input_prefix.'mobilephone']));	
	if ($_POST[$input_prefix.'dob']) $efreg_inputs_opt['dob'] = $modx->db->escape($modx->stripTags($_POST[$input_prefix.'dob']));	
	if ($_POST[$input_prefix.'gender']) $efreg_inputs_opt['gender'] = $modx->db->escape($modx->stripTags($_POST[$input_prefix.'gender']));		
	if ($_POST[$input_prefix.'fax']) $efreg_inputs_opt['fax'] = $modx->db->escape($modx->stripTags($_POST[$input_prefix.'fax']));		
	if ($_POST[$input_prefix.'photo']) $efreg_inputs_opt['photo'] = $modx->db->escape($modx->stripTags($_POST[$input_prefix.'photo']));			
	if ($_POST[$input_prefix.'comment']) $efreg_inputs_opt['comment'] = $modx->db->escape($_POST[$input_prefix.'comment']);	

$efreg_extra_inputs = array('country','state','zip','phone','mobilephone','dob','gender','fax','photo','comment');
	foreach($efreg_extra_inputs as $input => $putInArray){
		if($_POST[$input_prefix.$input]){ 
			 $efreg_inputs_opt[$input] = $modx->db->escape($modx->stripTags($_POST[$input_prefix.$input]));
		}
	}