Pravee7094 Active Member Jan 29, 2021 #1 Hello All, we used below coding convert to json using DBUtils B4X: gen.Initialize(DBUtils.ExecuteJSON(Main.gs_sql, _ "select mobileregistrationpk,fullname,mobilenumber,password,regstatus,keyvalue,sentstatus,updateon from co_mobile_registration where sentstatus = 'N'", _ Null, 0, _ Array As String(DBUtils.DB_TEXT, DBUtils.DB_TEXT, DBUtils.DB_TEXT,DBUtils.DB_TEXT,DBUtils.DB_TEXT, DBUtils.DB_TEXT, DBUtils.DB_TEXT,DBUtils.DB_INTEGER))) Its works fine. and we got following output. JSON: { "root": [ { "regstatus":"M" "mobilenumber":"8888" "updateon":"1611920526063" "mobileregistrationpk":"1234" "keyvalue":"null" "sentstatus":"N" "password":"password" "fullname":"siva" } ] } question is How to read this json data in php? Any suggestion? Regards Praveen
Hello All, we used below coding convert to json using DBUtils B4X: gen.Initialize(DBUtils.ExecuteJSON(Main.gs_sql, _ "select mobileregistrationpk,fullname,mobilenumber,password,regstatus,keyvalue,sentstatus,updateon from co_mobile_registration where sentstatus = 'N'", _ Null, 0, _ Array As String(DBUtils.DB_TEXT, DBUtils.DB_TEXT, DBUtils.DB_TEXT,DBUtils.DB_TEXT,DBUtils.DB_TEXT, DBUtils.DB_TEXT, DBUtils.DB_TEXT,DBUtils.DB_INTEGER))) Its works fine. and we got following output. JSON: { "root": [ { "regstatus":"M" "mobilenumber":"8888" "updateon":"1611920526063" "mobileregistrationpk":"1234" "keyvalue":"null" "sentstatus":"N" "password":"password" "fullname":"siva" } ] } question is How to read this json data in php? Any suggestion? Regards Praveen