How to get from a MySql server to an Android app?

Question

I have a MySql database with some sports results in it. I want to write an Android application to display these data on mobile phones.

I´ve searched on the internet for this issue, and I think it is not possible to have a direct connection between the MySql database and the Android application. (Is this right?)

So my question is the following: How can I have access in the android application to the MySql database in order to display some of the data?

score 11 · Answer 1 · answered Nov 05 '10 at 23:32

Try this method out. I will be using this method for the current project i am working on.

You basically create a php script on a server and use http posts to send the data to the script, read the tutorial linked below for better explanation.

mysql/android tutorial

score 7 · Accepted Answer · answered May 24 '10 at 17:34

7

You may want to look at C2DM (http://code.google.com/android/c2dm/).

A common way is to write a REST web service and have Android call that and get the data from the server.

If you want to push it, if the data is small enough, you could use SMS and just send the data as a text message to the device.

You don't want to open access to your database so by using the web service you can better protect your database.

answered May 24 '10 at 17:34

James Black

41,583
10
86
166

1

I second the REST web interface method – HXCaine May 24 '10 at 22:53
C2DM has been officially deprecated as of June 26, 2012 https://developers.google.com/android/c2dm/?hl=no – teecee Mar 31 '13 at 15:25
@Thundercat - Thank you for that. I have never needed to use C2DM so I don't keep up with it. I tried to give several different options. – James Black Apr 01 '13 at 01:07
@Thundercat so what is the current method for this approach? – Juan Gonzales Sep 08 '13 at 23:38

score 3 · Answer 3 · edited Jul 07 '12 at 18:03

There are many approaches to this, but I would use an SOA.

Your mobile application will need to follow a typical service-oriented architecture (SOA) and will need three distinct elements: an external database; a web-service; and a mobile web-service client.

You will need to create a web-service using something like Java EE that receives a request from the locally installed android application, and responds with the required data from the external MySql database.

I am using the KSOAP for android libraries to do this, but should ideally be using REST.

score 2 · Answer 4 · edited Dec 05 '13 at 12:37

2

Step by step procedure for using Mysql to store data in local machine using android to enter data

Android Connecting to MySQL, PHP

This is one of the simplest tutorials on the net regarding data flow from your Android app to PHP script then finally is stored in your MySQL database.

Hope it helps

edited Dec 05 '13 at 12:37

Minion

565
1
7
23

answered Jun 21 '13 at 04:53

Devrath

42,072
54
195
297

How to get from a MySql server to an Android app?

4 Answers4

Linked

Related