Android: Sending data to be stored in MySQL

Question

Solved: Was missing view parameter for postData(), changed to reflect this.

I would like some help with sending GPS data to a server which will be stored in a MySQL database using PHP.

This is inside my Java file:

ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>(2);

public void postData(View v)
{
    nameValuePairs.add(new BasicNameValuePair("Lat","19.80"));
    nameValuePairs.add(new BasicNameValuePair("Lon","13.22"));

    //http post
    try{
        HttpClient httpclient = new DefaultHttpClient();
        HttpPost httppost = new      
        HttpPost("http://www.xxxxxxxx.com/test.php");
        httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
        HttpResponse response = httpclient.execute(httppost);
        HttpEntity entity = response.getEntity();
        InputStream is = entity.getContent();
        Log.i("postData", response.getStatusLine().toString());
    }

    catch(Exception e)
    {
        Log.e("log_tag", "Error in http connection "+e.toString());
    }           
}

And my PHP:

<?php
include 'connect.php'; //Connect

//retrieve the data
$lat = $_POST['lat'];
$lon = $_POST['lon'];

$sql = "INSERT INTO Coords (Lat, Lon) VALUES('$lat', '$lon')";

if (!mysql_query($sql, $sqlCon))
{
    die('Error: ' . mysql_error());
}
else
{
    //echo "1 record added";
}

include 'closeConnection.php';
?>

StackTrace: Project - Heat [Android Application]

 02-06 00:37:14.265: ERROR/AndroidRuntime(1607): FATAL EXCEPTION: main
 02-06 00:37:14.265: ERROR/AndroidRuntime(1607): java.lang.IllegalStateException: Could       
 not find a method **postData(View)** in the activity class com.nathanhunston.heat.Main for   
 onClick handler on view class android.widget.Button with id 'dropLocBtn'

You should check your logcat output and post the stacktrace here. — dave.c
– dave.c, Commented Feb 6, 2011 at 0:06
@dave.c Posted the trace, from what I can see right away I have an illegalStateException, so something to do with the virtual machine not being in the correct state.... — nhunston
– nhunston, Commented Feb 6, 2011 at 0:22
I don't think that's your log logcat output. You can use either the view in eclipse, or the standalone tool to get the output. Have a look at this link for details. — dave.c
– dave.c, Commented Feb 6, 2011 at 0:29
@dave.c yeah you were right my logcat had broken when the emulator crashed, ill post the log now. — nhunston
– nhunston, Commented Feb 6, 2011 at 0:31

Octavian Helm · Accepted Answer · 2012-01-17 18:52:45Z

5

The first line of your stack trace tells you exactly what you are doing wrong:

02-06 00:37:14.265: ERROR/AndroidRuntime(1607): FATAL EXCEPTION: main
02-06 00:37:14.265: ERROR/AndroidRuntime(1607): java.lang.IllegalStateException: Could not find a method postData(View) in the activity class com.nathanhunston.heat.Main for onClick handler on view class android.widget.Button with id 'dropLocBtn'

That is because you do not have a View parameter in your postData() method declaration.

edited Jan 17, 2012 at 18:52

Octavian Helm

39.6k19 gold badges100 silver badges102 bronze badges

answered Feb 6, 2011 at 0:42

CommonsWare

1.0m195 gold badges2.5k silver badges2.7k bronze badges

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

2 Comments

CommonsWare Over a year ago

@Herly: Yeah, sometimes I wish there were a direct neural interface from LogCat straight to my brain. OTOH, LogCat is rather chatty, and the other voices inside my head will get jealous.

nhunston Over a year ago

And we would want that now would we.

techi.services · Accepted Answer · 2011-02-05 23:57:19Z

0

Have you added <uses-permission android:name="android.permission.INTERNET"></uses-permission> to the manifest.xml?

answered Feb 5, 2011 at 23:57

techi.services

8,5334 gold badges42 silver badges44 bronze badges

3 Comments

nhunston Over a year ago

Yeah, I am trying to send GPS coords to a database to be stored, I can access the location, I am just having a real headache sending any form of data to the server.

techi.services Over a year ago

Yeah what... have you got that line in your manifest? Check the Logcat for a stacktrace under the Debug perspective and post it.

nhunston Over a year ago

Sorry I wasn't clear, yes I have the line in my manifest file.

Community · Accepted Answer · 2017-05-23 10:27:13Z

0

I think you should call it in a thread... if the server hangs a little bit to respond, you get Force close messages...

You can look at this post: Problem with Android HTTP POST

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered Feb 6, 2011 at 0:02

Whiler

8,1065 gold badges37 silver badges57 bronze badges

Comments

user609239 · Accepted Answer · 2011-02-20 13:05:43Z

0

i think the problem is that in line "nameValuePairs.add(new BasicNameValuePair("Lat","19.80"));" you have used Lat and in line $_POST['lat'];, you have used lat. so Lat and lat are different thing. By the way, here is good article, http://androidtheme.wordpress.com/2011/02/20/connect-android-device-to-mysql/. It really works, i hope you like it.

edited Feb 20, 2011 at 13:05

answered Feb 17, 2011 at 6:46

user609239

3,3665 gold badges27 silver badges27 bronze badges

Collectives™ on Stack Overflow

Android: Sending data to be stored in MySQL

4 Answers 4

2 Comments

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related