$db_user = ´root´;
		  $db_password = ´muffin´;
		  $db_Name = ´sakila´;
		  $db_Table = ´customer´;
		  $db_port = ´3307´; //optional
		  

		// Database Connection
		$db_user = 'user';
		$db_password = 'password';
		$db_Name = 'a1-sales';
		$db_Table = 'customers';
		$db_port = '3307';   // Change to match the port # for your mySQL
		

		define('DB_SERVER', 'localhost:3307');
		define('DB_USER', 'user');
		define('DB_PASS', 'password');
		define('DB_NAME', 'a1-sales');
		define('DB_TABLE', 'customers');
		

		// Set the mySql connection
		$db_user = ´user´;
		$db_password = ´password´;
		$db_Name = ´a1-sales´;
		$db_Table = ´customers´;
		$db_port = ´3307´;  // optional(only to connect other than port 3306
		

		$appTitle = ´Customers´;
		

		$appTheme = ´green´;
		

		$db_WidgetOptions = "´filter´,  ´resizable´";
		

		$db_Where = ´LastName=%s,Jones´;
		

		$db_OrderBy = "CompanyName";
		

		$db_ColumnSort = "[2,0],[1,0]";
		

		$db_PageSize = 5;
		

		$db_StartPage = 0;
		

		$db_PageSelector = "5,10,15,20,50,100,ALL";
		

		$db_Pager = 3;
		

		$strFieldNames = "ID,COMPANY,FIRSTNAME,LASTNAME,ADDRESS,CITY,STATE,ZIP";
		

		$strFieldType  	= ´text,select,text,typeahead,email,checklist,date,wysihtml5´;
		

14 Define the Select options for adding and editting records

The field must be set to select in $strFieldType (above)

Make sure you define $arrSelect as an array

		$arrSelect = array();
        // Then set these to the fields you need them on
		$arrSelect[1] = "{´´: ´Select Company´, ´A1-SALES´: ´A1-SALES´, ´A2-SALES´: ´A2-SALES´, ´A3-SALES´: ´A3-SALES´}";
		$arrSelect[12] = "{´´: ´Select Sales Rep´, ´Chuck´: ´Chuck Simple´´Kevin´: ´Kevin Lewis´}";
		$arrSelect[16] = "[{value: ´1´, text: ´Level-1´}, {value: ´2´, text: ´Level-2´}, {value: ´3´, text: ´Level-3´}]";
		$arrSelect[17] = "[{value: ´Red´, text: ´Red´}, {value: ´White´, text: ´White´}, {value: ´Blue´, text: ´Blue´}}]";
		$arrSelectValue[17] = "";
		$arrSelect[18] = "{´´: ´Select´, ´Active´: ´Active´, ´Non-Active´: ´Non-Active´, ´Vaccation´: ´Vaccation´}";
		

