Databases
StackOverflow2013
Postsdbo
POAndroid: Sending data to be stored in MySQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAndroid: Sending data to be stored in MySQL
    primarykey
    data
    text
    <p><strong>Solved:</strong> Was missing view parameter for postData(), changed to reflect this.</p> <p>I would like some help with sending GPS data to a server which will be stored in a MySQL database using PHP.</p> <p>This is inside my Java file:</p> <pre><code>ArrayList&lt;NameValuePair&gt; nameValuePairs = new ArrayList&lt;NameValuePair&gt;(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()); } } </code></pre> <p>And my PHP:</p> <pre><code>&lt;?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'; ?&gt; </code></pre> <p>StackTrace: Project - Heat [Android Application]</p> <pre><code> 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' </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USdonfede
    1. USnhunston
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POAndroid: Sending data to be stored in MySQL
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POAndroid: Sending data to be stored in MySQL
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POAndroid: Sending data to be stored in MySQL
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou should check your logcat output and post the stacktrace here.
      singulars
      1. POAndroid: Sending data to be stored in MySQL
      1. USdave.c
    2. CO@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....
      singulars
      1. POAndroid: Sending data to be stored in MySQL
      1. USnhunston
    3. COI 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](http://developer.android.com/guide/developing/debug-tasks.html) for details.
      singulars
      1. POAndroid: Sending data to be stored in MySQL
      1. USdave.c
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload