Looking for Guidance about Kodular and MySQL using PHP

[TheGoodSamaritan]

hello everyone, im new to kodular and i want to ask for your help regarding my simple program. before writing here, ive spent 8 hours trying to read and understand some post here regarding my problem to no avail.

I’m trying to develop a login form where the user could enter their user/password, and then it will display their fullname, address, contact. Im using MySQL as my database and use a php file to interface with kodular.

Here is my block.

the block is working until the response content. The message dialog really displays the John Doe, City Address, 03466734.

fullname, address,contact are the from php/database

// If Password matches, retrieve user information
$fullname = $row['fullname'];
$address = $row['address'];
$contact = $row['contact'];

What i want is to display those three on the labels instead. im lost in this json, dictionary as im also new to them. thank you very much in advance.

[Still-learning (1-2-3-4...)]

The response content is seems to be in csv row so just use list from csv row text to and convert the return value into list then by using select list item block to parse them into various label

[TheGoodSamaritan]

Thank you for your help. ill dig into this and hopefully i find a solution.

[Rogerio_Rios (Professional Support)]

Well, hours of trying are not hours wasted: they are hours of learning. 8 hours…1 day…1 week… learning time is always valid. Which part do you have problems with? What type of data does your PHP script return? Json? What’s actually going on in your web . got? Give more details and that increases the chance that you will receive help directed to your problem.
Hugs

How do i fetch data from json which is in this format?

Use dictionary maybe works : [JsonHarryPotter]

[Free] Decode Json easily. JsonPath. Convert XML <> JSON

Hello friends: With this extension we can get the elements of a Json easily by writing their path. I have tested it with App Inventor and now with Kodular on an Android 9. This extension is based on this library: - Blocks. Set a Json string and a path (see example). Get object or array. [json_deco9] Set a Json string, Show Json in pretty format. [json_deco10] Convert Json string to Xml string and Xml string to Json string. [decodifica_json11k] - Example. To carry out the tests w…

[Free] Json To Dictionary Extension

Json To Dictionary Extension Release date : 2020-10-24T23:00:00Z (UTC) Last Update Date : 2020-10-24T23:00:00Z (UTC) Current Version: 1 Min. Api version : 1 ( Works on every android version ) Ending Date : ( When kodular add it as a built in block ) Description Hello, every one ! Today i release my very first extension ! Json To Dictionary , i actually made it after seeing this topic : Request for JSON decode to dictionary, to parse json text to dictionaries till kodular …

Extract data from complex JSON

[Screenshot_20210211-143928] Use Get Value For Key “contratos” In dictionary ( your list ) Put in variable ContractNumber [getvalue] [foreach3] Do for each in SuaLista [anotherlist] Block add itens to list OutraLista [lookuppairs3] Item. - Block look UP in pairs Key Set listview elements OutraLista

Help with displaying data from mysql database please

Nobody knows what you did. There are 2 PHP Scripts ( here in community )ready to help beginners. You do not need an extension to access Mysql. OK ? In web got, you will have to use response Content (this is where you will have the data returned from your Script). You can use the response code to check the return code You can use the Json Decode text Block to handle Response Content. You can use dictionary blocks. You can use lookup pairs Key together with Json Decode text to get values by…

[TheGoodSamaritan]

Thank you for sharing your time with me.

my php script will return the value of

1. I have a problem displaying the data i retrieved from database to display in three labels.
2. Here are the variables and the data type i want to display from mysql database using php to kodular
   fullname - varchar
   address - varchar
   contact - bigint
3. ive tried this two web.got, but it only works until the Show Message Dialog’s Response Content which is in the form of John Doe, City Address, 31829312 . but the labels are not working, it should be three labels.

[TheGoodSamaritan]

Thank you to the two of you, i have known the problem. it lies on what im trying to retrieved and the format in which i want to get it. it turns out that im trying to get a row of data and in kodular im taking it in the form of json and dictionary so it wont work.

The solution is to edit the php so that the response content is in the form of json

$response = array();
$response["fullname"] = $row['fullname'];
$response["address"] = $row['address'];
$response["contact"] = $row['contact'];

the block in my first post is now working as they are now in dictionary pairs.