How to remove column name while retrieving data

[franz1 (Franz Balleis)]

Maybe because he didn’t know that the service there was so bad ?

Especially when you start with Kodular you just make mistakes and for the community is actually there.

I also had problems with Kodular and SQL at the beginning. I’m almost desperate no matter what extension I used, I just couldn’t get SQL up and running. Only @Taifun then explained to me in a subordinate clause that I cannot write on the assets folder while the app is running.

Information that should actually be somewhere in the documentation, right?
regards Franz

[pipechela (Felipe Valenzuela)]

That extension just is the puravida method. Even he uses the script from him. Exactly the same scriot

[Rogerio_Rios (Professional Support)]

https://puravidaapps.com/mysql.php
The .php script you are using in the DEEP HOST extension is from that link I posted above. You will use the blocks that are on the page. And it will use the same .php script.
DEEP HOST does not respond to our emails.

[ShaikhSajidAli (Muhammed Sajid Ali)]

I already mentioned taifuns method not extension which depends only on blocks of web with post method

[juananton1991 (Juan Antonio)]

Here we have more information about MySQL, maybe you can get some ideas.

MySQLi. PHP. GET. POST. Insert. Update. Delete. Show. 000webhost.

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] …

[Taifun]

@Sanvi

But just need to remove that from label in which I am displaying data.

the result which will be returned from the MySQL database is a table in csv format
usually you convert that table into a list of lists using the list from csv table block
and now if you want to remove the header row, just use the remove list item block together with index 1

Taifun

[Sanvi]

@Taifun
See I have a table in MySQL

When I am calling this data see my blocks:-

In list which I have called is showing on top of my result as like.

I don’t wants to show this.
Please suggest me method to remove this.
Thanks

[vknow360 (Sunny Gupta)]

Can you show related blocks?

[Sanvi]

@vknow360

These are only blocks for this.

[vknow360 (Sunny Gupta)]

Use this block in Got_All_Columns event before setting lable text to values:

[Sanvi]

But @vknow360 I am not using global variable in it

[ShaikhSajidAli (Muhammed Sajid Ali)]

He is only defining process.
In global variable use what you get from mysql.

[Sanvi]

@ShaikhSajidAli I am calling all columns so what to place in global variable? Please help me

[ShaikhSajidAli (Muhammed Sajid Ali)]

What you get in all columns.
From which list you are working use that list after getting data

[Sanvi]

Can you please share me blocks for this.

[vknow360 (Sunny Gupta)]

Hi @Sanvi
Sorry but you are not trying to solve your problem yourself.
I know you have joined commuity (perhaps Kodular also) 2 days ago so everything is new to you.And this is the best time to learn from yourslef by trial and error method.
Most of the best Developers have replied on this topic giving you a lot of hints to solve your problem but I think you are interested in solving problems and want ready made blocks which you can copy-paste in creator.
So I admit that I am unable to help you and this ‘guilt’ forces me to do this:

[Sanvi]

I am sorry si.r

[Taifun]

@Sanvi

Can you please share me blocks

see again my last answer assuming, you are trying to get several columns

@Taifun

the result which will be returned from the MySQL database is a table in csv format
usually you convert that table into a list of lists using the list from csv table block
and now if you want to remove the header row, just use the remove list item block together with index 1

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 basic things with App Inventor are described here: How do you...? .

Also do the tutorials Tutorials for MIT App Inventor to learn the basics of App Inventor, then try something and follow the Top 5 Tips: How to learn App Inventor

Taifun

[Zia_Choudhary (Zia Ur Rahman)]

U can remove coloumn names by running a query but don’t use extension for mysql use PHP scripts which allows u to run queries and then use this query to remove column names

– without column headings
select column_name ‘’
from Table;

Try this query and it will work​