Databases
StackOverflow2013
Postsdbo
POError parsing data org.json.JSONException: Value <?xml of type java.lang.String cannot be converted to JSONArray
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POError parsing data org.json.JSONException: Value <?xml of type java.lang.String cannot be converted to JSONArray
    primarykey
    data
    text
    <p>I am writing an app intend to run on android devices.The app is supossed to read the information in a Mysql database through php, but when I run the application, Log cat prompts an error 'Error parsing data org.json.JSONException: Value <p>The code I've got was downloaded from a tutorial, please be patient I've got some basic knowledge in php and very few in java. I already tested the php script and it is working flawlessly, so I won't bother to attach it.</p> <p>main.java code:</p> <p><pre> <code></p> package test.an2mysql; 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.apache.http.message.BasicNameValuePair; import org.json.JSONArray; import org.json.JSONException; import org.json.JSONObject; import android.app.Activity; import android.os.Bundle; import android.util.Log; import android.widget.LinearLayout; import android.widget.TextView; public class main extends Activity { /** Called when the activity is first created. */ TextView txt; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); // Create a crude view - this should really be set via the layout resources // but since its an example saves declaring them in the XML. LinearLayout rootLayout = new LinearLayout(getApplicationContext()); txt = new TextView(getApplicationContext()); rootLayout.addView(txt); setContentView(rootLayout); // Set the text and call the connect function. txt.setText("Connecting..."); //call the method to run the data retreival txt.setText(getServerData(KEY_121)); } public static final String KEY_121 = "http://10.1.1.19/cms/test/android2mysql/read.php"; //i use my real ip here private String getServerData(String returnString) { InputStream is = null; String result = ""; //the data to send ArrayList&lt;NameValuePair&gt; nameValuePairs = new ArrayList&lt;NameValuePair&gt;(); nameValuePairs.add(new BasicNameValuePair("country","undefined")); //http post try{ HttpClient httpclient = new DefaultHttpClient(); HttpPost httppost = new HttpPost(KEY_121); 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()); } //convert response to string try{ BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8); StringBuilder sb = new StringBuilder(); String line = null; 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()); } //parse json data try{ JSONArray jArray = new JSONArray(result); for(int i=0;i&lt;jArray.length();i++){ JSONObject json_data = jArray.getJSONObject(i); Log.i("log_tag","id: "+json_data.getInt("id")+ ", country: "+json_data.getString("country")+ ", documentn: "+json_data.getInt("documentn") ); //Get an output to the screen returnString += "\n\t" + jArray.getJSONObject(i); } }catch(JSONException e){ Log.e("log_tag", "Error parsing data "+e.toString()); } return returnString; } } </code></pre> <p>I would kindly appreciate any help you could give me.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAlan Cor
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POError parsing data org.json.JSONException: Value <?xml of type java.lang.String cannot be converted to JSONArray
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POError parsing data org.json.JSONException: Value <?xml of type java.lang.String cannot be converted to JSONArray
      1. USwolverine
      1. VTFavorite
    3. VO
      singulars
      1. POError parsing data org.json.JSONException: Value <?xml of type java.lang.String cannot be converted to JSONArray
      1. This table or related slice is empty.
      1. VTUpMod
    1. COGoing on the title of you question.. it looks like your trying to parse xml when your code is expecting JSON
      singulars
      1. POError parsing data org.json.JSONException: Value <?xml of type java.lang.String cannot be converted to JSONArray
      1. USkmb64
    2. CO@user1350102: **"I already tested the php script and it is working flawlessly..."** - I beg to differ. The php script may be returning 'something' but it's not working "flawlessly". From your question title, as nz_karl suggests, `<?xml` is the start of an XML declaration which means your php script is returning XML data and not pure JSON.
      singulars
      1. POError parsing data org.json.JSONException: Value <?xml of type java.lang.String cannot be converted to JSONArray
      1. USSquonk
    3. COam also getting the same problem.. when i try to parse the json url am getting same error..
      singulars
      1. POError parsing data org.json.JSONException: Value <?xml of type java.lang.String cannot be converted to JSONArray
      1. USwolverine
 

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