Retrieve phone number and text from mysql database to list view and send text message to each number

[SBCLDB_IT_division]

Please help me. i am using mysql extension . i have a table with three column 1. id 2. phone 3.text. phone contains all mobile number and text contains the text message. now i need to retrieve all the mobile number and text messages in a list view to send text message by each number and text with the list. help me this. thanks

[Rogerio_Rios (Professional Support)]

Welcome.
Web Component:

Use web.got event.
Use web Json Decode Text block.
Use Dictionary
Use lookup pairs Key
Use listview Elements
…
Search in comunnity there are many examples

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

I hope this guide will be helpful one to you

MySQL query to ListView

Hello everyone, In this guide I am going to practically show you how to set list in ListView from a returned value of a custom MySQL query. Citation and Credit goes to: @Taifun - Pura Vida Apps @Hossein - Daily Challenge 29 @Rogerio_Rios - for pointing out the mistakes. STEP 1: Server Setup Put the PHP code on your web server. mysql.TXT (4.4 KB) (Please change the extension from .txt to .php before uploading) Set the SQLKEY in your app and in the PHP code, they must match for this code …

[SBCLDB_IT_division]

thanks for the reply . could you please give me some tutorial by giving some block screenshot ?

[Rogerio_Rios (Professional Support)]

There are many examples here.
Use the community search tool.
The answer he posted, has an example (but needs fixing).