Connection between PHP (server) and Android (client) Using HTTP and JSON

The php code will be,

<?php
mysql_connect("localhost");
mysql_select_db("Your_TABLE_name");
$sql=mysql_query("select column_name from TABLE_name");
while($row=mysql_fetch_assoc($sql)) $output[]=$row;
mysql_close();
?>

Android code is very simple,

Connect to server using Httppost,
Using JSON parse data

XML File

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent" >

    <ScrollView
    android:layout_width="wrap_content"
    android:layout_height="wrap_content"
    android:fillViewport="true"
    android:scrollbars="none"
    android:layout_below="@+id/textView1">
        <LinearLayout
            android:orientation="horizontal"
            android:layout_width="wrap_content"
            android:layout_height="0dp"
            android:stretchColumns="1,0,0"
            android:id="@+id/maintable" >
        </LinearLayout>
     
    </ScrollView>
   
</RelativeLayout>

MainJava File

package com.coderzheaven.gettablefromphp;

import java.util.ArrayList;
import java.util.Iterator;

import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;

import android.app.Activity;
import android.graphics.Color;
import android.os.Bundle;
import android.util.Log;
import android.view.View;

import android.widget.LinearLayout;
import android.widget.TableLayout;
import android.widget.TableRow;
import android.widget.TableRow.LayoutParams;
import android.widget.TextView;

public class MainActivity extends Activity {

String data = "";
LinearLayout tl;
TableRow tr;
TextView label,txt;

@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);

tl = (LinearLayout) findViewById(R.id.maintable);

final GetDataFromDB getdb = new GetDataFromDB();
new Thread(new Runnable() {
public void run() {
data = getdb.getDataFromDB();
System.out.println("...HI"+data);

runOnUiThread(new Runnable() {

@Override
public void run() {
ArrayList<Users> users = parseJSON(data);
addData(users);
}
});

}
}).start();
}

public ArrayList<Users> parseJSON(String result) {
ArrayList<Users> users = new ArrayList<Users>();
try {
JSONArray jArray = new JSONArray(result);
for (int i = 0; i < jArray.length(); i++) {
JSONObject json_data = jArray.getJSONObject(i);
Users user = new Users();
user.setName(json_data.getString("category_name"));
users.add(user);
}
} catch (JSONException e) {
Log.e("log_tag", "Error parsing data " + e.toString());
}
return users;
}

void addHeader(){

tr = new TableRow(this);

label = new TextView(this);
label.setText("DATA FROM SERVER");
label.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT,
LayoutParams.WRAP_CONTENT));
label.setPadding(5, 5, 5, 5);
label.setBackgroundColor(Color.RED);
LinearLayout Ll = new LinearLayout(this);
LinearLayout.LayoutParams params = new LinearLayout.LayoutParams(LayoutParams.FILL_PARENT,
LayoutParams.WRAP_CONTENT);
params.setMargins(5, 5, 5, 5);

Ll.addView(label,params);
tr.addView((View)Ll);
        tl.addView(tr, new TableLayout.LayoutParams(
                LayoutParams.FILL_PARENT,
                LayoutParams.WRAP_CONTENT));
}

@SuppressWarnings({ "rawtypes" })
public void addData(ArrayList<Users> users) {

addHeader();
txt = new TextView(this);
for (Iterator i = users.iterator(); i.hasNext();) {

Users p = (Users) i.next();

tr = new TableRow(this);

txt.append(p.getName());
txt.append("  ");
}
LinearLayout Ll = new LinearLayout(this);
LinearLayout.LayoutParams params = new LinearLayout.LayoutParams(LayoutParams.FILL_PARENT,
LayoutParams.WRAP_CONTENT);
params.setMargins(5, 2, 2, 2);

Ll.addView(txt,params);
tr.addView((View)Ll);



        tl.addView(tr, new TableLayout.LayoutParams(
                LayoutParams.FILL_PARENT,
                LayoutParams.WRAP_CONTENT));
}
}

GetDataFromDB.java

package com.coderzheaven.gettablefromphp;

import org.apache.http.client.HttpClient;

import org.apache.http.client.ResponseHandler;

import org.apache.http.client.methods.HttpPost;

import org.apache.http.impl.client.BasicResponseHandler;

import org.apache.http.impl.client.DefaultHttpClient;

public class GetDataFromDB {

public String getDataFromDB() {

try {

HttpPost httppost;

HttpClient httpclient;

httpclient = new DefaultHttpClient();

httppost = new HttpPost(

"http://www.ipottechnologies.com/android/new.php"); 

ResponseHandler<String> responseHandler = new BasicResponseHandler();

final String response = httpclient.execute(httppost,

responseHandler);

return response.trim();

} catch (Exception e) {

System.out.println("ERROR : " + e.getMessage());

return "error";

}

}

}

Users.java

package com.coderzheaven.gettablefromphp;

public class Users {


String name;



public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}


}

Manifest File

<uses-permission android:name="android.permission.INTERNET"/>

Thats all...!!!