How can I Get Elements in single raw from Mysql using blocks

Hello. :grin:There are several examples on this subject here in the community. Have you already done a search on?:grinning::+1:

I am a beginner, could you help me please?

Sure

Taifun


php table
blocks

I am using simple insert, update and read php files

read file showing the data in a table

I need to select every cell in a single raw in label

ID in a label
Email in a label
Balance in a label
Refer in a Label

I hope you can help me by php file and blocks needed

Thank you

my MySql solution is here App Inventor Tutorials and Examples: MySQL | Pura Vida Apps
to get the data of a specific user (in the example the user having user id = 7) you can send the following sql statement to the database

SELECT * FROM yourTableName WHERE ID = 7

Taifun

I need PHP file used for this please

it does not look like you checked my MySQL page, else you could have found what you need
Taifun

I already used the php code in the link
But unfortunately it shows (Bad request) message

Could you please solve this problem for me if you can?

Where?

Make sure to follow the setup instructions carefully

What about providing a screenshot of your relevant blocks?

Taifun

I do not know what is the wrong with this code
Hope you find the error please


2
1

I’m not familiar with @juananton1991’s solution… he might want to provide some advice. .

Taifun

do you have any suggestion??

My suggestion is here

Taifun

I am sorry for more questions
I success to make php file to get Balance value when inserting the ID

but the blocks it seems wrong

could you help me to make the correct blocks please

Uploading: 7.JPG…

7

I could not use your link of mysql.php

because it is always show Bad request

9

My script returns Bad request if you try to open it using a browser, you will have to use it after following the setup steps carefully using the web component in your Kodular project.

Sorry, I’m not available to help you with php scripts… I prepared a script which is working for all purposes…

Taifun