How to retrieve data using json into mysql android

Question

I want to retrieve data from user table using username but it cannot work properly here is my php code:

<?php

mysql_connect("xxx","xxx","xxx");
mysql_select_db("xxx");

$username = $_POST["name"];

$sql = mysql_query("select * from user where username = '$username'");

$flag["code"] = 0;

$check = mysql_fetch_row($sql);
if ($check > 0)
{
    $flag["code"] = 1;
    echo json_encode($flag);    

    while ($row= mysql_fetch_assoc($sql)) 
    {
        $output[] = $row;
    }
}

echo json_encode($output);
mysql_close();

?>

And here is my Java code:

  try
  {
     JSONObject json = new JSONObject(result);
     code = (json.getInt("code"));

if (code == 1)
{
    JSONArray array = new JSONArray(result);

    for (int i = 0; i < array.length(); i++)
    {
        JSONObject jsonObject = array.getJSONObject(i);
        firstname = jsonObject.getString("firstname");

        et.setText(firstname);
    }
}
}
catch (Exception e)
{

}

Here is result:

try
        {
            BufferedReader reader = new BufferedReader(new InputStreamReader(is, HTTP.UTF_8),8);
            StringBuilder sb = new StringBuilder();

            while ((line = reader.readLine()) != null)
            {
                sb.append(line+"\n");
            }

            is.close();

            result = sb.toString();

            Toast.makeText(getApplicationContext(), result, Toast.LENGTH_LONG).show();
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }

There is no error but it cannot retrieve any data what is the problem ?

Where is the part of result = ?? or what is the output of result? — lukesUbuntu
– lukesUbuntu, Commented Mar 19, 2015 at 1:54

Sagar Devkota · Accepted Answer · 2015-03-19 02:47:49Z

1

Please return json object from php not Array i have channged echo part to json_encode(array('response'=>$output,'code'=>$flag["code"]));

<?php

mysql_connect("xxx","xxx","xxx");
mysql_select_db("xxx");

$username = $_POST["name"];

$rs = mysql_query("select * from user where username = '$username'");


$flag["code"] = 0;

$check = mysql_num_rows($rs);
if ($check > 0)
{
    $flag["code"] = 1;


    while ($row= mysql_fetch_array($rs)) 
    {
        $output[] = $row;
    }
}

echo json_encode(array('response'=>$output,'code'=>$flag["code"])); //changed here
mysql_close();

?>

Now in java,

try
  {
     JSONObject json = new JSONObject(result);
     code = (json.getInt("code"));

if (code == 1)
{
    JSONArray array = json.getJSONArray('response');

    for (int i = 0; i < array.length(); i++)
    {
        JSONObject jsonObject = array.getJSONObject(i);
        firstname = jsonObject.getString("firstname");

        et.setText(firstname);
    }
}
}
catch (Exception e)
{

}

If it fails JSONObject json = new JSONObject(result); is not required because result is already json object. just remove that line and change all json variables to result.

edited Mar 19, 2015 at 2:47

answered Mar 19, 2015 at 2:17

Sagar Devkota

1,1928 silver badges13 bronze badges

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

8 Comments

lukesUbuntu Over a year ago

you should be using mysqli over mysql. but good solution this will def tell him if hes getting results +1

Orgil Over a year ago

Did not change anything response says null

Sagar Devkota Over a year ago

can you tell me the type of result. String or JSONObject ?

Orgil Over a year ago

The type of result is String and it gets JSONObject data which is converted into String

Orgil Over a year ago

Same as before result is null :(

|

Orgil · Accepted Answer · 2015-03-19 03:19:03Z

0

I've just solved the problem result didn't work in other words it cannot get data by array and i just put array function now it works fine :-)

answered Mar 19, 2015 at 3:19

Orgil

7118 silver badges18 bronze badges

Collectives™ on Stack Overflow

How to retrieve data using json into mysql android

2 Answers 2

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related