[Solved] MySql Database for listview

as I can see, you are following the MySQL tutorial from here App Inventor Tutorials and Examples: MySQL | Pura Vida Apps

as it already has been said, this is not an error, just remove the Notifier and try again
Unbenannt

@yanquisalexander which extension are you talking about? any link? as far as I know, a MySQL extension is not possible, because MySQL runs on a web server…

Taifun

2 Likes

http://deephost.in/aix=39

This extension

Is based on your MySQL script from what I saw

@yanquisalexander thank you for letting me know…
it seems to be, I have to add a few more extensions from @Deep_Host into the extensions directory:wink:

@Deep_Host congratulations! this looks like a great extension, which is based on my script from here App Inventor Tutorials and Examples: MySQL | Pura Vida Apps
Please give credit and add a link to the source… this is how the internet works… Thank you!

see also my license:

This work by Pura Vida Apps is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License with attribution (name=Pura Vida Apps and link to the source site) required.

Why it’s a good idea to give credit by Corey Wainwright.

Also you might want to follow the naming conventions… which are UpperCamelCase for property, method and event names (i.e. the first letter should be a capital letter) and lowerCamelCase for parameter names, i.e. no underscores

naming

Unbenannt

Keep up the good work!
Taifun

2 Likes

Take it just as a suggestion…
As I can see you are using AIA of jobworld app made by Sanjay Dey I would like to tell you that there are a lot of bugs in that AIA.
Just a suggestion…:sunglasses:

1 Like

thank you sir, now i understand

yes sir, i learn thats aia. how to crud with webmysql with login system, next ill learn with fire base,

Please help me

Ok, let me help you. Read this: How to ask a question?

3 Likes

I have problems running a simple query:
SELECT * FROM DB_iscritti WHERE CODICE_TESSERA = ‘QR20194’
I put into a Run Query instruction block but it doesn’t return any result.

Where ‘QR20194’ is defined by a TEXT Box

I had the same problem a long time ago. I used the Deephost extension, all its blocks work except the block to make an SQL query, I’ve written to him (Deephost), commented your videos, followed your tutorials that just don’t have the example of SQL queries. I received no response and now I’m using the Taifun tutorial which is great for making SQL queries.

1 Like

Thanks, I Hope he will fix in future

1 Like

I’ve followed Mysql scheme, but i got an error, I can’t undrestand why… :’(

You might want to use the list from csv table block
Taifun

1 Like

But why I get also the names of columns?

1 Like

Column names are also returned at index1.
That’s why you will see most MySql users using for each number from where they set start to 1 to avoid column names.

1 Like

To remove it, convert the csv table into a list of lists and then remove the first item using the remove item from list block
Taifun

1 Like

Fantastic !! Now all things work perfectly!

Ooooops, just another error… I want to update a field with a new value, so I create a block for query, but, even if the field is updated, the app give me an error…




Fix your Web.GotText event and make sure, the php script returns 201 for update queries
Taifun
PS: this is a new question and for new questions please start a new thread next time… Thank you

2 Likes

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.