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] => device_id
                    [index] => device_id
                    [hidden] => 
                    [edittype] => text
                    [editable] => 
                    [editoptions] => Array
                        (
                            [size] => 30
                        )

                    [editrules] => Array
                        (
                            [edithidden] => 
                            [required] => 
                            [number] => 1
                        )

                )

            [2] => Array
                (
                    [name] => temperature
                    [index] => temperature
                    [hidden] => 
                    [edittype] => text
                    [editable] => 
                    [editoptions] => Array
                        (
                            [size] => 30
                        )

                    [editrules] => Array
                        (
                            [edithidden] => 
                            [required] => 
                            [number] => 1
                        )

                )

            [3] => Array
                (
                    [name] => humidity
                    [index] => humidity
                    [hidden] => 
                    [edittype] => text
                    [editable] => 
                    [editoptions] => Array
                        (
                            [size] => 30
                        )

                    [editrules] => Array
                        (
                            [edithidden] => 
                            [required] => 
                            [number] => 1
                        )

                )

            [4] => Array
                (
                    [name] => pressure
                    [index] => pressure
                    [hidden] => 
                    [edittype] => text
                    [editable] => 
                    [editoptions] => Array
                        (
                            [size] => 30
                        )

                    [editrules] => Array
                        (
                            [edithidden] => 
                            [required] => 
                            [number] => 1
                        )

                )

            [5] => Array
                (
                    [name] => concentration
                    [index] => concentration
                    [hidden] => 
                    [edittype] => text
                    [editable] => 
                    [editoptions] => Array
                        (
                            [size] => 30
                        )

                    [editrules] => Array
                        (
                            [edithidden] => 
                            [required] => 
                            [number] => 1
                        )

                )

            [6] => Array
                (
                    [name] => noise
                    [index] => noise
                    [hidden] => 
                    [edittype] => text
                    [editable] => 
                    [editoptions] => Array
                        (
                            [size] => 30
                        )

                    [editrules] => Array
                        (
                            [edithidden] => 
                            [required] => 
                            [number] => 1
                        )

                )

            [7] => Array
                (
                    [name] => o3
                    [index] => o3
                    [hidden] => 
                    [edittype] => text
                    [editable] => 
                    [editoptions] => Array
                        (
                            [size] => 30
                        )

                    [editrules] => Array
                        (
                            [edithidden] => 
                            [required] => 
                            [number] => 1
                        )

                )

            [8] => 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 id,device_id,temperature,humidity,pressure,concentration,noise,o3,date_insert FROM data
    [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] => ID> AND ID<785573
    [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] => device_id
            [2] => temperature
            [3] => humidity
            [4] => pressure
            [5] => concentration
            [6] => noise
            [7] => o3
            [8] => 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] => 
    [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] => 749771
    [_num_fields:C_DataGrid:private] => 9
    [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] => 9
                            [host_info] => Localhost via UNIX socket
                            [info] => 
                            [insert_id] => 0
                            [server_info] => 5.6.46
                            [server_version] => 50646
                            [stat] => Uptime: 107415  Threads: 3  Questions: 41537  Slow queries: 122  Opens: 103  Flush tables: 1  Open tables: 96  Queries per second avg: 0.386
                            [sqlstate] => 00000
                            [protocol_version] => 10
                            [thread_id] => 4746
                            [warning_count] => 0
                        )

                    [_errorMsg] => 
                    [_errorCode] => 
                    [_queryID] => mysqli_result Object
                        (
                            [current_field] => 9
                            [field_count] => 9
                            [lengths] => Array
                                (
                                    [0] => 1
                                    [1] => 1
                                    [2] => 5
                                    [3] => 5
                                    [4] => 9
                                    [5] => 0
                                    [6] => 0
                                    [7] => 0
                                    [8] => 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] => 2
                            [id] => 2
                            [1] => 1
                            [device_id] => 1
                            [2] => 20.42
                            [temperature] => 20.42
                            [3] => 45.75
                            [humidity] => 45.75
                            [4] => 101609.98
                            [pressure] => 101609.98
                            [5] => 
                            [concentration] => 
                            [6] => 
                            [noise] => 
                            [7] => 
                            [o3] => 
                            [8] => 2018-11-06 15:44:09
                            [date_insert] => 2018-11-06 15:44:09
                        )

                    [blobSize] => 100
                    [sql] => SELECT id,device_id,temperature,humidity,pressure,concentration,noise,o3,date_insert FROM data 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] => 9
                                    [host_info] => Localhost via UNIX socket
                                    [info] => 
                                    [insert_id] => 0
                                    [server_info] => 5.6.46
                                    [server_version] => 50646
                                    [stat] => Uptime: 107415  Threads: 3  Questions: 41538  Slow queries: 122  Opens: 103  Flush tables: 1  Open tables: 96  Queries per second avg: 0.386
                                    [sqlstate] => 00000
                                    [protocol_version] => 10
                                    [thread_id] => 4746
                                    [warning_count] => 0
                                )

                            [_errorMsg] => 
                            [_errorCode] => 
                            [_queryID] => mysqli_result Object
                                (
                                    [current_field] => 9
                                    [field_count] => 9
                                    [lengths] => Array
                                        (
                                            [0] => 1
                                            [1] => 1
                                            [2] => 5
                                            [3] => 5
                                            [4] => 9
                                            [5] => 0
                                            [6] => 0
                                            [7] => 0
                                            [8] => 19
                                        )

                                    [num_rows] => 1
                                    [type] => 0
                                )

                            [_isPersistentConnection] => 
                            [_evalAll] => 
                            [_affected] => 
                            [_logsql] => 
                            [_transmode] => 
                            [connectionParameters:protected] => Array
                                (
                                )

                            [databaseName] => waspmote
                        )

                    [_numOfRows] => 1
                    [_numOfFields] => 9
                    [_queryID] => mysqli_result Object
                        (
                            [current_field] => 9
                            [field_count] => 9
                            [lengths] => Array
                                (
                                    [0] => 1
                                    [1] => 1
                                    [2] => 5
                                    [3] => 5
                                    [4] => 9
                                    [5] => 0
                                    [6] => 0
                                    [7] => 0
                                    [8] => 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: m2cr2cgc4r3f6pl1nus80q9e34
SESSION KEY: _oPHPGRID_list1
{ "_oPHPGRID_list1_sql":"SELECT id,device_id,temperature,humidity,pressure,concentration,noise,o3,date_insert FROM data","_oPHPGRID_list1_sql_key":"a:1:{ i:0;s:2:\"id\"; }","_oPHPGRID_list1_sql_fkey":null,"_oPHPGRID_list1_sql_table":"","_oPHPGRID_list1_sql_filter":"ID> AND ID<785573","_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:{ }" }