phpGrid\C_DataGrid Object
(
[jq_colModel] => Array
(
[0] => Array
(
[autoResizable] => 1
[name] => id
[index] => id
[hidden] => 1
[headerTitle] => id
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
[number] => 1
)
)
[1] => Array
(
[autoResizable] => 1
[name] => Contact_Title
[index] => Contact_Title
[hidden] => 1
[headerTitle] => Contact_Title
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[2] => Array
(
[autoResizable] => 1
[name] => Contact_First
[index] => Contact_First
[hidden] =>
[headerTitle] => Contact_First
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[3] => Array
(
[autoResizable] => 1
[name] => Contact_Middle
[index] => Contact_Middle
[hidden] => 1
[headerTitle] => Contact_Middle
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[4] => Array
(
[autoResizable] => 1
[name] => Contact_Last
[index] => Contact_Last
[hidden] =>
[headerTitle] => Contact_Last
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[5] => Array
(
[autoResizable] => 1
[name] => Lead_Referral_Source
[index] => Lead_Referral_Source
[hidden] => 1
[headerTitle] => Lead_Referral_Source
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[6] => Array
(
[autoResizable] => 1
[name] => Date_of_Initial_Contact
[index] => Date_of_Initial_Contact
[hidden] => 1
[headerTitle] => Date_of_Initial_Contact
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[dataInit] => ###function(el){$(el).datepicker({
changeMonth: true, changeYear: true, yearRange: '-100:+0', dateFormat:'yy-mm-dd'},$.datepicker.regional['en']);}###
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
[date] => 1
)
)
[7] => Array
(
[autoResizable] => 1
[name] => Title
[index] => Title
[hidden] =>
[headerTitle] => Title
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[8] => Array
(
[autoResizable] => 1
[name] => Company
[index] => Company
[hidden] =>
[headerTitle] => Company
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[9] => Array
(
[autoResizable] => 1
[name] => Industry
[index] => Industry
[hidden] =>
[headerTitle] => Industry
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[10] => Array
(
[autoResizable] => 1
[name] => Address
[index] => Address
[hidden] => 1
[headerTitle] => Address
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[11] => Array
(
[autoResizable] => 1
[name] => Address_Street_1
[index] => Address_Street_1
[hidden] => 1
[headerTitle] => Address_Street_1
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[12] => Array
(
[autoResizable] => 1
[name] => Address_Street_2
[index] => Address_Street_2
[hidden] => 1
[headerTitle] => Address_Street_2
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[13] => Array
(
[autoResizable] => 1
[name] => Address_City
[index] => Address_City
[hidden] => 1
[headerTitle] => Address_City
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[14] => Array
(
[autoResizable] => 1
[name] => Address_State
[index] => Address_State
[hidden] => 1
[headerTitle] => Address_State
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[15] => Array
(
[autoResizable] => 1
[name] => Address_Zip
[index] => Address_Zip
[hidden] => 1
[headerTitle] => Address_Zip
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
[number] => 1
)
)
[16] => Array
(
[autoResizable] => 1
[name] => Address_Country
[index] => Address_Country
[hidden] => 1
[headerTitle] => Address_Country
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[17] => Array
(
[autoResizable] => 1
[name] => Phone
[index] => Phone
[hidden] =>
[headerTitle] => Phone
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[18] => Array
(
[autoResizable] => 1
[name] => Email
[index] => Email
[hidden] =>
[headerTitle] => Email
[edittype] => text
[editable] => 1
[formatter] => email
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[19] => Array
(
[autoResizable] => 1
[name] => Status
[index] => Status
[hidden] => 1
[headerTitle] => Status
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
[number] => 1
)
)
[20] => Array
(
[autoResizable] => 1
[name] => Website
[index] => Website
[hidden] =>
[headerTitle] => Website
[edittype] => text
[editable] => 1
[formatter] => link
[formatoptions] => Array
(
[target] => _new
)
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[21] => Array
(
[autoResizable] => 1
[name] => LinkedIn_Profile
[index] => LinkedIn_Profile
[hidden] => 1
[headerTitle] => LinkedIn_Profile
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[22] => Array
(
[autoResizable] => 1
[name] => Background_Info
[index] => Background_Info
[hidden] => 1
[headerTitle] => Background_Info
[edittype] => textarea
[editable] => 1
[editoptions] => Array
(
[cols] => 42
[rows] => 6
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[23] => Array
(
[autoResizable] => 1
[name] => Sales_Rep
[index] => Sales_Rep
[hidden] => 1
[headerTitle] => Sales_Rep
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
[number] => 1
)
)
[24] => Array
(
[autoResizable] => 1
[name] => Rating
[index] => Rating
[hidden] =>
[headerTitle] => Rating
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[25] => Array
(
[autoResizable] => 1
[name] => Project_Type
[index] => Project_Type
[hidden] =>
[headerTitle] => Project_Type
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[26] => Array
(
[autoResizable] => 1
[name] => Project_Description
[index] => Project_Description
[hidden] => 1
[headerTitle] => Project_Description
[edittype] => textarea
[editable] => 1
[editoptions] => Array
(
[cols] => 42
[rows] => 6
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
[27] => Array
(
[autoResizable] => 1
[name] => Proposal_Due_Date
[index] => Proposal_Due_Date
[hidden] => 1
[headerTitle] => Proposal_Due_Date
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[dataInit] => ###function(el){$(el).datepicker({
changeMonth: true, changeYear: true, yearRange: '-100:+0', dateFormat:'yy-mm-dd'},$.datepicker.regional['en']);}###
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
[date] => 1
)
)
[28] => Array
(
[autoResizable] => 1
[name] => Budget
[index] => Budget
[hidden] =>
[headerTitle] => Budget
[edittype] => text
[editable] => 1
[formatter] => currency
[formatoptions] => Array
(
[prefix] => $
[suffix] =>
[thousandsSeparator] => ,
[decimalSeparator] => .
[decimalPlaces] => 2
[defaultValue] => 0.00
)
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[29] => Array
(
[autoResizable] => 1
[name] => Deliverables
[index] => Deliverables
[hidden] => 1
[headerTitle] => Deliverables
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] => 1
[required] =>
)
)
)
[before_script_end] =>
[sql:phpGrid\C_DataGrid:private] => SELECT * FROM contact
[sql_table:phpGrid\C_DataGrid:private] => contact
[sql_key:phpGrid\C_DataGrid:private] => Array
(
[0] => id
)
[sql_fkey:phpGrid\C_DataGrid:private] =>
[sql_mfkey:phpGrid\C_DataGrid:private] =>
[col_dbnames:phpGrid\C_DataGrid:private] => Array
(
)
[col_hiddens:phpGrid\C_DataGrid:private] => Array
(
[id] => Array
(
[edithidden] => 1
)
[Status] => Array
(
[edithidden] => 1
)
[Date_of_Initial_Contact] => Array
(
[edithidden] => 1
)
[Contact_Title] => Array
(
[edithidden] => 1
)
[Contact_Middle] => Array
(
[edithidden] => 1
)
[Lead_Referral_Source] => Array
(
[edithidden] => 1
)
[Address] => Array
(
[edithidden] => 1
)
[Address_Street_1] => Array
(
[edithidden] => 1
)
[Address_Street_2] => Array
(
[edithidden] => 1
)
[Address_City] => Array
(
[edithidden] => 1
)
[Address_State] => Array
(
[edithidden] => 1
)
[Address_Zip] => Array
(
[edithidden] => 1
)
[Address_Country] => Array
(
[edithidden] => 1
)
[LinkedIn_Profile] => Array
(
[edithidden] => 1
)
[Background_Info] => Array
(
[edithidden] => 1
)
[Sales_Rep] => Array
(
[edithidden] => 1
)
[Project_Description] => Array
(
[edithidden] => 1
)
[Proposal_Due_Date] => Array
(
[edithidden] => 1
)
[Deliverables] => Array
(
[edithidden] => 1
)
)
[col_titles:phpGrid\C_DataGrid:private] => Array
(
)
[col_readonly:phpGrid\C_DataGrid:private] => Array
(
)
[col_required:phpGrid\C_DataGrid:private] => Array
(
)
[col_links:phpGrid\C_DataGrid:private] => Array
(
)
[col_dynalinks:phpGrid\C_DataGrid:private] => Array
(
)
[col_edittypes:phpGrid\C_DataGrid:private] => Array
(
)
[col_datatypes:phpGrid\C_DataGrid:private] =>
[col_imgs:phpGrid\C_DataGrid:private] => Array
(
)
[col_custom:phpGrid\C_DataGrid:private] =>
[col_custom_css:phpGrid\C_DataGrid:private] =>
[col_wysiwyg:phpGrid\C_DataGrid:private] => Array
(
)
[col_default:phpGrid\C_DataGrid:private] => Array
(
)
[col_frozen:phpGrid\C_DataGrid:private] => Array
(
)
[col_widths:phpGrid\C_DataGrid:private] => Array
(
)
[col_aligns:phpGrid\C_DataGrid:private] => Array
(
)
[col_edit_dimension:phpGrid\C_DataGrid:private] => Array
(
)
[col_fileupload:phpGrid\C_DataGrid:private] => Array
(
)
[col_virtual:phpGrid\C_DataGrid:private] => Array
(
)
[col_customrule:phpGrid\C_DataGrid:private] => Array
(
)
[col_autocomplete:phpGrid\C_DataGrid:private] => Array
(
)
[col_nested_dd:phpGrid\C_DataGrid:private] => Array
(
)
[col_headerTitles:phpGrid\C_DataGrid:private] => Array
(
)
[sql_filter:phpGrid\C_DataGrid:private] => Status = 2 && sales_rep = 1
[jq_summary_col_name:phpGrid\C_DataGrid:private] => Array
(
)
[jq_summary_type:phpGrid\C_DataGrid:private] =>
[jq_showSummaryOnHide:phpGrid\C_DataGrid:private] =>
[jq_gridName:phpGrid\C_DataGrid:private] => contact
[jq_url:phpGrid\C_DataGrid:private] => "/phpGrid/data.php?dt=json&gn=contact"
[jq_datatype:phpGrid\C_DataGrid:private] => json
[jq_mtype:phpGrid\C_DataGrid:private] => GET
[jq_colNames:phpGrid\C_DataGrid:private] => Array
(
[0] => id
[1] => Contact Title
[2] => Contact First
[3] => Contact Middle
[4] => Contact Last
[5] => Lead Referral Source
[6] => Date of Initial Contact
[7] => Title
[8] => Company
[9] => Industry
[10] => Address
[11] => Address Street 1
[12] => Address Street 2
[13] => Address City
[14] => Address State
[15] => Address Zip
[16] => Address Country
[17] => Phone
[18] => Email
[19] => Status
[20] => Website
[21] => LinkedIn Profile
[22] => Background Info
[23] => Sales Rep
[24] => Rating
[25] => Project Type
[26] => Project Description
[27] => Proposal Due Date
[28] => Budget
[29] => Deliverables
)
[jq_pagerName:phpGrid\C_DataGrid:private] => "#contact_pager1"
[jq_rowNum:phpGrid\C_DataGrid:private] => 25
[jq_rowList:phpGrid\C_DataGrid:private] => Array
(
[0] => 10
[1] => 25
[2] => 50
[3] => 100
[4] => 200
[5] => 500
[6] => 10000:All
)
[jq_sortname:phpGrid\C_DataGrid:private] => 1
[jq_sortorder:phpGrid\C_DataGrid:private] => asc
[jq_viewrecords:phpGrid\C_DataGrid:private] => 1
[jq_pgtext:phpGrid\C_DataGrid:private] => Page {0} of {1}
[jq_multiselect:phpGrid\C_DataGrid:private] =>
[jq_multipage:phpGrid\C_DataGrid:private] => 1
[jq_multiselectPosition:phpGrid\C_DataGrid:private] => right
[jq_autowidth:phpGrid\C_DataGrid:private] =>
[jq_width:phpGrid\C_DataGrid:private] => auto
[jq_height:phpGrid\C_DataGrid:private] => auto
[jq_grouping:phpGrid\C_DataGrid:private] =>
[jq_group_name:phpGrid\C_DataGrid:private] =>
[jq_group_summary_show:phpGrid\C_DataGrid:private] =>
[jq_direction:phpGrid\C_DataGrid:private] => ltr
[jq_groupcollapse:phpGrid\C_DataGrid:private] => false
[jq_caption:phpGrid\C_DataGrid:private] => Contact
[jq_cellEdit:phpGrid\C_DataGrid:private] =>
[jq_altRows:phpGrid\C_DataGrid:private] => 1
[jq_scrollOffset:phpGrid\C_DataGrid:private] => 0
[jq_editurl:phpGrid\C_DataGrid:private] => /phpGrid/edit.php?dt=json&gn=contact
[jq_rownumbers:phpGrid\C_DataGrid:private] =>
[jq_forceFit:phpGrid\C_DataGrid:private] =>
[jq_loadtext:phpGrid\C_DataGrid:private] => Loading phpGrid ...
[jq_scroll:phpGrid\C_DataGrid:private] =>
[jq_hiddengrid:phpGrid\C_DataGrid:private] =>
[jq_gridview:phpGrid\C_DataGrid:private] =>
[jq_autoresizeOnLoad:phpGrid\C_DataGrid:private] => 1
[jqu_resize:phpGrid\C_DataGrid:private] => Array
(
[is_resizable] =>
[min_width] => 300
[min_height] => 100
)
[_num_rows:phpGrid\C_DataGrid:private] => 0
[_num_fields:phpGrid\C_DataGrid:private] => 30
[_ver_num:phpGrid\C_DataGrid:private] => phpGrid(v7.4.6) {free-jqGrid:v4.14.1, jQuery:v3.3.1, jQuery UI:1.11.2}
[form_width:phpGrid\C_DataGrid:private] => 580
[form_height:phpGrid\C_DataGrid:private] => 100%
[edit_mode:phpGrid\C_DataGrid:private] => FORM
[edit_options:phpGrid\C_DataGrid:private] => CRUD
[has_tbarsearch:phpGrid\C_DataGrid:private] =>
[auto_filters:phpGrid\C_DataGrid:private] => Array
(
)
[advanced_search:phpGrid\C_DataGrid:private] =>
[sys_msg:phpGrid\C_DataGrid:private] =>
[alt_colors:phpGrid\C_DataGrid:private] => Array
(
[hover] => #F2FC9C
[highlight] =>
[altrow] => #F5FAFF
)
[theme_name:phpGrid\C_DataGrid:private] => bootstrap
[locale:phpGrid\C_DataGrid:private] => en
[auto_resize:phpGrid\C_DataGrid:private] =>
[kb_nav:phpGrid\C_DataGrid:private] =>
[pivotoptions:phpGrid\C_DataGrid:private] => Array
(
)
[dnd_grouping:phpGrid\C_DataGrid:private] =>
[persist_state:phpGrid\C_DataGrid:private] =>
[can_copyrow:phpGrid\C_DataGrid:private] =>
[export_type] =>
[export_url] => /phpGrid/export.php?dt=json&gn=contact
[pdf_logo] => Array
(
)
[debug] => 1
[db] => phpGrid\C_Database Object
(
[hostName] => localhost
[userName] => ghundihi_echo
[password] => Backspace@0987654321!
[databaseName] => ghundihi_crm
[tableName] =>
[link] =>
[dbType] => mysql
[charset] => utf8
[dbOptions] => contact
[db] => ADODB_mysqli Object
(
[databaseType] => mysqli
[dataProvider] => mysql
[hasInsertID] => 1
[hasAffectedRows] => 1
[metaTablesSQL] => SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=
[metaColumnsSQL] => SHOW COLUMNS FROM `%s`
[fmtTimeStamp] => 'Y-m-d H:i:s'
[hasLimit] => 1
[hasMoveFirst] => 1
[hasGenID] => 1
[isoDates] => 1
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[hasTransactions] => 1
[forceNewConnect] =>
[poorAffectedRows] => 1
[clientFlags] => 0
[substr] => substring
[port] => 3306
[socket] =>
[_bindInputArray] =>
[nameQuote] => `
[optionFlags] => Array
(
[0] => Array
(
[0] => 5
[1] => 0
)
)
[arrayClass] => ADORecordSet_array_mysqli
[multiQuery] =>
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table if not exists %s (id int not null)
[_genSeqCountSQL] => select count(*) from %s
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table if exists %s
[database] => ghundihi_crm
[host] => localhost
[user] => ghundihi_echo
[password] => not stored
[debug] =>
[maxblobsize] => 262144
[concat_operator] => +
[length] => length
[random] => rand()
[upperCase] => upper
[fmtDate] => 'Y-m-d'
[true] => 1
[false] => 0
[replaceQuote] => \'
[charSet] =>
[metaDatabasesSQL] =>
[uniqueOrderBy] =>
[emptyDate] =>
[emptyTimeStamp] =>
[lastInsID] =>
[hasTop] =>
[readOnly] =>
[genID] => 0
[raiseErrorFn] =>
[cacheSecs] => 3600
[memCache] =>
[memCacheHost] =>
[memCachePort] => 11211
[memCacheCompress] =>
[sysUTimeStamp] =>
[noNullStrings] =>
[numCacheHits] => 0
[numCacheMisses] => 0
[pageExecuteCountRows] => 1
[uniqueSort] =>
[leftOuter] =>
[rightOuter] =>
[ansiOuter] =>
[autoRollback] =>
[fnExecute] =>
[fnCacheExecute] =>
[blobEncodeType] =>
[rsPrefix] => ADORecordSet_
[autoCommit] => 1
[transOff] => 0
[transCnt] => 0
[fetchMode] => 3
[null2null] => null
[bulkBind] =>
[_oldRaiseFn] =>
[_transOK] =>
[_connectionID] => mysqli Object
(
[affected_rows] => 1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 30
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.11.15-MariaDB
[server_version] => 101115
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 2788421
[warning_count] => 0
)
[_errorMsg] =>
[_errorCode] =>
[_queryID] => mysqli_result Object
(
[current_field] => 30
[field_count] => 30
[lengths] => Array
(
[0] => 1
[1] => 0
[2] => 4
[3] => 0
[4] => 5
[5] => 23
[6] => 10
[7] => 9
[8] => 10
[9] => 4
[10] => 36
[11] => 13
[12] => 0
[13] => 12
[14] => 2
[15] => 5
[16] => 0
[17] => 14
[18] => 12
[19] => 1
[20] => 11
[21] => 14
[22] => 15
[23] => 1
[24] => 4
[25] => 0
[26] => 0
[27] => 0
[28] => 0
[29] => 0
)
[num_rows] => 1
[type] => 0
)
[_isPersistentConnection] =>
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[connectionParameters:protected] => Array
(
)
[databaseName] => ghundihi_crm
)
[result] => ADORecordSet_mysqli Object
(
[databaseType] => mysqli
[canSeek] => 1
[dataProvider] => native
[fields] => Array
(
[0] => 2
[id] => 2
[1] =>
[Contact_Title] =>
[2] => Dave
[Contact_First] => Dave
[3] =>
[Contact_Middle] =>
[4] => Myers
[Contact_Last] => Myers
[5] => Mack Truck Partner Site
[Lead_Referral_Source] => Mack Truck Partner Site
[6] => 2014-02-11
[Date_of_Initial_Contact] => 2014-02-11
[7] => DEF Sales
[Title] => DEF Sales
[8] => DEF Fluids
[Company] => DEF Fluids
[9] => Auto
[Industry] => Auto
[10] => 456 Diesel St Philadelphia, PA 19308
[Address] => 456 Diesel St Philadelphia, PA 19308
[11] => 456 Diesel St
[Address_Street_1] => 456 Diesel St
[12] =>
[Address_Street_2] =>
[13] => Philadelphia
[Address_City] => Philadelphia
[14] => PA
[Address_State] => PA
[15] => 19308
[Address_Zip] => 19308
[16] =>
[Address_Country] =>
[17] => (765) 765-7755
[Phone] => (765) 765-7755
[18] => dave@def.com
[Email] => dave@def.com
[19] => 2
[Status] => 2
[20] => www.def.com
[Website] => www.def.com
[21] => www.sample.com
[LinkedIn_Profile] => www.sample.com
[22] => 19 years in biz
[Background_Info] => 19 years in biz
[23] => 2
[Sales_Rep] => 2
[24] => 2.50
[Rating] => 2.50
[25] =>
[Project_Type] =>
[26] =>
[Project_Description] =>
[27] =>
[Proposal_Due_Date] =>
[28] =>
[Budget] =>
[29] =>
[Deliverables] =>
)
[blobSize] => 100
[sql] => SELECT * FROM contact LIMIT 1,1
[EOF] =>
[emptyTimeStamp] =>
[emptyDate] =>
[debug] =>
[timeCreated] => 0
[bind] =>
[fetchMode] => 3
[connection] => ADODB_mysqli Object
(
[databaseType] => mysqli
[dataProvider] => mysql
[hasInsertID] => 1
[hasAffectedRows] => 1
[metaTablesSQL] => SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=
[metaColumnsSQL] => SHOW COLUMNS FROM `%s`
[fmtTimeStamp] => 'Y-m-d H:i:s'
[hasLimit] => 1
[hasMoveFirst] => 1
[hasGenID] => 1
[isoDates] => 1
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[hasTransactions] => 1
[forceNewConnect] =>
[poorAffectedRows] => 1
[clientFlags] => 0
[substr] => substring
[port] => 3306
[socket] =>
[_bindInputArray] =>
[nameQuote] => `
[optionFlags] => Array
(
[0] => Array
(
[0] => 5
[1] => 0
)
)
[arrayClass] => ADORecordSet_array_mysqli
[multiQuery] =>
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table if not exists %s (id int not null)
[_genSeqCountSQL] => select count(*) from %s
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table if exists %s
[database] => ghundihi_crm
[host] => localhost
[user] => ghundihi_echo
[password] => not stored
[debug] =>
[maxblobsize] => 262144
[concat_operator] => +
[length] => length
[random] => rand()
[upperCase] => upper
[fmtDate] => 'Y-m-d'
[true] => 1
[false] => 0
[replaceQuote] => \'
[charSet] =>
[metaDatabasesSQL] =>
[uniqueOrderBy] =>
[emptyDate] =>
[emptyTimeStamp] =>
[lastInsID] =>
[hasTop] =>
[readOnly] =>
[genID] => 0
[raiseErrorFn] =>
[cacheSecs] => 3600
[memCache] =>
[memCacheHost] =>
[memCachePort] => 11211
[memCacheCompress] =>
[sysUTimeStamp] =>
[noNullStrings] =>
[numCacheHits] => 0
[numCacheMisses] => 0
[pageExecuteCountRows] => 1
[uniqueSort] =>
[leftOuter] =>
[rightOuter] =>
[ansiOuter] =>
[autoRollback] =>
[fnExecute] =>
[fnCacheExecute] =>
[blobEncodeType] =>
[rsPrefix] => ADORecordSet_
[autoCommit] => 1
[transOff] => 0
[transCnt] => 0
[fetchMode] => 3
[null2null] => null
[bulkBind] =>
[_oldRaiseFn] =>
[_transOK] =>
[_connectionID] => mysqli Object
(
[affected_rows] => 1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 30
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.11.15-MariaDB
[server_version] => 101115
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 2788421
[warning_count] => 0
)
[_errorMsg] =>
[_errorCode] =>
[_queryID] => mysqli_result Object
(
[current_field] => 30
[field_count] => 30
[lengths] => Array
(
[0] => 1
[1] => 0
[2] => 4
[3] => 0
[4] => 5
[5] => 23
[6] => 10
[7] => 9
[8] => 10
[9] => 4
[10] => 36
[11] => 13
[12] => 0
[13] => 12
[14] => 2
[15] => 5
[16] => 0
[17] => 14
[18] => 12
[19] => 1
[20] => 11
[21] => 14
[22] => 15
[23] => 1
[24] => 4
[25] => 0
[26] => 0
[27] => 0
[28] => 0
[29] => 0
)
[num_rows] => 1
[type] => 0
)
[_isPersistentConnection] =>
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[connectionParameters:protected] => Array
(
)
[databaseName] => ghundihi_crm
)
[_numOfRows] => 1
[_numOfFields] => 30
[_queryID] => mysqli_result Object
(
[current_field] => 30
[field_count] => 30
[lengths] => Array
(
[0] => 1
[1] => 0
[2] => 4
[3] => 0
[4] => 5
[5] => 23
[6] => 10
[7] => 9
[8] => 10
[9] => 4
[10] => 36
[11] => 13
[12] => 0
[13] => 12
[14] => 2
[15] => 5
[16] => 0
[17] => 14
[18] => 12
[19] => 1
[20] => 11
[21] => 14
[22] => 15
[23] => 1
[24] => 4
[25] => 0
[26] => 0
[27] => 0
[28] => 0
[29] => 0
)
[num_rows] => 1
[type] => 0
)
[_currentRow] => 0
[_closed] =>
[_inited] => 1
[_obj] =>
[_names] =>
[_currentPage] => -1
[_atFirstPage] =>
[_atLastPage] =>
[_lastPageNo] => -1
[_maxRecordCount] => 0
[datetime] =>
[adodbFetchMode] => 3
)
[session] => phpGrid\C_GridSession Object
(
)
)
[db_connection] => Array
(
)
[obj_subgrid] => Array
(
[0] => phpGrid\C_DataGrid Object
(
[jq_colModel] => Array
(
[0] => Array
(
[autoResizable] => 1
[name] => id
[index] => id
[hidden] => 1
[headerTitle] => id
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[1] => Array
(
[autoResizable] => 1
[name] => Date
[index] => Date
[hidden] =>
[headerTitle] => Date
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[dataInit] => ###function(el){$(el).datepicker({
changeMonth: true, changeYear: true, yearRange: '-100:+0', dateFormat:'yy-mm-dd'},$.datepicker.regional['en']);}###
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[date] => 1
)
)
[2] => Array
(
[autoResizable] => 1
[name] => Notes
[index] => Notes
[hidden] =>
[headerTitle] => Notes
[edittype] => textarea
[editable] => 1
[editoptions] => Array
(
[cols] => 42
[rows] => 6
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[3] => Array
(
[autoResizable] => 1
[name] => Is_New_Todo
[index] => Is_New_Todo
[hidden] =>
[headerTitle] => Is_New_Todo
[edittype] => select
[editable] => 1
[formatter] => select
[stype] => select
[searchoptions] => Array
(
[sopt] => Array
(
[0] => eq
)
[value] => :All;0:No;1:Yes
)
[editoptions] => Array
(
[value] => 0:No;1:Yes
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[4] => Array
(
[autoResizable] => 1
[name] => Todo_Type_ID
[index] => Todo_Type_ID
[hidden] =>
[headerTitle] => Todo_Type_ID
[edittype] => select
[editable] => 1
[formatter] => select
[stype] => select
[searchoptions] => Array
(
[sopt] => Array
(
[0] => eq
)
[value] => :All;null:;1:task;2:meeting
)
[editoptions] => Array
(
[value] => null:;1:task;2:meeting
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[5] => Array
(
[autoResizable] => 1
[name] => Todo_Desc_ID
[index] => Todo_Desc_ID
[hidden] =>
[headerTitle] => Todo_Desc_ID
[edittype] => select
[editable] => 1
[formatter] => select
[stype] => select
[searchoptions] => Array
(
[sopt] => Array
(
[0] => eq
)
[value] => :All;null:;1:Follow Up Email;2:Phone Call;3:Lunch Meeting;4:Tech Demo;5:Meetup;6:Conference;7:Others
)
[editoptions] => Array
(
[value] => null:;1:Follow Up Email;2:Phone Call;3:Lunch Meeting;4:Tech Demo;5:Meetup;6:Conference;7:Others
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[6] => Array
(
[autoResizable] => 1
[name] => Todo_Due_Date
[index] => Todo_Due_Date
[hidden] =>
[headerTitle] => Todo_Due_Date
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[7] => Array
(
[autoResizable] => 1
[name] => Contact
[index] => Contact
[hidden] => 1
[headerTitle] => Contact
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[8] => Array
(
[autoResizable] => 1
[name] => Task_Status
[index] => Task_Status
[hidden] =>
[headerTitle] => Task_Status
[edittype] => select
[editable] => 1
[formatter] => select
[stype] => select
[searchoptions] => Array
(
[sopt] => Array
(
[0] => eq
)
[value] => :All;null:;1:pending;2:completed
)
[editoptions] => Array
(
[value] => null:;1:pending;2:completed
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[9] => Array
(
[autoResizable] => 1
[name] => Task_Update
[index] => Task_Update
[hidden] =>
[headerTitle] => Task_Update
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[10] => Array
(
[autoResizable] => 1
[name] => Sales_Rep
[index] => Sales_Rep
[hidden] => 1
[headerTitle] => Sales_Rep
[edittype] => text
[editable] => 1
[editoptions] => Array
(
[size] => 30
[defaultValue] => 1
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
)
[before_script_end] =>
[sql:phpGrid\C_DataGrid:private] => SELECT * FROM notes
[sql_table:phpGrid\C_DataGrid:private] => notes
[sql_key:phpGrid\C_DataGrid:private] => Array
(
[0] => id
)
[sql_fkey:phpGrid\C_DataGrid:private] => Contact
[sql_mfkey:phpGrid\C_DataGrid:private] =>
[col_dbnames:phpGrid\C_DataGrid:private] => Array
(
)
[col_hiddens:phpGrid\C_DataGrid:private] => Array
(
[id] => Array
(
[edithidden] =>
)
[Contact] => Array
(
[edithidden] =>
)
[Sales_Rep] => Array
(
[edithidden] =>
)
)
[col_titles:phpGrid\C_DataGrid:private] => Array
(
)
[col_readonly:phpGrid\C_DataGrid:private] => Array
(
)
[col_required:phpGrid\C_DataGrid:private] => Array
(
)
[col_links:phpGrid\C_DataGrid:private] => Array
(
)
[col_dynalinks:phpGrid\C_DataGrid:private] => Array
(
)
[col_edittypes:phpGrid\C_DataGrid:private] => Array
(
[Add_Task_or_Meeting] => Array
(
[multiple] =>
[dataUrl] =>
[type] => select
[value] => null:;1:pending;2:completed
)
[Task_Status] => Array
(
[multiple] =>
[dataUrl] =>
[type] => select
[value] => null:;1:pending;2:completed
)
[Is_New_Todo] => Array
(
[multiple] =>
[dataUrl] =>
[type] => select
[value] => 0:No;1:Yes
)
[Todo_Type_ID] => Array
(
[multiple] =>
[dataUrl] =>
[type] => select
[value] => null:;1:task;2:meeting
)
[Todo_Desc_ID] => Array
(
[multiple] =>
[dataUrl] =>
[type] => select
[value] => null:;1:Follow Up Email;2:Phone Call;3:Lunch Meeting;4:Tech Demo;5:Meetup;6:Conference;7:Others
)
)
[col_datatypes:phpGrid\C_DataGrid:private] =>
[col_imgs:phpGrid\C_DataGrid:private] => Array
(
)
[col_custom:phpGrid\C_DataGrid:private] =>
[col_custom_css:phpGrid\C_DataGrid:private] =>
[col_wysiwyg:phpGrid\C_DataGrid:private] => Array
(
)
[col_default:phpGrid\C_DataGrid:private] => Array
(
[Sales_Rep] => 1
)
[col_frozen:phpGrid\C_DataGrid:private] => Array
(
)
[col_widths:phpGrid\C_DataGrid:private] => Array
(
)
[col_aligns:phpGrid\C_DataGrid:private] => Array
(
)
[col_edit_dimension:phpGrid\C_DataGrid:private] => Array
(
)
[col_fileupload:phpGrid\C_DataGrid:private] => Array
(
)
[col_virtual:phpGrid\C_DataGrid:private] => Array
(
)
[col_customrule:phpGrid\C_DataGrid:private] => Array
(
)
[col_autocomplete:phpGrid\C_DataGrid:private] => Array
(
)
[col_nested_dd:phpGrid\C_DataGrid:private] => Array
(
)
[col_headerTitles:phpGrid\C_DataGrid:private] => Array
(
)
[sql_filter:phpGrid\C_DataGrid:private] => Sales_Rep = 1
[jq_summary_col_name:phpGrid\C_DataGrid:private] => Array
(
)
[jq_summary_type:phpGrid\C_DataGrid:private] =>
[jq_showSummaryOnHide:phpGrid\C_DataGrid:private] =>
[jq_gridName:phpGrid\C_DataGrid:private] => notes
[jq_url:phpGrid\C_DataGrid:private] => "/phpGrid/subgrid.php?dt=json&gn=contact&sgn=notes&m_fkey=id&_rowid="+row_id1
[jq_datatype:phpGrid\C_DataGrid:private] => json
[jq_mtype:phpGrid\C_DataGrid:private] => GET
[jq_colNames:phpGrid\C_DataGrid:private] => Array
(
[0] => id
[1] => Date
[2] => Notes
[3] => Is New Todo
[4] => Todo Type ID
[5] => Todo Desc ID
[6] => Todo Due Date
[7] => Contact
[8] => Task Status
[9] => Task Update
[10] => Sales Rep
)
[jq_pagerName:phpGrid\C_DataGrid:private] => pager_id1_s0
[jq_rowNum:phpGrid\C_DataGrid:private] => 25
[jq_rowList:phpGrid\C_DataGrid:private] => Array
(
[0] => 10
[1] => 25
[2] => 50
[3] => 100
[4] => 200
[5] => 500
[6] => 10000:All
)
[jq_sortname:phpGrid\C_DataGrid:private] => 1
[jq_sortorder:phpGrid\C_DataGrid:private] => asc
[jq_viewrecords:phpGrid\C_DataGrid:private] => 1
[jq_pgtext:phpGrid\C_DataGrid:private] => Page {0} of {1}
[jq_multiselect:phpGrid\C_DataGrid:private] => 1
[jq_multipage:phpGrid\C_DataGrid:private] => 1
[jq_multiselectPosition:phpGrid\C_DataGrid:private] => left
[jq_autowidth:phpGrid\C_DataGrid:private] => 1
[jq_width:phpGrid\C_DataGrid:private] => auto
[jq_height:phpGrid\C_DataGrid:private] => 100%
[jq_grouping:phpGrid\C_DataGrid:private] =>
[jq_group_name:phpGrid\C_DataGrid:private] =>
[jq_group_summary_show:phpGrid\C_DataGrid:private] =>
[jq_direction:phpGrid\C_DataGrid:private] => ltr
[jq_groupcollapse:phpGrid\C_DataGrid:private] => false
[jq_caption:phpGrid\C_DataGrid:private] =>
[jq_cellEdit:phpGrid\C_DataGrid:private] =>
[jq_altRows:phpGrid\C_DataGrid:private] => 1
[jq_scrollOffset:phpGrid\C_DataGrid:private] => 0
[jq_editurl:phpGrid\C_DataGrid:private] => /phpGrid/edit.php?dt=json&gn=notes&src=sg&fkey=id&fkey_value="+fkey_value+"
[jq_rownumbers:phpGrid\C_DataGrid:private] =>
[jq_forceFit:phpGrid\C_DataGrid:private] =>
[jq_loadtext:phpGrid\C_DataGrid:private] => Loading phpGrid ...
[jq_scroll:phpGrid\C_DataGrid:private] =>
[jq_hiddengrid:phpGrid\C_DataGrid:private] =>
[jq_gridview:phpGrid\C_DataGrid:private] => 1
[jq_autoresizeOnLoad:phpGrid\C_DataGrid:private] =>
[jqu_resize:phpGrid\C_DataGrid:private] => Array
(
[is_resizable] =>
[min_width] => 300
[min_height] => 100
)
[_num_rows:phpGrid\C_DataGrid:private] => 0
[_num_fields:phpGrid\C_DataGrid:private] => 11
[_ver_num:phpGrid\C_DataGrid:private] => phpGrid(v7.4.6) {free-jqGrid:v4.14.1, jQuery:v3.3.1, jQuery UI:1.11.2}
[form_width:phpGrid\C_DataGrid:private] => 580
[form_height:phpGrid\C_DataGrid:private] => 100%
[edit_mode:phpGrid\C_DataGrid:private] => FORM
[edit_options:phpGrid\C_DataGrid:private] => CRUD
[has_tbarsearch:phpGrid\C_DataGrid:private] =>
[auto_filters:phpGrid\C_DataGrid:private] => Array
(
)
[advanced_search:phpGrid\C_DataGrid:private] =>
[sys_msg:phpGrid\C_DataGrid:private] =>
[alt_colors:phpGrid\C_DataGrid:private] => Array
(
[hover] => #F2FC9C
[highlight] =>
[altrow] => #F5FAFF
)
[theme_name:phpGrid\C_DataGrid:private] => bootstrap
[locale:phpGrid\C_DataGrid:private] => en
[auto_resize:phpGrid\C_DataGrid:private] =>
[kb_nav:phpGrid\C_DataGrid:private] =>
[pivotoptions:phpGrid\C_DataGrid:private] => Array
(
)
[dnd_grouping:phpGrid\C_DataGrid:private] =>
[persist_state:phpGrid\C_DataGrid:private] =>
[can_copyrow:phpGrid\C_DataGrid:private] =>
[export_type] =>
[export_url] => /phpGrid/export.php?dt=json&gn=notes
[pdf_logo] => Array
(
)
[debug] => 1
[db] => phpGrid\C_Database Object
(
[hostName] => localhost
[userName] => ghundihi_echo
[password] => Backspace@0987654321!
[databaseName] => ghundihi_crm
[tableName] =>
[link] =>
[dbType] => mysql
[charset] => utf8
[dbOptions] => notes
[db] => ADODB_mysqli Object
(
[databaseType] => mysqli
[dataProvider] => mysql
[hasInsertID] => 1
[hasAffectedRows] => 1
[metaTablesSQL] => SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=
[metaColumnsSQL] => SHOW COLUMNS FROM `%s`
[fmtTimeStamp] => 'Y-m-d H:i:s'
[hasLimit] => 1
[hasMoveFirst] => 1
[hasGenID] => 1
[isoDates] => 1
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[hasTransactions] => 1
[forceNewConnect] =>
[poorAffectedRows] => 1
[clientFlags] => 0
[substr] => substring
[port] => 3306
[socket] =>
[_bindInputArray] =>
[nameQuote] => `
[optionFlags] => Array
(
[0] => Array
(
[0] => 5
[1] => 0
)
)
[arrayClass] => ADORecordSet_array_mysqli
[multiQuery] =>
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table if not exists %s (id int not null)
[_genSeqCountSQL] => select count(*) from %s
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table if exists %s
[database] => ghundihi_crm
[host] => localhost
[user] => ghundihi_echo
[password] => not stored
[debug] =>
[maxblobsize] => 262144
[concat_operator] => +
[length] => length
[random] => rand()
[upperCase] => upper
[fmtDate] => 'Y-m-d'
[true] => 1
[false] => 0
[replaceQuote] => \'
[charSet] =>
[metaDatabasesSQL] =>
[uniqueOrderBy] =>
[emptyDate] =>
[emptyTimeStamp] =>
[lastInsID] =>
[hasTop] =>
[readOnly] =>
[genID] => 0
[raiseErrorFn] =>
[cacheSecs] => 3600
[memCache] =>
[memCacheHost] =>
[memCachePort] => 11211
[memCacheCompress] =>
[sysUTimeStamp] =>
[noNullStrings] =>
[numCacheHits] => 0
[numCacheMisses] => 0
[pageExecuteCountRows] => 1
[uniqueSort] =>
[leftOuter] =>
[rightOuter] =>
[ansiOuter] =>
[autoRollback] =>
[fnExecute] =>
[fnCacheExecute] =>
[blobEncodeType] =>
[rsPrefix] => ADORecordSet_
[autoCommit] => 1
[transOff] => 0
[transCnt] => 0
[fetchMode] => 3
[null2null] => null
[bulkBind] =>
[_oldRaiseFn] =>
[_transOK] =>
[_connectionID] => mysqli Object
(
[affected_rows] => 1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 11
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.11.15-MariaDB
[server_version] => 101115
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 2788422
[warning_count] => 0
)
[_errorMsg] =>
[_errorCode] =>
[_queryID] => mysqli_result Object
(
[current_field] => 11
[field_count] => 11
[lengths] => Array
(
[0] => 1
[1] => 10
[2] => 11
[3] => 1
[4] => 1
[5] => 1
[6] => 0
[7] => 1
[8] => 1
[9] => 0
[10] => 1
)
[num_rows] => 1
[type] => 0
)
[_isPersistentConnection] =>
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[connectionParameters:protected] => Array
(
)
[databaseName] => ghundihi_crm
)
[result] => ADORecordSet_mysqli Object
(
[databaseType] => mysqli
[canSeek] => 1
[dataProvider] => native
[fields] => Array
(
[0] => 2
[id] => 2
[1] => 2015-10-10
[Date] => 2015-10-10
[2] => Sample Note
[Notes] => Sample Note
[3] => 0
[Is_New_Todo] => 0
[4] => 1
[Todo_Type_ID] => 1
[5] => 1
[Todo_Desc_ID] => 1
[6] =>
[Todo_Due_Date] =>
[7] => 2
[Contact] => 2
[8] => 1
[Task_Status] => 1
[9] =>
[Task_Update] =>
[10] => 2
[Sales_Rep] => 2
)
[blobSize] => 100
[sql] => SELECT * FROM notes LIMIT 1,1
[EOF] =>
[emptyTimeStamp] =>
[emptyDate] =>
[debug] =>
[timeCreated] => 0
[bind] =>
[fetchMode] => 3
[connection] => ADODB_mysqli Object
(
[databaseType] => mysqli
[dataProvider] => mysql
[hasInsertID] => 1
[hasAffectedRows] => 1
[metaTablesSQL] => SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=
[metaColumnsSQL] => SHOW COLUMNS FROM `%s`
[fmtTimeStamp] => 'Y-m-d H:i:s'
[hasLimit] => 1
[hasMoveFirst] => 1
[hasGenID] => 1
[isoDates] => 1
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[hasTransactions] => 1
[forceNewConnect] =>
[poorAffectedRows] => 1
[clientFlags] => 0
[substr] => substring
[port] => 3306
[socket] =>
[_bindInputArray] =>
[nameQuote] => `
[optionFlags] => Array
(
[0] => Array
(
[0] => 5
[1] => 0
)
)
[arrayClass] => ADORecordSet_array_mysqli
[multiQuery] =>
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table if not exists %s (id int not null)
[_genSeqCountSQL] => select count(*) from %s
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table if exists %s
[database] => ghundihi_crm
[host] => localhost
[user] => ghundihi_echo
[password] => not stored
[debug] =>
[maxblobsize] => 262144
[concat_operator] => +
[length] => length
[random] => rand()
[upperCase] => upper
[fmtDate] => 'Y-m-d'
[true] => 1
[false] => 0
[replaceQuote] => \'
[charSet] =>
[metaDatabasesSQL] =>
[uniqueOrderBy] =>
[emptyDate] =>
[emptyTimeStamp] =>
[lastInsID] =>
[hasTop] =>
[readOnly] =>
[genID] => 0
[raiseErrorFn] =>
[cacheSecs] => 3600
[memCache] =>
[memCacheHost] =>
[memCachePort] => 11211
[memCacheCompress] =>
[sysUTimeStamp] =>
[noNullStrings] =>
[numCacheHits] => 0
[numCacheMisses] => 0
[pageExecuteCountRows] => 1
[uniqueSort] =>
[leftOuter] =>
[rightOuter] =>
[ansiOuter] =>
[autoRollback] =>
[fnExecute] =>
[fnCacheExecute] =>
[blobEncodeType] =>
[rsPrefix] => ADORecordSet_
[autoCommit] => 1
[transOff] => 0
[transCnt] => 0
[fetchMode] => 3
[null2null] => null
[bulkBind] =>
[_oldRaiseFn] =>
[_transOK] =>
[_connectionID] => mysqli Object
(
[affected_rows] => 1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 11
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.11.15-MariaDB
[server_version] => 101115
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 2788422
[warning_count] => 0
)
[_errorMsg] =>
[_errorCode] =>
[_queryID] => mysqli_result Object
(
[current_field] => 11
[field_count] => 11
[lengths] => Array
(
[0] => 1
[1] => 10
[2] => 11
[3] => 1
[4] => 1
[5] => 1
[6] => 0
[7] => 1
[8] => 1
[9] => 0
[10] => 1
)
[num_rows] => 1
[type] => 0
)
[_isPersistentConnection] =>
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[connectionParameters:protected] => Array
(
)
[databaseName] => ghundihi_crm
)
[_numOfRows] => 1
[_numOfFields] => 11
[_queryID] => mysqli_result Object
(
[current_field] => 11
[field_count] => 11
[lengths] => Array
(
[0] => 1
[1] => 10
[2] => 11
[3] => 1
[4] => 1
[5] => 1
[6] => 0
[7] => 1
[8] => 1
[9] => 0
[10] => 1
)
[num_rows] => 1
[type] => 0
)
[_currentRow] => 0
[_closed] =>
[_inited] => 1
[_obj] =>
[_names] =>
[_currentPage] => -1
[_atFirstPage] =>
[_atLastPage] =>
[_lastPageNo] => -1
[_maxRecordCount] => 0
[datetime] =>
[adodbFetchMode] => 3
)
[session] => phpGrid\C_GridSession Object
(
)
)
[db_connection] => Array
(
)
[obj_subgrid] =>
[obj_md] =>
[data_local] => Array
(
)
[session] => phpGrid\C_GridSession Object
(
)
[autoencode] => 1
[jq_rowConditions:phpGrid\C_DataGrid:private] => Array
(
)
[jq_cellConditions:phpGrid\C_DataGrid:private] => Array
(
)
[script_includeonce:phpGrid\C_DataGrid:private] =>
[script_body:phpGrid\C_DataGrid:private] =>
[script_editEvtHandler:phpGrid\C_DataGrid:private] => afterShowForm:function(form_id){
// always position the dialog in the middle of window
form_id.closest(".ui-jqdialog").position({
my: "center",
at: "center",
of: window
});
}, // afterShowForm
onInitializeForm:function(form_id){},
afterSubmit:function(d,a){return true;},
jqModal:true,
checkOnUpdate:false,
savekey: [true,13],
width:580,
height:"100%",
navkeys: [false,38,40],
checkOnSubmit : false,
reloadAfterSubmit:false,
resize:true,
closeOnEscape:true,
closeAfterEdit:true,bottominfo:"* required",
viewPagerButtons:true,
[script_ude_handler:phpGrid\C_DataGrid:private] => jQuery(document).ready(function($){
$(window).bind("resize", function() {
phpGrid_notes.setGridWidth($("body").width());
}).trigger("resize");
});
[cust_col_properties:phpGrid\C_DataGrid:private] => Array
(
)
[cust_grid_properties:phpGrid\C_DataGrid:private] => Array
(
)
[cust_prop_jsonstr] =>
[img_baseUrl:phpGrid\C_DataGrid:private] =>
[grid_methods:phpGrid\C_DataGrid:private] => Array
(
)
[edit_file:phpGrid\C_DataGrid:private] => edit.php
[columnchooser:phpGrid\C_DataGrid:private] =>
[formonly:phpGrid\C_DataGrid:private] =>
[load_pk:phpGrid\C_DataGrid:private] =>
[form_group_header:phpGrid\C_DataGrid:private] => Array
(
)
[form_tooltip:phpGrid\C_DataGrid:private] => Array
(
)
[iconSet:phpGrid\C_DataGrid:private] => fontAwesome
[guiStyle:phpGrid\C_DataGrid:private] => bootstrap
[col_formats] => Array
(
)
[jq_shrinkToFit] => 1
[jq_is_group_summary] =>
[form_only] =>
)
)
[obj_md] =>
[data_local] => Array
(
)
[session] => phpGrid\C_GridSession Object
(
)
[autoencode] => 1
[jq_rowConditions:phpGrid\C_DataGrid:private] => Array
(
)
[jq_cellConditions:phpGrid\C_DataGrid:private] => Array
(
)
[script_includeonce:phpGrid\C_DataGrid:private] =>
[script_body:phpGrid\C_DataGrid:private] =>
[script_editEvtHandler:phpGrid\C_DataGrid:private] => afterShowForm:function(form_id){
// always position the dialog in the middle of window
form_id.closest(".ui-jqdialog").position({
my: "center",
at: "center",
of: window
});
}, // afterShowForm
onInitializeForm:function(form_id){},
afterSubmit:function(d,a){return true;},
jqModal:true,
checkOnUpdate:false,
savekey: [true,13],
width:580,
height:"100%",
navkeys: [false,38,40],
checkOnSubmit : false,
reloadAfterSubmit:false,
resize:true,
closeOnEscape:true,
closeAfterEdit:true,bottominfo:"* required",
viewPagerButtons:true,
[script_ude_handler:phpGrid\C_DataGrid:private] =>
[cust_col_properties:phpGrid\C_DataGrid:private] => Array
(
)
[cust_grid_properties:phpGrid\C_DataGrid:private] => Array
(
)
[cust_prop_jsonstr] =>
[img_baseUrl:phpGrid\C_DataGrid:private] =>
[grid_methods:phpGrid\C_DataGrid:private] => Array
(
)
[edit_file:phpGrid\C_DataGrid:private] => edit.php
[columnchooser:phpGrid\C_DataGrid:private] =>
[formonly:phpGrid\C_DataGrid:private] =>
[load_pk:phpGrid\C_DataGrid:private] =>
[form_group_header:phpGrid\C_DataGrid:private] => Array
(
)
[form_tooltip:phpGrid\C_DataGrid:private] => Array
(
)
[iconSet:phpGrid\C_DataGrid:private] => fontAwesome
[guiStyle:phpGrid\C_DataGrid:private] => bootstrap
[col_formats] => Array
(
[Email] => Array
(
[email] => Array
(
)
)
[Budget] => Array
(
[currency] => Array
(
[prefix] => $
[suffix] =>
[thousandsSeparator] => ,
[decimalSeparator] => .
[decimalPlaces] => 2
[defaultValue] => 0.00
)
)
[Website] => Array
(
[link] => Array
(
[target] => _new
)
)
)
[jq_shrinkToFit] => 1
[jq_is_group_summary] =>
[form_only] =>
)
SESSION OBJECT
SESSION NAME: PHPSESSID
SESSION ID: d2beff61147c37188e02b607ad0dc330
SESSION KEY: _oPHPGRID_contact
{ }