Android Question How to connect MySql database to B4A

[Somvx]

hello....
i have a Pharmacy project and it requires database I used MySql to create the database.

I don't know how to connect the database to B4A ...and I don't know how the database will be presented before the exportation to B4A.


I have attached the database written in a text file along with the program (it's only layouts designing) and I also attached the ER and Mapping for database.

I hope you can help me to connect the database to the program.

you can download the files from here:
https://db.tt/aEU5778X

 

[giga]

You will need to look at the tutorial for MySQL:

http://www.b4x.com/android/forum/threads/connect-android-to-mysql-database-tutorial.8339/#content

and

http://www.b4x.com/android/forum/threads/remote-database-connector-connect-to-any-remote-db.31540/

these should give you a good starting point.

Good Luck.

 

[Somvx]

hi

the first link it's for PHP database connection

the other one is for Remote Database -Server connection-

my database is a local database and i want to Merge it with program.

i'm new here i can't figure out what I need and discard what I don't from the previous links.

I hope you can help me with that

thanks

 

[DonManfred]

Your Database is local you wrote. You have an MySQL-Server running on your Android???? <- THAT would be "a local database"...
Normally the RDC and PHP-Variants of connecting to mysql are correct...

Maybe you should explain more what exactly you want to do.

 

[Somvx]

No , should I );
than how to link it to outer server?

i don't know how to configure my database with the previous links .

I have attached all my work here you can have a closer look at it :
https://db.tt/aEU5778X

 

[DonManfred]

To get a connection to an remote server you have to use one of the above Solutions...

If the server with the mysql-server is accessible with PHP then you can write your own bridge to mysql with php like in first link. If dont have php on this server you have to setup a RDC. Last requires that the server is a windows-machine or the server can start java-programs...

Search for RDC and try to set it up