Android Question Mysql android connection

raphipps2002 said:

I want to be able to read that Mysql and get records from vb but not from b4a.

Click to expand...

So you should ask your question in a vb.net forum and not here. This forum is about questions on how to do something with B4A. Or i am missing something?

Yes. I want my b4a app to read the Mysql i created in vb.net. sorry if that was not clear.

I have read the tutorial about the php script being on the web server but i dont really understand what it means

1 So i have my credentials ; host db name username and password
2 in vb.net i have connection string similar to sqllite on local directory using b4a on android
3 but cant do same on b4a; have connection string to read Mysql. I understand direct read is not possible

It says to put PHP script on webserver. Not really sure how.

I create a mysql db and have access to this via myphpadmin and can see tables, and update data.

And here i am stuck

Thanks

If your sever is able to run java apps then jrdc2 is the correct solution.

https://www.b4x.com/android/forum/t...-rdc-remote-database-connector.61801/#content

A lot of users will say to use https://www.b4x.com/android/forum/t...ation-of-rdc-remote-database-connector.61801/

But as all my MySQL apps are for internal business use only (no play store apps), I personally use the MySQL connection libraries from @DonManfred. there's no messing about and they just work straight out in 5 minutes flat, no uploading of anything, no messing about with server files etc and all my clients are more than happy with my solutions.

Peter Simpson said:

A lot of users will say to use https://www.b4x.com/android/forum/t...ation-of-rdc-remote-database-connector.61801/

But as all my MySQL apps are for internal business use only (no play store apps), I personally use the MySQL connection libraries from @DonManfred. there's no messing about and they just work straight out in 5 minutes flat, no uploading of anything, no messing about with server files etc and all my clients are more than happy with my solutions.

Click to expand...

Peter Simpson said:

A lot of users will say to use https://www.b4x.com/android/forum/t...ation-of-rdc-remote-database-connector.61801/

But as all my MySQL apps are for internal business use only (no play store apps), I personally use the MySQL connection libraries from @DonManfred. there's no messing about and they just work straight out in 5 minutes flat, no uploading of anything, no messing about with server files etc and all my clients are more than happy with my solutions.

Click to expand...

I apologise i am just a novice.

So what you mean is if i copy his code into my b4a app the host port password etc i will be able to read and write records?

Your Android app will act like any other MySQL client, read, write etc everything...

raphipps2002 said:

So what you mean is if i copy his code into my b4a app the host port password etc i will be able to read and write records?

Click to expand...

If your Database is accessible from Outside, yes. But it is suggested not to use this Lib.
Use this instead: https://www.b4x.com/android/forum/threads/jdbcsql-directly-connect-to-remote-databases.84016/

Fair enough