Android Question Connect to the database on the server

[Snger]

how Connect to the database mysql from the server
When I have
' database host: ???
' database user: ???
' database name: ???
' database password: ???

 

[teddybear]

This is an example of how to connect to MySQL

JdbcSQL - Directly connect to remote databases

This is a port of B4J jSQL library. The SQL type was renamed to JdbcSQL and ResultSet was renamed to JdbcResultSet, this allows using it together with the SQL library. SQL library - local SQLite databases. JdbcSQL - Any remote SQL database with a supported JDBC driver. MySQL and MS SQL are...

www.b4x.com

 

[DonManfred]

The suggested solution is to setup a JRDC2 on your Server and communicate from your B4A app to the jRDC2.

[B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)

RDC is a middleware server that makes it simple to safely connect clients and remote SQL database servers. jRDC2 is the latest version. All new projects should use this version. jRDC2 is made of two components: - B4J server. The server receives the requests from the clients, issues the SQL...

www.b4x.com

 

[Snger]

but I use and don't work

jdbc:mysql://mysql.site4now.net/index.php?route=/database/structure&db=??????????

 

[DonManfred]

:mysql://mysql.site4now.net/index.php?route=/database/structure&db=??????????

You can NOT USE a PHP-Script in directconnections!

You should use the ip of the machine running mysql in the connectionstring.

 

[Star-Dust]

[B4X] [B4XLib] SD_SQL (direct access to MySQL, MariaDB, MS SQL, FireBird)

Based on @Peter Simpson's code (here), I developed a library that allows you to connect directly to MySql, MsSql (for the moment) databases with B4A and B4J. To be clear, you don't need JRDC to connect to the database located on a server (I am working on a version for b4i, but it is only...

www.b4x.com

 

[aeric]

Here is an example of B4A app connecting to MySQL server using PHP web service/API.

(PHP/MySQL/API) User Login App

Web API Updates: Latest B4XPages user login client apps (using B4J server): https://www.b4x.com/android/forum/threads/project-template-user-login-client-b4x.161914/ Older project: https://www.b4x.com/android/forum/threads/b4j-mysql-api-server-key-token-and-b4x-user-login-apps.126081/...

www.b4x.com

Here is another simple example:

Register User example using OkHttpUtils2

Register User example using OkHttpUtils2 Updates: This project is deprecated. Please check User Login + MySQL PHP API https://www.b4x.com/android/forum/threads/user-login-mysql-php-api.117826/ Introduction This code snippet is based on the thread posted by KMatle in Tutorials &...

www.b4x.com