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
@alexitoo_uy 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…
Is based on your MySQL script from what I saw
@alexitoo_uy 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…
@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
Keep up the good work!
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…
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,
Ok, let me help you. Read this: How to ask a question?
I have problems running a simple query:
SELECT * FROM
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.
Thanks, I Hope he will fix in future
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
But why I get also the names of columns?
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.
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
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
PS: this is a new question and for new questions please start a new thread next time… Thank you
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.