Login to DB and extract info BEST PRACTICE?

Question

I have already framed the connection between the app and the db on my web server using JSON(the app extracts the info using the JSON) although I have second thoughts in this type of connection I have no other way in my experience in Android to securely access the DB.

what I really want is to extract the information from the DB and load a specific XML file for the UI of the app for example:

The user is given a login box that has username and password then using JSON the data is received from a table in the db which is checked within the app and load the corresponding information(that is in the other columns) from the same table.

How to go about doing all this securely and at the same time efficiently?

score 0 · Answer 1 · edited May 23 '17 at 10:25

0

Try this answer Secure HTTP Post in Android for an explanation of how to handle HTTPS in android.

edited May 23 '17 at 10:25

Community

1
1

answered Aug 05 '13 at 13:55

VM4

6,321
5
37
51

So all people use HTTP Post to handle login processes in Android? – Naaz Aug 05 '13 at 13:58
Well that depends, are you accessing your DB through HTTP? – VM4 Aug 05 '13 at 14:03
yes accessing it through HTTP requests and accessing the JSON which is generated by a PHP script – Naaz Aug 05 '13 at 14:06
Well then SSL is the way to go. :) – VM4 Aug 05 '13 at 14:07
I looked at the link and the most accepted answer my namely the "MattC" and my code that I currently implement seems the same and there nothing unique there – Naaz Aug 05 '13 at 15:00
Well do you have SSL set up on the server? – VM4 Aug 05 '13 at 15:04
i think its just the plain Apache HTTP server running nothing special done to it – Naaz Aug 05 '13 at 18:48
Sorry I got it wrong NO ON MY WEBSERVER I'm not using any SSL – Naaz Aug 06 '13 at 06:13

Login to DB and extract info BEST PRACTICE?

1 Answers1