CODEWITHSUNDEEP
androidmysql
newbie
newbie

Reputation: 83

how to connect android to online database?

MySQL

Server: db4free.net via TCP/IP
Server version: 5.5.12-log
Protocol version: 10
User: alan89@88.198.43.24
MySQL charset: UTF-8 Unicode (utf8)

Web server

Apache/2.2.14 (Ubuntu)
MySQL client version: 5.1.41
PHP extension: mysqli Documentation

This is my online database and the name is imammuda. In the database there is a table named "Testing".

Now, I have 2 applications which are admin and user. Admin needs to login into the database server then update data, while user just retrieves data or tables from the server.

I was stuck here at how to code the bridge between Android and server.

Upvotes: 1

Views: 2419

Answers (1)

Femi
Femi

Reputation: 64700

Well, if you need to communicate directly with the database you can use the MySQL JDBC drivers: there are many many many security problems with embedding direct database access into your app, but that WOULD work (longer dialog at Is it sensible to connect a desktop client directly to MySQL?). You would need to pass the username/password into the app and then you can just use regular JDBC code to talk to the database.

Alternatively you will want to implement some form of HTTP web service to mediate access, perform the necessary data verification and do access control. That is honestly a longer discussion than can be performed in a single answer. As a number of other potential answers describe you will need to look at using HTTP client. Also, you will need to implement a web service in a convenient language: you can see a detailed discussion about writing a database access web service at Writing data into a database using a fully REST web service.

EDIT: interesting option might be http://htsql.org/

Upvotes: 1

Related Questions