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] => temp_id
[index] => temp_id
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[1] => Array
(
[name] => sensor_id
[index] => sensor_id
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[2] => Array
(
[name] => ref_id
[index] => ref_id
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[3] => Array
(
[name] => temp
[index] => temp
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[4] => Array
(
[name] => humidity
[index] => humidity
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[5] => Array
(
[name] => pressure
[index] => pressure
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[6] => Array
(
[name] => wind_speed
[index] => wind_speed
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[7] => Array
(
[name] => wind_direction
[index] => wind_direction
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[8] => Array
(
[name] => uv
[index] => uv
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[9] => Array
(
[name] => date_insert
[index] => date_insert
[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] =>
)
)
)
[before_script_end] =>
[sql:C_DataGrid:private] => SELECT temp_id,sensor_id,ref_id,temp,humidity,pressure,wind_speed,wind_direction,uv,date_insert FROM temp
[scSszsDyqcqvyLtAFSSN:C_DataGrid:private] =>
[zrXrgBcJRXotwTescYJA:C_DataGrid:private] => Array
(
[0] => temp_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] => temp_id>789020 AND temp_id<793387
[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] => temp_id
[1] => sensor_id
[2] => ref_id
[3] => temp
[4] => humidity
[5] => pressure
[6] => wind_speed
[7] => wind_direction
[8] => uv
[9] => date_insert
)
[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] => 'temp_id','DESC'
[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] => 1155171
[_num_fields:C_DataGrid:private] => 10
[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] => 10
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.6.46
[server_version] => 50646
[stat] => Uptime: 2110681 Threads: 2 Questions: 787803 Slow queries: 822 Opens: 129 Flush tables: 1 Open tables: 122 Queries per second avg: 0.373
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 87586
[warning_count] => 0
)
[_errorMsg] =>
[_errorCode] =>
[_queryID] => mysqli_result Object
(
[current_field] => 10
[field_count] => 10
[lengths] => Array
(
[0] => 3
[1] => 1
[2] => 1
[3] => 8
[4] => 8
[5] => 10
[6] => 7
[7] => 9
[8] => 0
[9] => 19
)
[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] => 540
[temp_id] => 540
[1] => 5
[sensor_id] => 5
[2] => 3
[ref_id] => 3
[3] => 31.19000
[temp] => 31.19000
[4] => 40.00000
[humidity] => 40.00000
[5] => 1002.00000
[pressure] => 1002.00000
[6] => 2.10000
[wind_speed] => 2.10000
[7] => 150.00000
[wind_direction] => 150.00000
[8] =>
[uv] =>
[9] => 2019-07-29 11:05:46
[date_insert] => 2019-07-29 11:05:46
)
[blobSize] => 100
[sql] => SELECT temp_id,sensor_id,ref_id,temp,humidity,pressure,wind_speed,wind_direction,uv,date_insert FROM temp 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] => 10
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.6.46
[server_version] => 50646
[stat] => Uptime: 2110681 Threads: 2 Questions: 787804 Slow queries: 822 Opens: 129 Flush tables: 1 Open tables: 122 Queries per second avg: 0.373
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 87586
[warning_count] => 0
)
[_errorMsg] =>
[_errorCode] =>
[_queryID] => mysqli_result Object
(
[current_field] => 10
[field_count] => 10
[lengths] => Array
(
[0] => 3
[1] => 1
[2] => 1
[3] => 8
[4] => 8
[5] => 10
[6] => 7
[7] => 9
[8] => 0
[9] => 19
)
[num_rows] => 1
[type] => 0
)
[_isPersistentConnection] =>
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[connectionParameters:protected] => Array
(
)
[databaseName] => waspmote
)
[_numOfRows] => 1
[_numOfFields] => 10
[_queryID] => mysqli_result Object
(
[current_field] => 10
[field_count] => 10
[lengths] => Array
(
[0] => 3
[1] => 1
[2] => 1
[3] => 8
[4] => 8
[5] => 10
[6] => 7
[7] => 9
[8] => 0
[9] => 19
)
[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: ltk4dtbkbtkq7fgi2l3d81pdn7
SESSION KEY: _oPHPGRID_list1
{
"_oPHPGRID_list1_sql":"SELECT temp_id,sensor_id,ref_id,temp,humidity,pressure,wind_speed,wind_direction,uv,date_insert FROM temp","_oPHPGRID_list1_sql_key":"a:1:{
i:0;s:7:\"temp_id\";
}","_oPHPGRID_list1_sql_fkey":null,"_oPHPGRID_list1_sql_table":"","_oPHPGRID_list1_sql_filter":"temp_id>789020 AND temp_id<793387","_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:{
}"
}