CODEWITHSUNDEEP
androidmysqljson
Santhosh Kumar
Santhosh Kumar

Reputation: 11

How to retrieve particular row data from mysql through android Volley or JSON?

Hi guys i have already made login and register using volley library and data gets saved successfully as shown in the snap 1 below. Now my question is how to retrieve particular or specific row data for the particular user when he/she logins?? For example if user admin gets logged in how to fetch her entire row alone
saved data in server side saved data in server side

Upvotes: 1

Views: 1410

Answers (3)

Umesh Pithiya
Umesh Pithiya

Reputation: 28

//call volley get method and get data in success method

public void onSuccess(string response) 
{
                try {
                        String s = new String(response);
                        JSONObject jsonObject = new JSONObject(s);

                       if (jsonObject.has("data")) {
                           JSONArray country =jsonObject.getJSONArray("data");
                           for (int i = 0; i < country.length(); i++) {
                            JSONObject cnt = country.getJSONObject(i);
                            String res=cnt.getString("username"));
                           //now you can use res as per your requirement
                        }
                    } catch (JSONException e) {
                   e.printStackTrace();
                } catch (NullPointerException e) {
                e.printStackTrace();
            }
        }

Upvotes: 0

Umesh Pithiya
Umesh Pithiya

Reputation: 28

<?php
    $conn = mysql_connect("localhost", "root", "");
    if(isset($conn))
    {
        mysql_select_db('your_db', $conn);
    }
    else
    {
       echo 'Sorry,can not connect to database' ;
    }

   $userid = isset($_GET['id']) ? mysql_real_escape_string($_GET['id']) :  "";
   $qur = mysql_query("select usename,other_fields from `your_tbl` where userid= $userid");
 $result =array();
    while($r = mysql_fetch_array($qur)){
extract($r);
       $result[] = array("usename" => $usename,"other_fields" => $other_fields); 
}
$json =array("data"=>$result);
mysql_close($conn);
/* Output header */
header('Content-type: application/json');
echo json_encode($json);

Upvotes: 1

Deciphering_Joker
Deciphering_Joker

Reputation: 26

You will have to use server side scripting. Webservice that will fetch that particular row of data. The script should take your input parameters and give you the out put in Json Array or Object.

You then hit this script using volley and the response you receive can then be utilized for the next step.

Upvotes: 0

Related Questions