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] => mysensor_id [index] => mysensor_id [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => [number] => 1 ) ) [1] => Array ( [name] => ref_id [index] => ref_id [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => [number] => 1 ) ) [2] => Array ( [name] => is_valid [index] => is_valid [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [3] => Array ( [name] => sensor_label [index] => sensor_label [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [4] => Array ( [name] => sensor_name [index] => sensor_name [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [5] => Array ( [name] => sensor_location [index] => sensor_location [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [6] => Array ( [name] => sensor_case [index] => sensor_case [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [7] => Array ( [name] => sensortype_id [index] => sensortype_id [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => [number] => 1 ) ) [8] => Array ( [name] => organization_id [index] => organization_id [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => [number] => 1 ) ) [9] => Array ( [name] => remarks [index] => remarks [hidden] => [edittype] => textarea [editable] => [editoptions] => Array ( [cols] => 42 [rows] => 6 [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [10] => Array ( [name] => last_update [index] => last_update [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] => ) ) [11] => 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 * FROM mysensors [scSszsDyqcqvyLtAFSSN:C_DataGrid:private] => [zrXrgBcJRXotwTescYJA:C_DataGrid:private] => Array ( [0] => mysensor_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] => mysensor_id<>0 [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] => mysensor_id [1] => ref_id [2] => is_valid [3] => sensor_label [4] => sensor_name [5] => sensor_location [6] => sensor_case [7] => sensortype_id [8] => organization_id [9] => remarks [10] => last_update [11] => 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] => 32 [_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: 108276 Threads: 2 Questions: 42460 Slow queries: 122 Opens: 103 Flush tables: 1 Open tables: 96 Queries per second avg: 0.392 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 4842 [warning_count] => 0 ) [_errorMsg] => [_errorCode] => [_queryID] => mysqli_result Object ( [current_field] => 12 [field_count] => 12 [lengths] => Array ( [0] => 1 [1] => 1 [2] => 5 [3] => 7 [4] => 47 [5] => 35 [6] => 3 [7] => 1 [8] => 1 [9] => 0 [10] => 19 [11] => 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] => 5 [mysensor_id] => 5 [1] => 3 [ref_id] => 3 [2] => False [is_valid] => False [3] => PPCITY3 [sensor_label] => PPCITY3 [4] => Όθωνος 10 - ΚΕΠ Συντάγματος [sensor_name] => Όθωνος 10 - ΚΕΠ Συντάγματος [5] => 37.97509286305075,23.73311739021301 [sensor_location] => 37.97509286305075,23.73311739021301 [6] => N24 [sensor_case] => N24 [7] => 2 [sensortype_id] => 2 [8] => 1 [organization_id] => 1 [9] => [remarks] => [10] => 2019-08-06 12:05:10 [last_update] => 2019-08-06 12:05:10 [11] => 2019-05-05 12:54:50 [date_insert] => 2019-05-05 12:54:50 ) [blobSize] => 100 [sql] => SELECT * FROM mysensors 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: 108276 Threads: 2 Questions: 42461 Slow queries: 122 Opens: 103 Flush tables: 1 Open tables: 96 Queries per second avg: 0.392 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 4842 [warning_count] => 0 ) [_errorMsg] => [_errorCode] => [_queryID] => mysqli_result Object ( [current_field] => 12 [field_count] => 12 [lengths] => Array ( [0] => 1 [1] => 1 [2] => 5 [3] => 7 [4] => 47 [5] => 35 [6] => 3 [7] => 1 [8] => 1 [9] => 0 [10] => 19 [11] => 19 ) [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] => 1 [1] => 1 [2] => 5 [3] => 7 [4] => 47 [5] => 35 [6] => 3 [7] => 1 [8] => 1 [9] => 0 [10] => 19 [11] => 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: snrrvrir5rp08davrkqg2f4bv1
SESSION KEY: _oPHPGRID_list1
{ "_oPHPGRID_list1_sql":"SELECT * FROM mysensors","_oPHPGRID_list1_sql_key":"a:1:{ i:0;s:11:\"mysensor_id\"; }","_oPHPGRID_list1_sql_fkey":null,"_oPHPGRID_list1_sql_table":"","_oPHPGRID_list1_sql_filter":"mysensor_id<>0","_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:{ }" }