phpGrid(v6.1) {jqGrid:v4.5.2, jQuery:v1.9.0, jQuery UI:1.10.0}
AJAX RESPONSE
CONTROL VALIDATION
DATAGRID OBJECT
C_DataGrid Object
(
[jq_colModel] => Array
(
[0] => Array
(
[name] => ID
[index] => ID
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[1] => Array
(
[name] => sensorID
[index] => sensorID
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[2] => Array
(
[name] => time
[index] => time
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[dataInit] => ###function(el){$(el).datepicker({changeMonth: true, changeYear: true,dateFormat:'yy-mm-dd'});}###
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[3] => Array
(
[name] => aqivalue
[index] => aqivalue
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[4] => Array
(
[name] => rtaqi
[index] => rtaqi
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[5] => Array
(
[name] => staqi
[index] => staqi
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[6] => Array
(
[name] => chartgms
[index] => chartgms
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[7] => Array
(
[name] => chastgms
[index] => chastgms
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[8] => Array
(
[name] => chbrtgms
[index] => chbrtgms
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[9] => Array
(
[name] => chbstgms
[index] => chbstgms
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[10] => Array
(
[name] => pm25level
[index] => pm25level
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[11] => Array
(
[name] => pm25val
[index] => pm25val
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
)
[before_script_end] =>
[sql:C_DataGrid:private] => SELECT ID,sensorID,time,aqivalue,rtaqi,staqi,chartgms,chastgms,chbrtgms,chbstgms,pm25level,pm25val FROM temptable
[scSszsDyqcqvyLtAFSSN:C_DataGrid:private] =>
[zrXrgBcJRXotwTescYJA:C_DataGrid:private] => Array
(
[0] => ID
)
[eaIqmgLgnItFsoWAEdnn:C_DataGrid:private] =>
[hsYgbsoKPwcvUUbPQzPB:C_DataGrid:private] => Array
(
)
[pVawonXnNSHaEXaDfFHI:C_DataGrid:private] => Array
(
)
[zvafcTTQXCrTldoMphnk:C_DataGrid:private] => Array
(
)
[SACPlesooIgyQwzUvygD:C_DataGrid:private] => Array
(
)
[PANnnZOkwjpmkOkVvVwC:C_DataGrid:private] => Array
(
)
[UOhOtcBpeAFtRyciFDDy:C_DataGrid:private] => Array
(
)
[RoUowslhIdwEIaInViMf:C_DataGrid:private] => Array
(
)
[XIBGEbyMabbfmxNHrxXx:C_DataGrid:private] => Array
(
)
[fUcwMLVOIobtdZjLtYtg:C_DataGrid:private] =>
[MQJXbVXNRTXanHMYJacp:C_DataGrid:private] => Array
(
)
[col_custom:C_DataGrid:private] =>
[col_custom_css:C_DataGrid:private] =>
[col_wysiwyg:C_DataGrid:private] => Array
(
)
[col_default:C_DataGrid:private] => Array
(
)
[col_frozen:C_DataGrid:private] => Array
(
)
[iLvxWIxnUzJrEhpjrao:C_DataGrid:private] => Array
(
)
[col_aligns:C_DataGrid:private] => Array
(
)
[col_edit_dimension:C_DataGrid:private] => Array
(
)
[col_fileupload:C_DataGrid:private] => Array
(
)
[col_virtual:C_DataGrid:private] => Array
(
)
[col_customrule:C_DataGrid:private] => Array
(
)
[col_autocomplete:C_DataGrid:private] => Array
(
)
[sql_filter:C_DataGrid:private] =>
[XcxAhvGrghbgRhQjASCk:C_DataGrid:private] => Array
(
)
[HiDeeAQGDLlArSxADilW:C_DataGrid:private] =>
[uafWxTshdmADXTMDTklI:C_DataGrid:private] =>
[KTlAoREvwiABqfDJVNEw:C_DataGrid:private] => list1
[OBdYQDhAdXqrTqVMLXyb:C_DataGrid:private] => "/platform3/phpgrid/data.php?dt=json&gn=list1"
[ULeutgFTmojSwEYDKora:C_DataGrid:private] => json
[nvfTJfEVtLSTDFHxmGdO:C_DataGrid:private] => GET
[EGokLNhbxsytTlNLuek:C_DataGrid:private] => Array
(
[0] => ID
[1] => sensorID
[2] => time
[3] => aqivalue
[4] => rtaqi
[5] => staqi
[6] => chartgms
[7] => chastgms
[8] => chbrtgms
[9] => chbstgms
[10] => pm25level
[11] => pm25val
)
[UOyOGKiRwfFitEOKaDJg:C_DataGrid:private] => "#list1_pager1"
[MmoDPgJDqiHLGduvILCl:C_DataGrid:private] => 20
[zutaWmUZBdGUnnsHgZMX:C_DataGrid:private] => Array
(
[0] => 10
[1] => 20
[2] => 30
[3] => 50
[4] => 100
)
[uRCwctSIiIQCRgDGpcne:C_DataGrid:private] => 'ID', 'ASC'
[vRWAzQRwIXUwFkpzVjxw:C_DataGrid:private] => ASC
[JsbbcbmspLiBhqINTbUk:C_DataGrid:private] => 1
[yGYEtEnxhjjKkhgYHNDY:C_DataGrid:private] =>
[KRDXLIBrFRHCoeSOqjkA:C_DataGrid:private] => 1
[xuQFNnhvcyHtqnGcBhMG:C_DataGrid:private] => 1000
[GJJDFKJuwbvUepXRNCmw:C_DataGrid:private] => 100%
[jEJekHnIUYJyXZFMfWGx:C_DataGrid:private] =>
[cXrNZkDGJCpCjSjwZbTO:C_DataGrid:private] =>
[jq_group_summary_show:C_DataGrid:private] =>
[jq_direction:C_DataGrid:private] => ltr
[zHRNpIMrDVAgrQsvVtZE:C_DataGrid:private] => false
[zmVukhkanNsqMLAgNHo:C_DataGrid:private] =>
[QLEPwSsWCvOjPDcRTbFo:C_DataGrid:private] =>
[MwLBVGpewctwYSzPznkm:C_DataGrid:private] => 1
[vZcbjVPOYxEYkSeDHXxE:C_DataGrid:private] => 22
[OlSUUmiesJldiNOcVbEw:C_DataGrid:private] =>
[LmsrUIXSpQotFugJMyyw:C_DataGrid:private] =>
[ANSonKeeYyNtCvcWYFGw:C_DataGrid:private] =>
[wUjfgQlaWGldXCojLeoG:C_DataGrid:private] => Loading phpGrid Lite...
[eoFwRjfefzfopfXkQgE:C_DataGrid:private] =>
[MnPIiIfPbTYyGDsWpmLc:C_DataGrid:private] =>
[JSPfsgttAJEyMQrsZiqu:C_DataGrid:private] => 1
[sWVCTvNSQeMPkSkdEAsV:C_DataGrid:private] => Array
(
[is_resizable] =>
[min_width] => 300
[min_height] => 100
)
[idggOwYvEktONuEdoPoK:C_DataGrid:private] => 75198
[_num_fields:C_DataGrid:private] => 12
[BQAYLNvLQdSuZPEhnuKm:C_DataGrid:private] => phpGrid(v6.1) {jqGrid:v4.5.2, jQuery:v1.9.0, jQuery UI:1.10.0}
[MztodXfJgEiCmKNScggI:C_DataGrid:private] => 450
[cFgBYpzYPivTwUZtqspi:C_DataGrid:private] => 100%
[edit_mode:C_DataGrid:private] => NONE
[jSlnDHdHaQtmqMFOEynQ:C_DataGrid:private] =>
[ohaoHLBeaYiXgPPJlnbX:C_DataGrid:private] =>
[advanced_search:C_DataGrid:private] => 1
[QsgAuJpMPrCveLqQnfKa:C_DataGrid:private] =>
[hwVTcgcSWcxkcCOEhJk:C_DataGrid:private] => Array
(
[hover] => #F2FC9C
[highlight] => yellow
[altrow] => #F5FAFF
)
[WLCxhqvYPTTeDtasSuUU:C_DataGrid:private] => start
[DgOKQsyjASLDMkpkbTHk:C_DataGrid:private] => en
[auto_resize:C_DataGrid:private] =>
[wRjrMkifPQphcoKIsOId:C_DataGrid:private] =>
[export_type] => EXCEL
[oIDYHZWuwSBAAxdLqWIs] => /platform3/phpgrid/export.php?dt=json&gn=list1
[debug] => 1
[db] => C_Database Object
(
[zyKIxGFCDaGuObCtPLcH] => localhost
[LYZymBHAGWBWWOZHXICM] => waspmote
[password] => qwe#123!@#
[databaseName] => waspmote
[tableName] =>
[link] =>
[dbType] => mysql
[charset] => utf8
[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] => waspmote
[host] => localhost
[user] => waspmote
[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 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 12
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.6.46
[server_version] => 50646
[stat] => Uptime: 2096151 Threads: 2 Questions: 782110 Slow queries: 818 Opens: 129 Flush tables: 1 Open tables: 122 Queries per second avg: 0.373
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 86945
[warning_count] => 0
)
[_errorMsg] =>
[_errorCode] =>
[_queryID] => mysqli_result Object
(
[current_field] => 12
[field_count] => 12
[lengths] => Array
(
[0] => 7
[1] => 2
[2] => 19
[3] => 2
[4] => 2
[5] => 2
[6] => 5
[7] => 5
[8] => 2
[9] => 5
[10] => 3
[11] => 6
)
[num_rows] => 1
[type] => 0
)
[_isPersistentConnection] =>
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[connectionParameters:protected] => Array
(
)
[databaseName] => waspmote
)
[result] => ADORecordSet_mysqli Object
(
[databaseType] => mysqli
[canSeek] => 1
[dataProvider] => native
[fields] => Array
(
[0] => 6207162
[ID] => 6207162
[1] => 13
[sensorID] => 13
[2] => 2021-10-01 00:00:10
[time] => 2021-10-01 00:00:10
[3] => 87
[aqivalue] => 87
[4] => 90
[rtaqi] => 90
[5] => 87
[staqi] => 87
[6] => 30.03
[chartgms] => 30.03
[7] => 28.96
[chastgms] => 28.96
[8] => 31
[chbrtgms] => 31
[9] => 29.52
[chbstgms] => 29.52
[10] => LOW
[pm25level] => LOW
[11] => 29.000
[pm25val] => 29.000
)
[blobSize] => 100
[sql] => SELECT ID,sensorID,time,aqivalue,rtaqi,staqi,chartgms,chastgms,chbrtgms,chbstgms,pm25level,pm25val FROM temptable 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] => waspmote
[host] => localhost
[user] => waspmote
[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 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 12
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.6.46
[server_version] => 50646
[stat] => Uptime: 2096151 Threads: 2 Questions: 782111 Slow queries: 818 Opens: 129 Flush tables: 1 Open tables: 122 Queries per second avg: 0.373
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 86945
[warning_count] => 0
)
[_errorMsg] =>
[_errorCode] =>
[_queryID] => mysqli_result Object
(
[current_field] => 12
[field_count] => 12
[lengths] => Array
(
[0] => 7
[1] => 2
[2] => 19
[3] => 2
[4] => 2
[5] => 2
[6] => 5
[7] => 5
[8] => 2
[9] => 5
[10] => 3
[11] => 6
)
[num_rows] => 1
[type] => 0
)
[_isPersistentConnection] =>
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[connectionParameters:protected] => Array
(
)
[databaseName] => waspmote
)
[_numOfRows] => 1
[_numOfFields] => 12
[_queryID] => mysqli_result Object
(
[current_field] => 12
[field_count] => 12
[lengths] => Array
(
[0] => 7
[1] => 2
[2] => 19
[3] => 2
[4] => 2
[5] => 2
[6] => 5
[7] => 5
[8] => 2
[9] => 5
[10] => 3
[11] => 6
)
[num_rows] => 1
[type] => 0
)
[_currentRow] => 0
[_closed] =>
[_inited] => 1
[_obj] =>
[_names] =>
[_currentPage] => -1
[_atFirstPage] =>
[_atLastPage] =>
[_lastPageNo] => -1
[_maxRecordCount] => 0
[datetime] =>
[adodbFetchMode] => 3
)
)
[db_connection] => Array
(
)
[xAalFtwJwMQLkdTRRULE] =>
[obj_md] =>
[data_local] => Array
(
)
[jq_rowConditions:C_DataGrid:private] => Array
(
)
[jq_cellConditions:C_DataGrid:private] => Array
(
)
[script_includeonce:C_DataGrid:private] =>
[script_body:C_DataGrid:private] =>
[script_editEvtHandler:C_DataGrid:private] =>
[hAQEPLwsYfgQOCngLkto:C_DataGrid:private] =>
[cust_col_properties:C_DataGrid:private] => Array
(
)
[cust_grid_properties:C_DataGrid:private] => Array
(
)
[cust_prop_jsonstr] =>
[DDcSdMlljylessezxSly:C_DataGrid:private] =>
[grid_methods:C_DataGrid:private] => Array
(
)
[edit_file:C_DataGrid:private] => edit.php
[col_formats] => Array
(
)
[jq_shrinkToFit] => 1
[jq_is_group_summary] =>
)
SESSION OBJECT
SESSION NAME: PHPSESSID
SESSION ID: 5kq6162p3v601e5vkmdl0lg5t4
SESSION KEY: _oPHPGRID_list1
{
"_oPHPGRID_list1_sql":"SELECT ID,sensorID,time,aqivalue,rtaqi,staqi,chartgms,chastgms,chbrtgms,chbstgms,pm25level,pm25val FROM temptable","_oPHPGRID_list1_sql_key":"a:1:{
i:0;s:2:\"ID\";
}","_oPHPGRID_list1_sql_fkey":null,"_oPHPGRID_list1_sql_table":"","_oPHPGRID_list1_sql_filter":null,"_oPHPGRID_list1_db_connection":"a:0:{
}","_oPHPGRID_list1_has_multiselect":false,"_oPHPGRID_list1_export_type":"EXCEL","_oPHPGRID_list1_col_titles":"a:0:{
}","_oPHPGRID_list1_col_hiddens":"a:0:{
}"
}