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] => 1140693 [_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: 107527 Threads: 2 Questions: 41562 Slow queries: 122 Opens: 103 Flush tables: 1 Open tables: 96 Queries per second avg: 0.386 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 4750 [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: 107527 Threads: 2 Questions: 41563 Slow queries: 122 Opens: 103 Flush tables: 1 Open tables: 96 Queries per second avg: 0.386 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 4750 [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: cvpakijl00g9epfp6un1n8du80
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:{ }" }