15 Define typeahead Options for adding and editting records

		$arrSelect[7] = "[{value: ´AL´, text: ´Alabama´},{value: ´AK´, text: ´Alaska´},{value: ´AZ´, text: ´Arizona´},{value: ´AR´, text: ´Arkansas´},{value: ´CA´, text: ´California´},{value: ´CO´, text: ´Colorado´},{value: ´CT´, text: ´Connecticut´},{value: ´DE´, text: ´Delaware´},{value: ´FL´, text: ´Florida´},{value: ´GA´, text: ´Georgia´},{value: ´HI´, text: ´Hawaii´},{value: ´ID´, text: ´Idaho´},{value: ´IL´, text: ´Illinois´},{value: ´IN´, text: ´Indiana´},{value: ´IA´, text: ´Iowa´},{value: ´KA´, text: ´Kansas´},{value: ´KT´, text: ´Kentucky´},{value: ´LO´, text: ´Louisiana´},{value: ´ME´, text: ´Maine´},{value: ´MD´, text: ´Maryland´},{value: ´MA´, text: ´Massachusetts´},{value: ´MI´, text: ´Michigan´},{value: ´MN´, text: ´Minnesota´},{value: ´MS´, text: ´Mississippi´},{value: ´MO´, text: ´Missouri´},{value: ´MT´, text: ´Montana´},{value: ´NE´, text: ´Nebraska´},{value: ´NV´, text: ´Nevada´},{value: ´NH´, text: ´New Hampshire´},{value: ´NJ´, text: ´New Jersey´},{value: ´NM´, text: ´New Mexico´},{value: ´NY´, text: ´New York´},{value: ´ND´, text: ´North Dakota´},{value: ´NC´, text: ´North Carolina´},{value: ´OH´, text: ´Ohio´},{value: ´OK´, text: ´Oklahoma´},{value: ´OR´, text: ´Oregon´},{value: ´PA´, text: ´Pennsylvania´},{value: ´RI´, text: ´Rhode Island´},{value: ´SC´, text: ´South Carolina´},{value: ´SD´, text: ´South Dakota´},{value: ´TN´, text: ´Tennessee´},{value: ´TX´, text: ´Texas´},{value: ´UT´, text: ´Utah´},{value: ´VT´, text: ´Vermont´},{value: ´VA´, text: ´Virginia´},{value: ´WA´, text: ´Washington´},{value: ´WV´, text: ´West Virginia´},{value: ´WI´, text: ´Wisconsin´},{value: ´WY´, text: ´Wyoming´}]";

	    OR

	    $arrSelectgroups[8] = "includes/groups/groups.php"; //see setting groups below
		

16 Define group Options for adding and editting records

• Settings
• GroupFile

		$arrSelectgroups[8] = "includes/groups/groups.php";
		

		<?php
		sleep(1);
		$groups = array(
		array(´value´ => ´37010´, ´text´ => ´ADAMS TN 37010´),
		array(´value´ => ´37011´, ´text´ => ´ANTIOCH TN 37011´),
		array(´value´ => ´37012´, ´text´ => ´ALEXANDRIA TN 37012´),
		array(´value´ => ´37013´, ´text´ => ´ANTIOCH TN 37013´),
		array(´value´ => ´37014´, ´text´ => ´ARRINGTON TN 37014´),
		array(´value´ => ´37015´, ´text´ => ´ASHLAND CITY TN 37015´),
		array(´value´ => ´37016´, ´text´ => ´AUBURNTOWN TN 37016´),
		array(´value´ => ´37018´, ´text´ => ´BEECHGROVE TN 37018´),
		array(´value´ => ´37019´, ´text´ => ´BELFAST TN 37019´),
		array(´value´ => ´37020´, ´text´ => ´BELL BUCKLE TN 37020´),
		array(´value´ => ´37022´, ´text´ => ´BETHPAGE TN 37022´),
		array(´value´ => ´37023´, ´text´ => ´BIG ROCK TN 37023´),
		);
		echo json_encode($groups);
		?> >
		

17 Define Select2 Options for adding and editting records(OPTIONAL)

• Settings
• Additional Settings

		$arrSelect2[20] = "[´html´, ´javascript´, ´css´, ´ajax´]";
		
User can also enter his own tag as well as from the list
		OR
		$arrSelect2[20] = ´[{id: "EN", text: "EN"}, {id: "RU", text: "RU"}, {id: "GB", text: "GB"}]´;
		

		$MaxSelection2[20] = 2;
		

		$MinInputLength2[20] = 1;
		

		$MaxInputLength2[20] = 1;
		

		$AutoTokenSeparators2[20] = 1;
		

		$CustomMatcher2[20] = "yes";
		

18 Show icons for VIEW,EDIT,DELETE (OPTIONAL)

defaults to 1 to show as Text

0 = Text. 1 = Buttons

		$dbButtons = 1;
		

19 Set if can View Records (OPTIONAL)

Defaults to 1 to show link

1 = Alows and shows a link on the right side of the row.

0 = Hide the link and don't allow View Record

		$dbCanView =
		

20 Set if can Edit Records (Optional)

