Android connection to mysql Database with php server

Question

I am about to make an app that connect to database and update listview every X seconds (connection via WiFi).

My questions:

Is it a good solution to keep connected app to wifi and update the list eg. every 10 seconds?
What is the easiest way to communicate with database via php scripts? I was looking for this and found example with HttpClient but in Android Studio it says that this is deprecated. Then I found HttpURLConnection but I have got no clue how to use it.

Thanks in advance for your help.

you do NOT want to expose your db to the world at large. use a webservice. — Marc B
– Marc B, Commented Sep 1, 2015 at 20:45

Lal Krishna · Accepted Answer · 2015-10-30 11:59:44Z

1

Try this tutorial:

answered Oct 30, 2015 at 11:59

Lal Krishna

16.4k6 gold badges74 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alfred Woo · Accepted Answer · 2015-09-01 23:06:05Z

0

I think that's not quite good way. That will consume much battery and server's traffic will increase. Try push or increase interval. 10 seconds is too short.
Try this. I use this when I need a connection between server.

answered Sep 1, 2015 at 23:06

Alfred Woo

7261 gold badge8 silver badges25 bronze badges

I forgot to add that the device on which the app is going to run will be connected to AC all the time. What do you mean by "push"?