How to get list from Sql in Spinner

[Rogerio_Rios (Professional Support)]

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

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

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

Use dictionary maybe works : [JsonHarryPotter]

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…

You need to read this:

How Can I Learn Kodular from beginner to advanced level?

Taifun has made this suggestion: A very good way to learn App Inventor or Kodular is to read the free Inventor’s Manual here in the AI2 free online eBook App Inventor 2 Book: Create Your Own Android Apps … the links are at the bottom of the Web page. The book ‘teaches’ users how to program with AI2 blocks. There is a free programming course here Course In A Box and the aia files for the projects in the book are here: App Inventor 2 Book: Create Your Own Android Apps How to do a lot of ba…