How to read data from mysql more than 1 column to textbox in kodular?

[midogumelar]

I want to make a Barcode Scanner App. I can read data from the database (PHPMyAdmin) in 1 textbox. I want to add data in another textbox. How to add the data can read in another textbox? Thank you

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

How to use the Kodular SQLite component developed by Carlos Pedroza?

I extracted it from @carlospedroza27 's post – PedrozaSQLite Hello! Here I present to you my second extension ever created! It is an extension to access the local SQLite database! Background I know there is already a few extensions with this functionality, but here are the reasons why I made it: First of all, thanks to AppInventor and all its distributions I took my first steps on how to code . Later, I thought about creating extensions and I found that I really like Java and the whole pr…

Read here

[midogumelar]

oke thank you, I’ll try it

[Rogerio_Rios (Professional Support)]

@Still-learning

Read here

You confused: mysql is not the same as sqlite.
Do not respond hastily.
He wants to query the mysql database: he will have to use a web component.
He will have to either use one of the Scripts (Taifun or Juan) or create the Scripts himself.
There are several examples here in the community.

MySQL. PHP. GET. POST. Insert. Update. Delete. Segur SQL Inject

Hello friends, I have published a basic tutorial on MySQLi and PHP in the App Inventor Community, I think it is better to put a link in this forum so as not to repeat the same thing. The tutorial deals with 3 examples: 1.- MySQLi + PHP + GET 2.- MySQLi + PHP + POST 3.- MySQLi + PHP + Web page In these examples I use the 000webhost server. The forum link is: I have also put it in Spanish: App inventor. App inventor y MySQLi. PHP. GET. POST. Página web. Base de datos [mysqlwebhost9] […

https://puravidaapps.com/mysql.php

[Rogerio_Rios (Professional Support)]

@midogumelar

from the database (PHPMyAdmin)

Phpmyadmin It is not a database. It is a tool for using the database.
You need to read about Select SQL command to run a query on the database.

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

@Rogerio_Rios

You confused

I simply added the URL just by seeing his topic… in his heading he mentioned mysql…

[midogumelar]

oh yeah, thank you for your corrections

[midogumelar]

and this is my app, i want the result in textbox 2 (Nama Barang) is Tisu and textbox 3 (Brand) is Mitu.

[midogumelar]

this is my blocks

[midogumelar]

and this is my codes

[Rogerio_Rios (Professional Support)]

You need to return Json from your PHP Script. Then use the Json Decode text block.
And the lookup pairs Key or dictionary 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

[Yogi_Sugianto]

This post was flagged by the community and is temporarily hidden.