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

-- 
-- Table structure for table `modx_sponsor_user_info`
-- 

CREATE TABLE `modx_sponsor_user_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `status` varchar(50) NOT NULL default 'pending',
  `accepted` varchar(10) NOT NULL default 'no',
  `level` varchar(50) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `age` int(10) NOT NULL,
  `homephone` varchar(50) NOT NULL,
  `dayphone` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `address1` varchar(100) NOT NULL,
  `address2` varchar(100) NOT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(50) NOT NULL,
  `zipcode` varchar(50) NOT NULL,
  `bike` varchar(50) NOT NULL,
  `number` int(10) NOT NULL,
  `type` varchar(50) NOT NULL,
  `class` varchar(50) NOT NULL,
  `years` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

<?php
function sponsorInfo( &$fields )
	{
		
		// Bring needed resources into scope
		global $modx;
                $table_name = $modx->getFullTableName( 'sponsor_user_info' );


		// Init our array
		$dbTable = array(); // key = DB Column; Value = Insert/Update value

		// Insert field/value pairs to insert/update in our table
		$dbTable['firstname'] = $fields['firstname'];
		$dbTable['lastname'] = $fields['lastname'];
		$dbTable['age'] = $fields['age'];
		$dbTable['homephone'] = $fields['homephone'];
		$dbTable['dayphone'] = $fields['dayphone'];
		$dbTable['email'] = $fields['email'];
		$dbTable['address1'] = $fields['address1'];
		$dbTable['address2'] = $fields['address2'];
		$dbTable['city'] = $fields['city'];
		$dbTable['state'] = $fields['state'];
		$dbTable['zipcode'] = $fields[zip'];
		$dbTable['bike'] = $fields['bike'];
		$dbTable['number'] = $fields['number'];
		$dbTable['type'] = $fields['type'];
		$dbTable['class'] = $fields['class'];
		$dbTable['years'] = $fields['years'];
			
                print_r($dbTable);
	
		// Run the db insert query
		// $dbQuery = $modx->db->insert( $dbTable, $table_name);	

		return true;
	}
	// Return empty string
	return '';
?>

$dbQuery = $modx->db->insert( $dbTable, $table_prefix . 'insertTableName' );