Load data into listview from database android

Question

I'm trying to load the table from mysql/localhost database using php to android. I have written the jason code as following.

 try {
            // convert json string to json array
            JSONArray aJson = new JSONArray(sJson);
            // create apps list
            List<Application> apps = new ArrayList<Application>();

            for(int i=0; i<aJson.length(); i++) {
                JSONObject json = aJson.getJSONObject(i);
                Application app = new Application();
                app.setTitle(json.getString("number"));
                app.setTotalDl(Long.parseLong(json.getString("speed")));
                //app.setRating(Integer.parseInt(json.getString("rating")));  
                //app.setIcon(json.getString("icon"));

                // add the app to apps list
                apps.add(app);
            }

            //notify the activity that fetch data has been complete
            if(listener != null) listener.onFetchComplete(apps);
        } catch (JSONException e) {
            msg = "Invalid response";
            if(listener != null) listener.onFetchFailure(msg);
            return;
        }

There you can see my php file.

<?php

//connect to the db

$host="localhost"; // Host name 
$user="root"; // Mysql username 
$pswd=""; // Mysql password 
$db="gpsvts_geotrack"; // Database name 
 // Table name



$conn = mysqli_connect($host,$user,$pswd,$db);

//mysql_select_db($db, $conn);
//run the query to search for the username and password the match
//$query = "SELECT * FROM "."  ".$tbl_name. "  "."WHERE uname = '$myusername' AND passwd= '$mypassword' ";
$query = "select user_master.uid,device_locator_tbl.imei,device_locator_tbl.speed,device_locator_tbl.datetime,device_locator_tbl.number,device_master.icon 
from device_locator_tbl,device_master,device_registration,user_master where user_master.uid=device_registration.uid
 AND device_registration.imei=device_master.imei AND device_registration.imei=device_locator_tbl.imei AND user_master.uid=126";
//$query = "SELECT uid FROM $tbl_name WHERE uname = '$un' AND passwd = '$pw'";
$result = mysqli_query($conn,$query) or die("Unable to verify user because : " );
//this is where the actual verification happens

if($row = mysqli_fetch_array($result))
//echo mysql_result($result,0);  // for correct login response
{

 $rows[] = $row; 
 }
 // close the database connection
mysqli_close($con);

// echo the application data in json format
echo json_encode($rows);
?>

Here i set the path correctly. I want to add those table details into listview. When run the app listview is loaded. But data are not loaded. Always I got the error message "invalid response". I want to correct it. How to do that?

user1724537 · Accepted Answer · 2013-07-12 05:50:49Z

if you are using mysql as database update server code like this

<?php

//connect to the db

$host="localhost"; // Host name 
$user="root"; // Mysql username 
$pswd=""; // Mysql password 
$db="gpsvts_geotrack"; // Database name 
$conn = mysql_connect($host,$user,$pswd);
mysql_select_db($db, $conn);
$query = "select user_master.uid,device_locator_tbl.imei,device_locator_tbl.speed,device_locator_tbl.datetime,device_locator_tbl.number,device_master.icon 
from device_locator_tbl,device_master,device_registration,user_master where user_master.uid=device_registration.uid
 AND device_registration.imei=device_master.imei AND device_registration.imei=device_locator_tbl.imei AND user_master.uid=126";
//$query = "SELECT uid FROM $tbl_name WHERE uname = '$un' AND passwd = '$pw'";
$result = mysql_query($conn,$query) or die("Unable to verify user because : " );


if($row = mysql_fetch_array($result))

{

 $rows[] = $row; 
 }

mysql_close($con);

// echo the application data in json format
echo json_encode($rows);
?>

Collectives™ on Stack Overflow

Load data into listview from database android

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related