[Tutorial] PhoneList Data Grid - eForm2db

<?php
function PhoneList( &$fields )
	{
		global $modx;
		// Init our array
		$dbTable = array();
		$dbTable[fullname] = $fields[fullname];
		$dbTable[phone] = $fields[phone];
		$dbTable[phone2] = $fields[phone2];
		$dbTable[note] = $fields[note];
		// Run the db insert query
		$dbQuery = $modx->db->insert($dbTable, 'mrhaw' );
		return true;
	}
?>

$dbTable[fullname] = $modx->db->escape($fields[fullname]);

CREATE TABLE `mytable` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fullname` varchar(255) NOT NULL,
  `phone1` varchar(255) NOT NULL,
  `phone2` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

<p class="error">[+validationmessage+]</p>
<form method="post" action="[~[*id*]~]" id="dbForm" name="dbForm">
	<fieldset class="form3">
		<label for="Name">Full_Name:
		<p><input name="fullname" id="name" class="form" type="text" eform="Full Name::1:Expected at least two words:#REGEX /^\w+\s\w+/i" /></p></label> 
		<label for="phone1">Phone #1:
		<p><input name="phone1" id="phone1" class="form" type="text" /></p> </label> 
		<label for="phone2">Phone #2:
		<p><input name="phone2" id="phone2" class="form" type="text" /></p> </label> 
		<label> </label><p><input type="submit" name="submit" id="submit" value="Submit" /></p> 
	</fieldset>
</form>

<h1>thank you!</h1>
Click <a href="[~[*id*]~]">HERE</a> to see it worked. 

<?php
function PhoneList( &$fields )
	{
		global $modx;
		// Init our array
		$dbTable = array();
		$dbTable[fullname] = $modx->db->escape($fields[fullname]);
		$dbTable[phone1] = $modx->db->escape($fields[phone1]);
		$dbTable[phone2] = $modx->db->escape($fields[phone2]);
		// Run the db insert query
		$dbQuery = $modx->db->insert($dbTable, 'mytable' );
		return true;
	}
return $html;
?>

<div style="background:#fff;">[*dataGrid*]</div>

[!PhoneList!] 
[!eForm? &noemail=`true` &formid=`dbForm` &eFormOnBeforeMailSent=`PhoneList` &tpl=`myform` &thankyou=`thankyou`!]

return $html;