Fetch data from MySQL and auto insert them into a Spinner

[3lykkomo-programming (3rd High School of Komotini)]

Dear All,

I would like to ask if it is possible to fetch data from MySQL and insert them automatically into a drop down (Spinner) in kodular.

Thank you for your time in advance.

[Rogerio_Rios (Professional Support)]

@3lykkomo-programming

it is possible to fetch data from MySQL and insert them

Yes

How to get list from Sql in Spinner

1- take a list and assign it the return of the Json Decode Text block. Get the Response Content to the Json Decode Text block You need to read this:

How can i get data from json to spinner

You can try using the block : ( and so learn …just a suggestion) [keypath] + [makelist] + [stringname] + [foreach] + [lookuppairs2] [sitenames] One question: Will your Json always be like this? date, date2, date3, date4, date5 … daily, daily2, daily3, daily4, daily5…

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

Use dictionary maybe works : [JsonHarryPotter]

Do You already have :
-your database ?
-the php script ?

[3lykkomo-programming (3rd High School of Komotini)]

@Rogerio_Rios

-your database ?

-the php script ?

I have the database, and I found a PHP Script to fetch the MySQL data and convert them into JSON format.

[Rogerio_Rios (Professional Support)]

Spinner + Json from Database

[3lykkomo-programming (3rd High School of Komotini)]

Thank you very much for your help!!!

I managed to make it !