Defaults to 0 - Can Not Edit Record

Required if you want to edit the record

1 = Alows and shows a link on the right side of the row.

0 = Hide the link and don't allow Edit Record

You can still enable inline editting. See settings for $strDisplayInlineEdit

		$dbCanEdit = 1;
		

21 Set if can Add Records (OPTIONAL)

Defaults to 0 - Can Not Add New Record

1 = Alows and shows a link on the right side of Pager

0 = Hide the link and don't allow Add Record

		$dbCanAdd = 1;
		

22 Set if can Delete Records (OPTIONAL)

Defaults to 0 - Can Not Delete Record

1 = Alows and shows a link on the right side of the row.

0 = Hide the link and don't allow Delete Record

		$dbCanDelete = 1;
		

23 Sets a Field to Display as an Image (OPTIONAL)

Only the path and image name is stored in the database field

The Image Field Name in the database MUST be Named 'IMGPhoto'

This only allows one image per record to be displayed

The next version will allow multi inages

		$db_ImageFieldName = "IMGPhoto";
		

24 Set the Fields to Display for LIST and Child Rows (OPTIONAL)

Default is 1 - Must be set if usinf Inline Edit or Child Rows

Note: If $strDisplayList NOT SET IN CONFIG all records will show

If Using a Child Row refer to $db_ChildTemplate and $ChildRowHeader

The Fields on the Child Row must also be fields from the parent $db_Name and $db_Table

This option is great for rows that have many fields

It enables you to still display them in the child row (no inline edit)

Set the Field Display option from the chart below

Note: the 1st Field # is 0

Note: Child Rows are not editable in this version

Note: If not using the Child Row then only use option 0 and 1

0 = No Show
1 = Show on Table List only
2 = Show on Table List as the Link to Child Row
3 = Show on Child Row only
4 = Show on Table List and Child Row

		$strDisplayList = "244430333310000000013"
		

25 Set the Fields to View when Viewing a Record (OPTIONAL)

Defaults to 1 - All Fileds Show in View

This allows you to hide certain Fields for security etc.

0 = No Show

1 = Show

		$strDisplayView  = "01111110001011111111";
		

26 Set the Fields to view and edit (OPTIONAL)

This allows you to hide certain Fields for security etc.

Defaults to 1 - All Fields are set as a popup

0 = No Show

1 = Show and is Editable with a popup edit

2 = Show and is Editable with inline edit

3 = Shows but Not Editable

		$strDisplayViewEdit = "02112222221221222222"
		

27 Set the Fields allowed for Inline Edit (OPTIONAL)

Defaults to 1 as a popup

0 = Field is not editable

1 = Field is Editable with a popup edit

2 = Field is Editable with inline edit

		$strDisplayViewEdit = "02112222221221222222"
		

28 Set the Fields that will show when adding a new record (OPTIONAL)

Defaults to 1 as a popup

$dbCanEdit = 1; must be enabled for the add link to show

0 = Field is not editable and will not show

1 = Field is Editable with a popup edit

2 = Field is Editable with inline edit

		$strDisplayAdd = "02112222222122122222"ot;
		

29 Set Field to be Required when Adding/Editting (OPTIONAL)

$dbCanEdit = 1; must be enabled for this feature

It will Display a red * by the Field Name when Adding a new record

0 = Field is not Required

1 = Field is Required

		$strRequired = "01110000000000000000";
		

30 Set the Columns that are Sortable (OPTIONAL)

Defaults to Sort on all Column

0 = Field is not Sortable

1 = Field is Sortable

		$strSortable = "11110011100011011110";0000";
		

31 Set the Columns that are Resizable (OPTIONAL)

Defaults to No Resize of Columns

0 = Field is not Resizable

1 = Field is Resizable

		$strResizable = "11110011100100100000";
		

32 Set the Columns Filter (OPTIONAL)

Defaults to No Filter

0 = Field has no Filter

1 = Field has Filter

		$strFilter = "01110000000000010010";
		

