JFP: java

How to get data from MySQL database to Android app

Java

private static class Product {
    private String name = "" ;
    private String price;
    private String quantity;

public Product( String name, String price, String quantity ) {
        this.name = name ;
        this.price = price ;
        this.quantity = quantity ;
      }

public static ArrayList<product> products;

/**
  * Generate products.
  */
    @TargetApi(Build.VERSION_CODES.GINGERBREAD) @SuppressLint("NewApi") public  static  void generateProducts(){
     String result = "";
     InputStream isr = null;
     products=new ArrayList<product>();
     
     try{
      StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
      StrictMode.setThreadPolicy(policy);
      
      HttpClient httpclient = new DefaultHttpClient();
            HttpPost httppost = new HttpPost("http://10.0.2.2/getdata.php");  
            HttpResponse response = httpclient.execute(httppost);
            HttpEntity entity = response.getEntity();
            isr = entity.getContent();
    }
    catch(Exception e){
            Log.e("log_tag", "Error in http connection "+e.toString());
       
    }
  
     //convert response to string
    try{
     BufferedReader reader = new BufferedReader(new InputStreamReader(isr, "utf-8"), 8);
            StringBuilder sb = new StringBuilder();
            String line = null;
            while ((line = reader.readLine()) != null) {
                    sb.append(line + "\n");
            }
            isr.close();
     
            result=sb.toString();
    }
    catch(Exception e){
            Log.e("log_tag", "Error  converting result "+e.toString());
    }
     
    //parse json data
   try {

JSONArray jArray = new JSONArray(result);
    for(int i=0; i<jArray.length();i++){
   
        JSONObject json = jArray.getJSONObject(i);
        products.add(new Product(json.getString("name"),Float.parseFloat(json.getString("price")), json.getString("quantity")));
      
    
        
    
        
    }
     } catch (Exception e) {
      // TODO: handle exception
      Log.e("log_tag", "Error Parsing Data "+e.toString());
   
      }

}

PHP
connexion.php

getdata.php

How to send data to mysql from android app

How to send data to mysql from android app

android java php

Java

public void insertRecords(String a,String b,String c)
    {
  ArrayList<namevaluepair> nameValuePairs = new ArrayList<namevaluepair>();
            nameValuePairs.add(new BasicNameValuePair("a", a));
            nameValuePairs.add(new BasicNameValuePair("b",b));
            nameValuePairs.add(new BasicNameValuePair("c",c));
            
            sendData(nameValuePairs);
            
    }   
            public void sendData(ArrayList<namevaluepair> data)
            {
             
            
              InputStream is=null;
        
              
              try
              {
                  HttpClient httpclient = new DefaultHttpClient();
                  HttpPost httppost = new HttpPost("http://10.0.2.2/insert.php");
                
                  httppost.setEntity(new UrlEncodedFormEntity(data));
                  
                  HttpResponse response = httpclient.execute(httppost); 
                  HttpEntity entity = response.getEntity();
                  is = entity.getContent();
                  Log.e("pass 1", "connection success ");
              }
              catch(Exception e)
              {
                  Log.e("Fail 1", e.toString());
                  Toast.makeText(getApplicationContext(), "Invalid IP Address",
                  Toast.LENGTH_LONG).show();
              }

String result="";
        try
              {
                  BufferedReader reader = new BufferedReader
                  (new InputStreamReader(is,"iso-8859-1"),8);
                  StringBuilder sb = new StringBuilder();
                  String line;
         while ((line = reader.readLine()) != null)
              {
                      sb.append(line + "\n");
                  }
                  is.close();
                  result = sb.toString();
              Log.e("pass 2", "connection success ");
          }
              catch(Exception e)
          {
                  Log.e("Fail 2", e.toString());
          }     
             
             
             
       }

and call insertRecords(products.get(i).name,products.get(i).price,products.get(i).quantity ) in your button action or where you you want , to add all data

connexion.php

insert.php

class-insert.php

Pages

Axact Blogger Template

How to get data from MySQL database to Android app

How to send data to mysql from android app

How to get data from MySQL database to Android app

Online

Blog Archive

Categories