[Snippet] eForm2db 0.1BETA - Manipulate DB records via eForm and MODx DBAPI

<?php
function eForm2db( &$fields )
	{
		/*---------------------------------------------------------------		
		eForm2db 
		Version: 0.1 [Beta 1]
		Author: pixelchutes
		---------------------------------------------------------------
		Requirements:
			eForm 1.4+
		---------------------------------------------------------------
		Use:
			- Takes validated eForm submittal data for use with the MODx DBAPI extender class.								
			- Easily process database records referencing your form submission data:				  
			  + INSERT new records to a table of your choice				  
			  + UPDATE existing records if you'd prefer				  
			  + DELETE records based on form submittal criteria				  
			  + Form a query and return its record set as XML using $modx->db->getXML				  
			  + Query a table's MetaData using $modx->db->getTableMetaData, followed by an update query
			    on only the form fields that are named after table columns!				    
			  + and much more! 
		---------------------------------------------------------------*/

		// Bring needed resources into scope
		global $modx, $table_prefix;

		// Init our array
		$dbTable = array(); // key = DB Column; Value = Insert/Update value
		$dbTable['firstname'] = $fields['firstname'];
		$dbTable['lastname'] = $fields['lastname'];
		$dbTable['email'] = $fields['email'];
		$dbTable['phone'] = $fields['phone1'].$fields['phone2'].$fields['phone3'];
		$dbTable['address'] = $fields['address'];
		$dbTable['city'] = $fields['city'];
		$dbTable['state'] = $fields['state'];
		$dbTable['postal'] = $fields['postal'];
		$dbTable['gender1'] = $fields['gender1'];
		$dbTable['size1'] = $fields['size1'];
		$dbTable['gender2'] = $fields['gender2'];
		$dbTable['size2'] = $fields['size2'];
		$dbTable['garments'] = $fields['garments'];
		$dbTable['activities'] = $fields['activities'];
		$dbTable['thoughts'] = $fields['thoughts'];
		$dbTable['optin'] = $fields['optin'];

		// Insert field/value pairs to insert/update in our table

		// INSERT - $dbQuery = $modx->db->insert( $dbTable, $table_prefix . 'insertTableName' );
		// UPDATE - $dbQuery = $modx->db->update( $dbTable, $table_prefix . 'updateTableName' );
		// DELETE - $dbQuery = $modx->db->delete( $table_prefix . 'deleteFromTableName', 'some_field = 1 AND name=\''.$dbTable[name].'\'', '' );
		// etc...
				
		// Run the db insert query
		$dbQuery = $modx->db->insert( $dbTable, 'pl_banff_contest' );		

		return true;
	}
	return '';
?>

[!eForm? &runSnippet=`eForm2dbBanff` &formid=`banffContestForm` &noemail=`true` &eFormOnBeforeMailSent='eForm2db' &tpl=`banff-contest-form` &thankyou=`thank-you-contest` &vericode=`1`!]

 $activitiesList = '';
		foreach ( $fields['activities'] as $value ) {
                            $activitiesList = $activitiesList . $value . ' ';
                }