Solved

Android user log in and database communication suggestions

Posted on 2010-08-22
2
522 Views
Last Modified: 2012-05-10
Hi!

Im developing a google maps app, which gets coordinates from a MySQL database. The application should require a user to login to get its coordinates. It would be preferable if the user could use the login on for example a regular web page.
I really have no idea how to do this, suggestions?

Suggestion on user login solutions?
Suggestion on best way to get info from MySQL database?

Thank you!
0
Comment
Question by:o3h
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 33494715
I have only had an Android device for a very short while so I haven't done much development there yet, but I will chime in from the Java and general web application perspective until you get other Experts posting.

Since you typically want to keep load off of the mobile devices to not bog down memory, you could setup a REST web service or simply emulate this using a servlet. Might want to look at projects like Hibernate also. This will allow you to do all the heavy database lifting on the server end and all you pass back is the coordinates.

Now following on this thought, you can have this web service require user credentials to function. Again, you can handle the verification of username and hashed password in the service. This would allow you to have just a couple text boxes on the front end app on the phone (Android device) with minimal code maybe to handle the hashing of password before sending across the cloud. Alternatively, you can have this too on a web page and the Android client is simply a web-based app being browsed on the devices Internet browser.

Just my $0.02 anyway!
0
 
LVL 60

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 33494722
This may be helpful as it shows how the HTTPClient piece works and given that you may have your MySQL server hosted on a LAMP stack then might be a good resource to create the data accessor "service" pieces in PHP.

http://www.helloandroid.com/tutorials/connecting-mysql-database
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this post we will learn different types of Android Layout and some basics of an Android App.
If you use the Google Now Launcher, as an aftermarket add on, have a Samsung Note 5 and are worried about power consumption be wary of using the ultra power saving mode.  Here is what happened to me when I made the mistake of trying this out...
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
This video is in connection to the article "The case of a missing mobile phone (https://www.experts-exchange.com/articles/28474/The-Case-of-a-Missing-Mobile-Phone.html)". It will help one to understand clearly the steps to track a lost android phone.
Suggested Courses

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question