Android Question the simplest example of connecting to a remote table (reading, saving, updating, deleting data) for a beginner

[Александр]

Thanks to the creators of B4A! I'm a beginner, but I can already create simple Android applications. Please tell me, is the example of direct connection to a remote database working for today? For personal needs, I need a direct connection to a remote database. I did everything according to the instructions, but I get the answer: Completed. Success: false

Connects to the server, but does not load the table

Recommend the simplest example of connecting to a remote table (reading, saving, updating, deleting data) for a beginner.

Sorry for the stupid question. Thank you very much! Good luck to everyone!

 

[aeric]

Please use the < / > button to add your code.

Your JdbcUrl maybe wrong.
You need to put "/<your database name>" at the end.
e.g

Private jdbcUrl As String = "jdbc:mysql://xe5284a6.mysql.ukraine.com.ua/test"

 

[Александр]

Please use the < / > button to add your code.

Your JdbcUrl maybe wrong.
You need to put "/<your database name>" at the end.
e.g

Private jdbcUrl As String = "jdbc:mysql://xe5284a6.mysql.ukraine.com.ua/test"

Thank you very much. Everything is working!!! I'm really grateful to you! Good luck with your projects!!!

 

[aeric]

It is recommended to use jRDC2 server. Try do a search, there are many examples. I also have created a template for server and client.

You can also use PHP web service.

Another option is to use my Web API Template. B4X Client app also available. But this may be more advanced.

My Source Code Compilation

Share My Creation B4X [B4X] User Login App + [B4J] MySQL API Server (Key + Token) [B4X] PokeDex B4A In App Billing Demo User Login + MySQL PHP API B4A Bridge (Reskinned UI) B4i Aco (source code) Todo List (source code) B4J Creating My Own DDNS Solution B4JQuiz - Desktop App JQuiz - API...

www.b4x.com

 

[Александр]

Thanks a lot! I’m already studying examples of how JRDC2 works, but it’s not clear to me how the server and client work. Where should the server be located? How to enable it? First I will teach the basics of how the server works. Thanks for your template options! Sorry for the English, I'm writing with a translator!