How do you populate listpicker fro MySQL using PHP?

MIT App Inventor Help
1

The table MySQL has id and usuarios columns and I want to load ListPicker with the name of users. How to do the php arquive and block diagram to receive information?

2

Send a select query to the database, for example

Select userNames from myTable

Then convert the result, which is a 1 column csv table into a list and display it in the listpicker

Taifun

3

Thank's for your attention.
$sql = "SELECT usuario FROM ToDoUsuarios ORDER BY ID ASC";
$res = mysqli_query($con,$sql);
$linhas = mysqli_num_rows($res);
This first part is ok. Think the problem is to output some thing that the web block can read and populate the ListPicker.
$row = mysqli_fetch_row($res);
while($row = mysqli_fetch_row($res)){
$csv_output .= """.$row[1].""".","; ???
}
print $csv_output;
Cannot parse text argument to "list from csv table" as a CSV-formatted table
"responseContent" from web block and "list from csv table text"
Thak you in advance

4

It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.

To get an image of your blocks, right click in the Blocks Editor and select "Download Blocks as Image". You might want to use an image editor to crop etc. if required. Then post it here in the community.

Taifun

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by icon24 Taifun.