Databases
StackOverflow2013
Postsdbo
POAndroid connecting to MySql (PHP Script)
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAndroid connecting to MySql (PHP Script)
    text
    copied!<p>My java code:</p> <pre><code> package com.Cmode.ThesisSystem; import java.io.BufferedReader; import java.io.InputStream; import java.io.InputStreamReader; import java.util.ArrayList; import org.apache.http.HttpEntity; import org.apache.http.HttpResponse; import org.apache.http.NameValuePair; import org.apache.http.client.HttpClient; import org.apache.http.client.entity.UrlEncodedFormEntity; import org.apache.http.client.methods.HttpPost; import org.apache.http.impl.client.DefaultHttpClient; import org.json.JSONArray; import org.json.JSONException; import org.json.JSONObject; import android.app.ListActivity; import android.net.ParseException; import android.os.Bundle; import android.util.Log; import android.widget.Toast; public class EventLogs extends ListActivity { JSONArray jArray; String result = null; InputStream is = null; StringBuilder sb=null; int e_id; String e_name; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); ArrayList&lt;NameValuePair&gt; nameValuePairs = new ArrayList&lt;NameValuePair&gt;();{ //http post try{ HttpClient httpclient = new DefaultHttpClient(); HttpPost httppost = new HttpPost("http://www.my.com/eventlogs.php"); httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs)); HttpResponse response = httpclient.execute(httppost); HttpEntity entity = response.getEntity(); is = entity.getContent(); }catch(Exception e){ Log.e("log_tag", "Error in http connection"+e.toString()); </code></pre> <p>}</p> <pre><code>//convert response to string try{ BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8); sb = new StringBuilder(); sb.append(reader.readLine() + "\n"); String line="0"; while ((line = reader.readLine()) != null) { sb.append(line + "\n"); } is.close(); result=sb.toString(); }catch(Exception e){ Log.e("log_tag", "Error converting result "+e.toString()); } </code></pre> <p>//paring data</p> <pre><code> try{ jArray = new JSONArray(result); JSONObject json_data=null; for(int i=0;i&lt;jArray.length();i++){ json_data = jArray.getJSONObject(i); e_id=json_data.getInt("id"); e_name=json_data.getString("event"); } }catch(JSONException e1){ Toast.makeText(getBaseContext(), "No events found" ,Toast.LENGTH_LONG).show(); } catch (ParseException e1) { e1.printStackTrace(); } } } } </code></pre> <p>I have a problem with this code Error: The application CDroidMonitoring(process.com.Cmode.ThesisSystem) has stopped unexpectedly. Please try again</p> <p>Im just new to android development. I think I have put something unusable braces or there is something wrong in the code.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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