Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • errror come on run time to connect my android app with mysql

    @androidlearner
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 4
    • 0
    • 0
    • 0
    • 724
    Answer it

    my code this AllProductsActivity Class

    public class AllProductsActivity extends ListActivity {

    // Progress Dialog
private ProgressDialog pDialog;

// Creating JSON Parser object
JSONParser jParser = new JSONParser();

ArrayList<HashMap<String, String>> productsList;

// url to get all products list
private static String url&#95;all&#95;products = "http://192.168.56.1/android&#95;connect/get&#95;all&#95;products.php";

// JSON Node names
private static final String TAG&#95;SUCCESS = "success";
private static final String TAG&#95;PRODUCTS = "products";
private static final String TAG&#95;PID = "pid";
private static final String TAG&#95;NAME = "name";

// products JSONArray
JSONArray products = null;

@Override
public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.all&#95;products);

    // Hashmap for ListView
    productsList = new ArrayList<HashMap<String, String>>();

    // Loading products in Background Thread
    new LoadAllProducts().execute();

    // Get listview
    ListView lv = getListView();

    // on seleting single product
    // launching Edit Product Screen
    lv.setOnItemClickListener(new OnItemClickListener() {

        @Override
        public void onItemClick(AdapterView<?> parent, View view,
                                int position, long id) {
            // getting values from selected ListItem
            String pid = ((TextView) view.findViewById(R.id.pid)).getText()
                    .toString();

            // Starting new intent
            Intent in = new Intent(getApplicationContext(),
                    EditProductActivity.class);
            // sending pid to next activity
            in.putExtra(TAG&#95;PID, pid);

            // starting new activity and expecting some response back
            startActivityForResult(in, 100);
        }
    });

}

// Response from Edit Product Activity
@Override
protected void onActivityResult(int requestCode, int resultCode, Intent data) {
    super.onActivityResult(requestCode, resultCode, data);
    // if result code 100
    if (resultCode == 100) {
        // if result code 100 is received
        // means user edited/deleted product
        // reload this screen again
        Intent intent = getIntent();
        finish();
        startActivity(intent);
    }

}

/**
 * Background Async Task to Load all product by making HTTP Request
 * */
class LoadAllProducts extends AsyncTask<String, String, String> {

    /**
     * Before starting background thread Show Progress Dialog
     * */
    @Override
    protected void onPreExecute() {
        super.onPreExecute();
        pDialog = new ProgressDialog(AllProductsActivity.this);
        pDialog.setMessage("Loading products. Please wait...");
        pDialog.setIndeterminate(false);
        pDialog.setCancelable(false);
        pDialog.show();
    }

    /**
     * getting All products from url
     * */
    protected String doInBackground(String... args) {
        // Building Parameters
        List<NameValuePair> params = new ArrayList<NameValuePair>();
        // getting JSON string from URL
        JSONObject json = jParser.makeHttpRequest(url&#95;all&#95;products, "GET", params);

        // Check your log cat for JSON reponse
        Log.d("All Products: ", json.toString());

        try {
            // Checking for SUCCESS TAG
            int success = json.getInt(TAG&#95;SUCCESS);

            if (success == 1) {
                // products found
                // Getting Array of Products
                products = json.getJSONArray(TAG&#95;PRODUCTS);

                // looping through All Products
                for (int i = 0; i < products.length(); i++) {
                    JSONObject c = products.getJSONObject(i);

                    // Storing each json item in variable
                    String id = c.getString(TAG&#95;PID);
                    String name = c.getString(TAG&#95;NAME);

                    // creating new HashMap
                    HashMap<String, String> map = new HashMap<String, String>();

                    // adding each child node to HashMap key => value
                    map.put(TAG&#95;PID, id);
                    map.put(TAG&#95;NAME, name);

                    // adding HashList to ArrayList
                    productsList.add(map);
                }
            } else {
                // no products found
                // Launch Add New product Activity
                Intent i = new Intent(getApplicationContext(),
                        NewProductActivity.class);
                // Closing all previous activities
                i.addFlags(Intent.FLAG&#95;ACTIVITY&#95;CLEAR&#95;TOP);
                startActivity(i);
            }
        } catch (JSONException e) {
            e.printStackTrace();
        }

        return null;
    }

    /**
     * After completing background task Dismiss the progress dialog
     * **/
    protected void onPostExecute(String file&#95;url) {
        // dismiss the dialog after getting all products
        pDialog.dismiss();
        // updating UI from Background Thread
        runOnUiThread(new Runnable() {
            public void run() {
                /**
                 * Updating parsed JSON data into ListView
                 * */
                ListAdapter adapter = new SimpleAdapter(
                        AllProductsActivity.this, productsList,
                        R.layout.list&#95;item, new String[] { TAG&#95;PID,
                        TAG&#95;NAME},
                        new int[] { R.id.pid, R.id.name });
                // updating listview
                setListAdapter(adapter);
            }
        });

    }

}

    }

    My JsonParsert Classis here

    public class JSONParser {

    static InputStream is = null;
static JSONObject jObj = null;
static String json = "";


// constructor
public JSONParser() {

}

// function get json from url
// by making HTTP POST or GET mehtod
public JSONObject makeHttpRequest(String url, String method,
                                  List<NameValuePair> params) {

    is = null;
    jObj = null;
    json = "";


    // Making HTTP request
    try {

        Log.i("url", "http://www.google.com");

        // check for request method
        if(method == "POST"){
            // request method is POST
            // defaultHttpClient
            DefaultHttpClient httpClient = new DefaultHttpClient();
            String paramString = URLEncodedUtils.format(params, "utf-8");
            url += "?" + paramString;
            Log.i("url", url);
            HttpPost httpPost = new HttpPost(url);

            HttpResponse httpResponse = httpClient.execute(httpPost);
            HttpEntity httpEntity = httpResponse.getEntity();
            is = httpEntity.getContent();

        }else if(method == "GET"){
            // request method is GET
            DefaultHttpClient httpClient = new DefaultHttpClient();
            String paramString = URLEncodedUtils.format(params, "utf-8");
            url += "?" + paramString;
            Log.i("url", url);
            HttpGet httpGet = new HttpGet(url);

            HttpResponse httpResponse = httpClient.execute(httpGet);
            HttpEntity httpEntity = httpResponse.getEntity();
            is = httpEntity.getContent();
        }
    } catch (UnsupportedEncodingException e) {
        e.printStackTrace();
    } catch (ClientProtocolException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }


    Log.i("Stage 1", "Stage 1");

    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");

                Log.i("1 ", line);
        }
        is.close();
        json = sb.toString();
    } catch (Exception e) {
        Log.e("Buffer Error", "Error converting result " + e.toString());
    }

    Log.i("Stage 2", "Stage 2");

    // try parse the string to a JSON object
    try {
        jObj = new JSONObject(json);
    } catch (JSONException e) {
        Log.e("JSON Parser", "Error parsing data " + e.toString());
    }

    Log.i("Stage 3", "Stage 3");

    // return JSON String
    return jObj;

}

    }

    Logcat error

    10-13 08:43:41.685: E/AndroidRuntime(1354): FATAL EXCEPTION: AsyncTask #1 10-13 08:43:41.685: E/AndroidRuntime(1354): Process: gurudev.additem, PID: 1354 10-13 08:43:41.685: E/AndroidRuntime(1354): java.lang.RuntimeException: An error occured while executing doInBackground() 10-13 08:43:41.685: E/AndroidRuntime(1354): at android.os.AsyncTask$3.done(AsyncTask.java:300) 10-13 08:43:41.685: E/AndroidRuntime(1354): at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:355) 10-13 08:43:41.685: E/AndroidRuntime(1354): at java.util.concurrent.FutureTask.setException(FutureTask.java:222) 10-13 08:43:41.685: E/AndroidRuntime(1354): at java.util.concurrent.FutureTask.run(FutureTask.java:242) 10-13 08:43:41.685: E/AndroidRuntime(1354): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1112) 10-13 08:43:41.685: E/AndroidRuntime(1354): at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:587) 10-13 08:43:41.685: E/AndroidRuntime(1354): at java.lang.Thread.run(Thread.java:841) 10-13 08:43:41.685: E/AndroidRuntime(1354): Caused by: java.lang.NoSuchMethodError: org.apache.http.impl.client.DefaultHttpClient.execute 10-13 08:43:41.685: E/AndroidRuntime(1354): at gurudev.additem.JSONParser.makeHttpRequest(JSONParser.java:77) 10-13 08:43:41.685: E/AndroidRuntime(1354): at gurudev.additem.AllProductsActivity$LoadAllProducts.doInBackground(AllProductsActivity.java:128) 10-13 08:43:41.685: E/AndroidRuntime(1354): at gurudev.additem.AllProductsActivity$LoadAllProducts.doInBackground(AllProductsActivity.java:1) 10-13 08:43:41.685: E/AndroidRuntime(1354): at android.os.AsyncTask$2.call(AsyncTask.java:288) 10-13 08:43:41.685: E/AndroidRuntime(1354): at java.util.concurrent.FutureTask.run(FutureTask.java:237) 10-13 08:43:41.685: E/AndroidRuntime(1354): ... 3 more

    Android mysql PHP
    Answer it

 4 Answer(s)

  • @androidlearner
    Recommendations Offline Message

    about 9 years ago

    query("SELECT *FROM products")){ if($count = $result->num_rows){ $response["products"] = array(); while($row = $result->fetch_object()){ $product = array(); $product["pid"] = $row->pid; $product["name"] = $row->name; $product["price"] = $row->price; $product["description"] = $row->description; $product["created_at"] = $row->created_at; $product["updated_at"] = $row->updated_at; array_push($response["products"], $product); } $response["success"] = 1; // echoing JSON response echo json_encode($response); // echo $response["products"]; } $result->free(); } else { // no products found $response["success"] = 0; $response["message"] = "No products found"; // echo no users JSON echo json_encode($response); } ?>
Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: