This may be a dumb question. But I need your help. I'm new to programming and I'm developing an android app to get data from remote MySQL Server. I know there are several post regarding several methods to connect MySQL databases. Previously I used mysql library to direct connect MySQL Databases for several project but as I know, It is less secure.
For example,
B4X:
Dim mh1 As MysqlHandler
Dim rs1 As ResultSet
mh1.Initialize("remort server ip","db name","username","password")
rs1=mh1.Query("SELECT * FROM db ")
As I mentioned above, I'm new to programming. I'm beginner for this. I'm having Wordpress host which support remote mysql connection. In Erels tutorial he used Local host with XAMP and run jRDC2 in local pc. I'm confusing because I want to connect my wordpress host with my mobile app. By using mysql library I can do it. But I want a better, fast and secure way to do it.
Please be kind enough to show me the correct way to do it.