33 Set the Columns Filter to always show or hide (OPTIONAL)

Defaults to false

true = Filter will hide until mouse is over it

false = Filters always shows

		$db_HideFilter = ´true´;
		

34 Set the option for filter to TEXT FIELD or SELECT (OPTIONAL)

Defaults to TEXT

0 = Filter will be a input text box

1 = Filter will be a select box (values for the select option bome from the data in that column

		$strFilterSelect = "01110000000000010010";
		

35 Using a Child Row Template (OPTIONAL)

		$db_ChildTemplate = "Customers-Child-Template.html";
		

	<div class="wrapper">
	<div class="row">
		  <div class="span1">
		  <img class="img-rounded" src="{IMGPhoto}" width="60">
		  </div>
		  <div class="span2">
		  <h5>
		  {ContactFirstName} {ContactLastName}<br>
		  {Address1}<br>
		  {City}, {State} {zip}<br>
		  {Phone}
		  </h5>
		  </div>
		  <div class="span3">
			<dl class="dl-horizontal">
				  <dt>DateEntered</dt><dd>{DateEntered}</dd>
				  <dt>Email</dt><dd>{Email}</dd>
				  <dt>Level</dt><dd>{PriceLevel}</dd>
				  <dt>CreditLimit</dt><dd>{CreditLimit}</dd>
			</dl>
		  </div>
			<div class="span3">
			<dl class="dl-horizontal">
				  <dd>{Memo}</dd>
			</dl>
		  </div>
	</div>
	</div>
		

		/* Child Row CSS */
		.wrapper{
			float: left;
			left: 11.00%;
			width: 80%;
			padding:.20%;
			border: 1px solid #336699;
			background-color: #ffffff;
		}
		/* End Child Row CSS */
		

		$ChildRowHeader = "SHIP TO";
		

		$strPopupPlacement    = "012330000000000000003";
		

		$TextareaRows[26] = 7;
		

		$DateType[21] = "date";
		

		$DateFormat[21] = "yyyy-mm-dd";
		

		$DateWeekStart[21] = 0;
		

		$DateStartDate[21] = "2013-01-01";
		

		$DateEndDate[21] = "2015-12-31";
		

		$DateWeekDaysDisabled[21] = "0,6";
		

		$DateStartView[21] = 2;
		

		// COMBODATE DATE ONLY
		$DateType[13] = "combodate";
		$DateFormat[13] = "YYYY-MM-DD";
		$ComboDateTemplate[24] = "YYYY/MMMM/DD";
		$ComboDateMinYear[24] = '2010';
		$ComboDateMaxYear[24] = '2015';
		

		// COMBODATE TIME ONLY
		$DateType[22] = "combodate";
		$DateFormat[22] = "HH:mm";
		$ComboDateTemplate[22] = "hh:mm a";
		$ComboTimeMinuteStep[22] = 15;
		

		// COMBODATE YEAR ONLY
		$DateType[23] = "combodate";
		$DateFormat[23] = "YYYY";
		$ComboDateTemplate[23] = "YYYY";
		$ComboDateMinYear[23] = '2010';
		$ComboDateMaxYear[23] = '2015';
		

		// COMBODATE DATETIME
		$DateType[24] = "combodate";
		$DateFormat[24] = "YYYY-MM-DD HH:mm";
		$ComboDateTemplate[24] = "YYYY/MMMM/DD hh:mm a";
		$ComboDateMinYear[24] = '2010';
		$ComboDateMaxYear[24] = '2015';
		$ComboTimeMinuteStep[24] = 15;
		

		// COMBODATE TIMESTAMP
		$DateType[25] = "combodate";
		$DateFormat[25] = "YYYY-MM-DD HH:mm";
		$ComboDateTemplate[25] = "YYYY/MMMM/DD hh:mm a";
		$ComboDateMinYear[25] = '2010';
		$ComboDateMaxYear[25] = '2015';
		$ComboTimeMinuteStep[25] = 15;