Cannot parse JSON to Java(android)

Question

My PHP file:

<?php
include("ConnectDatabase.php");

$Username = mysql_real_escape_string($_POST['Username']);
$Password = mysql_real_escape_string($_POST['Password']);

$q = mysql_query("SELECT Username, Password FROM Users
                where Username = '".$Username."' and
                Password = '".$Password."'", $con);

if(mysql_num_rows($q) > 0){
    $row = mysql_fetch_assoc($q);
    print json_encode($row);


}else{
    print "0";
}


?>

I tried to parse that by the following to get a value,but it got null values both userJson and passJson:

public void parseJson(String result){

        try{
            JSONArray jArray = new JSONArray(result);
            for(int i=0;i<jArray.length();i++){
                 userJson = jArray.getJSONObject(i).getString("Username").toString();
                 passJson = jArray.getJSONObject(i).getString("Password").toString();   
            }
        }catch(JSONException e){
            Log.e("log_tag", "Error parsing data "+e.toString());
        }

Anyone can see my mistake ? Thank you

PS This is my older post that related to this post.

kharles · Accepted Answer · 2011-07-05 03:07:13Z

3

I would think they end up null cuz the first line doesn't work. It's not a JSONArray as you have generated.

   try {
      JSONObject root = new JSONObject(result);
      username = root.getString("Username");
      password = root.getString("Password");
   } catch (JSONException e) {
      Log.e("log_tag", "Error parsing data "+e.toString());
   }

something like that.

answered Jul 5, 2011 at 3:07

kharles

3265 silver badges14 bronze badges

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

2 Comments

Yoo Over a year ago

Thank you I got its, just re-open Eclipse

Yoo Over a year ago

Can I ask more? I want to know when its need to use JSONArray ? thanks

Collectives™ on Stack Overflow

Cannot parse JSON to Java(android)

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related