Cara menghubungkan Android dengan PHP , MySQL

sumber: http://madhusudhanakn.files.wordpress.com/2011/05/android.png

Mungkin sudah banyak blog yang membahas tenang Android dan MySQL menggunakan JSON, tapi apa salahnya saya posting lagi untuk sekedar menambah referensi karena setiap programmer memiliki karakteristik berbeda-beda, mungkin dalam tutorial saya sesuai dengan karakter temen2.



seperti yang terlihat pada gambar diatas bahwa android dapat melakukan proses CRUD(Create, Read, Update dan Delete) dengan database MySQL melalui perantara PHP, jadi tidak bisa secara langsung terhubung dengan MySQL.

untuk membuatnya pertama-tama kita buat database pada MySQL terlebih dahulu.

CREATE DATABASE yyaayyaatt;

CREATE TABLE products( pid int(11) primary key auto_increment, name varchar(100) not null, price decimal(10,2) not null, description text, created_at timestamp default now(), updated_at timestamp );

setelah database dan tabel dibuat, langkah selanjutnya adalah membuat file koneksi database MySQL.

Buatlah sebuah folder dengan nama "koneksi_database" untuk menampung semua file PHP.

file ini berguna untuk membuka dan menutup koneksi dari aplikasi Android terhadap Database yang ada pada Server.

berikut adalah listing codenya:

db_config.php

<?php /*  * All database connection variables  */ define('DB_USER', "root"); // user database define('DB_PASSWORD', ""); // password database (disesuaikan dengan password database masing-masing) define('DB_DATABASE', "yyaayyaatt"); // nama database define('DB_SERVER', "localhost"); // host database ?>

db_connect.php

<?php class DB_CONNECT {     // constructor     function __construct() {         // connecting to database         $this->connect();     }     // destructor     function __destruct() {         // closing db connection         $this->close();     }     function connect() {         // import database connection variables         require_once __DIR__ . '/db_config.php';         // koneksi ke database         $con = mysql_connect(DB_SERVER, DB_USER, DB_PASSWORD) or die(mysql_error());         // Selecing database         $db = mysql_select_db(DB_DATABASE) or die(mysql_error()) or die(mysql_error());         // returing connection cursor         return $con;     }     /**      * Fungsi untuk close koneksi      */     function close() {         mysql_close();     } } ?>

Setelah pembuatan koneksi selesai, sekarang kita menuju ke pembuatan perintah CRUD yang akan digunakan untuk manipulasi data kedalam database MySQL dengan menggunakan Query dasar pada PHP.

buatlah file dengan nama create_product.php dan simpan dalam folder koneksi_database yang sudah dibuat pada langkah awal.

berikut adalah listing codenya:

<?php /*  * Following code will create a new product row  * All product details are read from HTTP Post Request  */ // array for JSON response $response = array(); // check for required fields if (isset($_POST['name']) && isset($_POST['price']) && isset($_POST['description'])) {     $name = $_POST['name'];     $price = $_POST['price'];     $description = $_POST['description'];     // include class database     require_once __DIR__ . '/db_connect.php';     // konek ke database     $db = new DB_CONNECT();     // query untuk menyimpan data     $result = mysql_query("INSERT INTO products(name, price, description) VALUES('$name', '$price', '$description')");     // check if row inserted or not     if ($result) {         // successfully inserted into database         $response["success"] = 1;         $response["message"] = "Product successfully created.";         // echoing JSON response         echo json_encode($response);     } else {         // failed to insert row         $response["success"] = 0;         $response["message"] = "Oops! data gagal di input!!";         // echoing JSON response         echo json_encode($response);     } } else {     // required field is missing     $response["success"] = 0;     $response["message"] = "Required field(s) is missing";     // echoing JSON response     echo json_encode($response); } ?>

listing diatas digunakan untuk menginput data kedalam database, setelah data diinputkan maka untuk mengetahui data dalam database maka kita harus menampilkan datanya.

untuk menampilkan data dari database kita buat file dengan nama get_product_details.php, berdasarkan file pid. berikut ini adalah listing kodenya:

<?php /*  * Following code will get single product details  * A product is identified by product id (pid)  */ // array for JSON response $response = array(); // include db connect class require_once __DIR__ . '/db_connect.php'; // connecting to db $db = new DB_CONNECT(); // check for post data if (isset($_GET["pid"])) {     $pid = $_GET['pid'];     // get a product from products table     $result = mysql_query("SELECT *FROM products WHERE pid = $pid");     if (!empty($result)) {         // check for empty result         if (mysql_num_rows($result) > 0) {             $result = mysql_fetch_array($result);             $product = array();             $product["pid"] = $result["pid"];             $product["name"] = $result["name"];             $product["price"] = $result["price"];             $product["description"] = $result["description"];             $product["created_at"] = $result["created_at"];             $product["updated_at"] = $result["updated_at"];             // success             $response["success"] = 1;             // user node             $response["product"] = array();             array_push($response["product"], $product);             // echoing JSON response             echo json_encode($response);         } else {             // no product found             $response["success"] = 0;             $response["message"] = "No product found";             // echo no users JSON             echo json_encode($response);         }     } else {         // no product found         $response["success"] = 0;         $response["message"] = "No product found";         // echo no users JSON         echo json_encode($response);     } } else {     // required field is missing     $response["success"] = 0;     $response["message"] = "Required field(s) is missing";     // echoing JSON response     echo json_encode($response); } ?>

selanjutnya kita buat file dengan nama get_all_products.php yang akan digunakan untuk menampilkan semua data pada database.

berikut listing kodenya:

<?php /*  * Following code will list all the products  */ // array for JSON response $response = array(); // include db connect class require_once __DIR__ . '/db_connect.php'; // connecting to db $db = new DB_CONNECT(); // get all products from products table $result = mysql_query("SELECT *FROM products") or die(mysql_error()); // check for empty result if (mysql_num_rows($result) > 0) {     // looping through all results     // products node     $response["products"] = array();     while ($row = mysql_fetch_array($result)) {         // temp user array         $product = array();         $product["pid"] = $row["pid"];         $product["name"] = $row["name"];         $product["price"] = $row["price"];         $product["created_at"] = $row["created_at"];         $product["updated_at"] = $row["updated_at"];         // push single product into final response array         array_push($response["products"], $product);     }     // success     $response["success"] = 1;     // echoing JSON response     echo json_encode($response); } else {     // no products found     $response["success"] = 0;     $response["message"] = "No products found";     // echo no users JSON     echo json_encode($response); } ?>

untuk mengubah data yang ada pada database kita buat file dengan nama update_product.php, listing ini  digunakan untuk mengubah data berdasarkan pid produk yang akan diubah.

listing kodenya:

<?php /*  * Following code will update a product information  * A product is identified by product id (pid)  */ // array for JSON response $response = array(); // check for required fields if (isset($_POST['pid']) && isset($_POST['name']) && isset($_POST['price']) && isset($_POST['description'])) {     $pid = $_POST['pid'];     $name = $_POST['name'];     $price = $_POST['price'];     $description = $_POST['description'];     // include db connect class     require_once __DIR__ . '/db_connect.php';     // connecting to db     $db = new DB_CONNECT();     // mysql update row with matched pid     $result = mysql_query("UPDATE products SET name = '$name', price = '$price', description = '$description' WHERE pid = $pid");     // check if row inserted or not     if ($result) {         // successfully updated         $response["success"] = 1;         $response["message"] = "Product successfully updated.";         // echoing JSON response         echo json_encode($response);     } else {     } } else {     // required field is missing     $response["success"] = 0;     $response["message"] = "Required field(s) is missing";     // echoing JSON response     echo json_encode($response); } ?>

dan yang terakhir adalah file class untuk menghapus data pada database, buatlah file dengan nama delete_product.php.

Listing kodenya:

<?php /*  * Following code will delete a product from table  * A product is identified by product id (pid)  */ // array for JSON response $response = array(); // check for required fields if (isset($_POST['pid'])) {     $pid = $_POST['pid'];     // include db connect class     require_once __DIR__ . '/db_connect.php';     // connecting to db     $db = new DB_CONNECT();     // mysql update row with matched pid     $result = mysql_query("DELETE FROM products WHERE pid = $pid");     // check if row deleted or not     if (mysql_affected_rows() > 0) {         // successfully updated         $response["success"] = 1;         $response["message"] = "Product successfully deleted";         // echoing JSON response         echo json_encode($response);     } else {         // no product found         $response["success"] = 0;         $response["message"] = "No product found";         // echo no users JSON         echo json_encode($response);     } } else {     // required field is missing     $response["success"] = 0;     $response["message"] = "Required field(s) is missing";     // echoing JSON response     echo json_encode($response); } ?>

Setelah selesai semua untuk query CRUD diatas, sekarang letakkan folder koneksi_database kedalam direktori htdocs jika kamu menggunakan xampp tapi jika kamu menggunakan appserv maka letakkanlah dalam direktori www.

langkah selanjutnya kita masuk kedalam Pembuatan Aplikasi androidnya.

langkah pertama jalankan Eclipse IDE dan buatlah sebuah project, isikan Activity dengan nama MainScreenActivity dan layout dengan nama main_screen.

desain interface pada file main_screen.xml yang ada pada folder res-layout, buka dan ubah listingnya seperti dibawah ini.

main_screen.xml

<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"     android:layout_width="fill_parent"     android:layout_height="fill_parent"     android:orientation="vertical"     android:gravity="center_horizontal">     <!--  Sample Dashboard screen with Two buttons -->     <!--  Button to view all products screen -->     <Button android:id="@+id/btnViewProducts"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="View Products"         android:layout_marginTop="25dip"/>     <!--  Button to create a new product screen -->     <Button android:id="@+id/btnCreateProduct"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="Add New Products"         android:layout_marginTop="25dip"/> </LinearLayout>

Hasil dari listing diatas adalah seperti dibawah ini.

 



setelah selesai membuat desain interfacenya, sekarang kita masuk ke logic programnya.

buka class MainScreenActivity.java dimana class ini adalah class Activity dari main_screen.xml, dari class ini kita akan memasukkan aksi kedalam button yang dibuat dalam desain interface diatas.

berikut listing kodenya:

MainScreenActivity.java

package com.example.androidhive; import android.app.Activity; import android.content.Intent; import android.os.Bundle; import android.view.View; import android.widget.Button; public class MainScreenActivity extends Activity{     Button btnViewProducts;     Button btnNewProduct;     @Override     public void onCreate(Bundle savedInstanceState) {         super.onCreate(savedInstanceState);         setContentView(R.layout.main_screen);         // Buttons         btnViewProducts = (Button) findViewById(R.id.btnViewProducts);         btnNewProduct = (Button) findViewById(R.id.btnCreateProduct);         // view products click event         btnViewProducts.setOnClickListener(new View.OnClickListener() {             @Override             public void onClick(View view) {                 // Launching All products Activity                 Intent i = new Intent(getApplicationContext(), AllProductsActivity.class);                 startActivity(i);             }         });         // view products click event         btnNewProduct.setOnClickListener(new View.OnClickListener() {             @Override             public void onClick(View view) {                 // Launching create new product activity                 Intent i = new Intent(getApplicationContext(), NewProductActivity.class);                 startActivity(i);             }         });     } }

selanjutnya kita buat user interface untuk menampilkan data dalam database kedalam komponen ListView. untuk menampilkan data kedalam ListView kita membutuhkan dua xml yaitu all_products.xml dan list_item.xml.

listing adalah sebagai berikut:

all_products.xml

<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"     android:layout_width="fill_parent"     android:layout_height="fill_parent"     android:orientation="vertical">     <!-- Main ListView          Always give id value as list(@android:id/list)     -->     <ListView         android:id="@android:id/list"         android:layout_width="fill_parent"         android:layout_height="wrap_content"/> </LinearLayout>

 

list_item.xml

<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"     android:layout_width="fill_parent"     android:layout_height="wrap_content"     android:orientation="vertical" >     <!-- Product id (pid) - will be HIDDEN - used to pass to other activity -->     <TextView         android:id="@+id/pid"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:visibility="gone" />     <!-- Name Label -->     <TextView         android:id="@+id/name"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:paddingTop="6dip"         android:paddingLeft="6dip"         android:textSize="17dip"         android:textStyle="bold" /> </LinearLayout>

buatlah class AllProductsActivity.java,  class ini adalah activity dari all_products.xml yang akan digunakan untuk memasukkan listing kode untuk memanggil dan menampilkan data kedalam ListView.

masukkan listing berikut ini kedalam class AllProductsActiivity.java

AllProductsActivity.java

package com.example.androidhive; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import org.apache.http.NameValuePair; import org.json.JSONArray; import org.json.JSONException; import org.json.JSONObject; import android.app.ListActivity; import android.app.ProgressDialog; import android.content.Intent; import android.os.AsyncTask; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.AdapterView; import android.widget.AdapterView.OnItemClickListener; import android.widget.ListAdapter; import android.widget.ListView; import android.widget.SimpleAdapter; import android.widget.TextView; 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_all_products = "http://api.androidhive.info/android_connect/get_all_products.php";     // JSON Node names     private static final String TAG_SUCCESS = "success";     private static final String TAG_PRODUCTS = "products";     private static final String TAG_PID = "pid";     private static final String TAG_NAME = "name";     // products JSONArray     JSONArray products = null;     @Override     public void onCreate(Bundle savedInstanceState) {         super.onCreate(savedInstanceState);         setContentView(R.layout.all_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_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_all_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_SUCCESS);                 if (success == 1) {                     // products found                     // Getting Array of Products                     products = json.getJSONArray(TAG_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_PID);                         String name = c.getString(TAG_NAME);                         // creating new HashMap                         HashMap<String, String> map = new HashMap<String, String>();                         // adding each child node to HashMap key => value                         map.put(TAG_PID, id);                         map.put(TAG_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_ACTIVITY_CLEAR_TOP);                     startActivity(i);                 }             } catch (JSONException e) {                 e.printStackTrace();             }             return null;         }         /**          * After completing background task Dismiss the progress dialog          * **/         protected void onPostExecute(String file_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_item, new String[] { TAG_PID,                                     TAG_NAME},                             new int[] { R.id.pid, R.id.name });                     // updating listview                     setListAdapter(adapter);                 }             });         }     } }

Jika nanti aplikasi dijalankan maka akan menampilkan data seperti dibawah ini:



buatlah interface add_product.xml yang akan digunakan untuk menginput data produk terbaru kedalam database.

berikut listing kodenya:

add_product.xml

<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"     android:layout_width="match_parent"     android:layout_height="match_parent"     android:orientation="vertical" >     <!-- Name Label -->     <TextView android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="Product Name"         android:paddingLeft="10dip"         android:paddingRight="10dip"         android:paddingTop="10dip"         android:textSize="17dip"/>     <!-- Input Name -->     <EditText android:id="@+id/inputName"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:layout_margin="5dip"         android:layout_marginBottom="15dip"         android:singleLine="true"/>     <!-- Price Label -->     <TextView android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="Price"         android:paddingLeft="10dip"         android:paddingRight="10dip"         android:paddingTop="10dip"         android:textSize="17dip"/>     <!-- Input Price -->     <EditText android:id="@+id/inputPrice"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:layout_margin="5dip"         android:layout_marginBottom="15dip"         android:singleLine="true"         android:inputType="numberDecimal"/>     <!-- Description Label -->     <TextView android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="Description"         android:paddingLeft="10dip"         android:paddingRight="10dip"         android:paddingTop="10dip"         android:textSize="17dip"/>     <!-- Input description -->     <EditText android:id="@+id/inputDesc"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:layout_margin="5dip"         android:layout_marginBottom="15dip"         android:lines="4"         android:gravity="top"/>     <!-- Button Create Product -->     <Button android:id="@+id/btnCreateProduct"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="Create Product"/> </LinearLayout>

buatlah class NewProductActivity.java yang akan menghubungkan dengan layout create_product.xml.

class ini akan digunakan untuk menginput data product baru kedalam database melalui perantara file create_product.php.

Listing kode:

NewProductActivity.java

package com.example.androidhive; import java.util.ArrayList; import java.util.List; import org.apache.http.NameValuePair; import org.apache.http.message.BasicNameValuePair; import org.json.JSONException; import org.json.JSONObject; import android.app.Activity; import android.app.ProgressDialog; import android.content.Intent; import android.os.AsyncTask; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.Button; import android.widget.EditText; public class NewProductActivity extends Activity {     // Progress Dialog     private ProgressDialog pDialog;     JSONParser jsonParser = new JSONParser();     EditText inputName;     EditText inputPrice;     EditText inputDesc;     // url to create new product     private static String url_create_product = "http://api.androidhive.info/android_connect/create_product.php";     // JSON Node names     private static final String TAG_SUCCESS = "success";     @Override     public void onCreate(Bundle savedInstanceState) {         super.onCreate(savedInstanceState);         setContentView(R.layout.add_product);         // Edit Text         inputName = (EditText) findViewById(R.id.inputName);         inputPrice = (EditText) findViewById(R.id.inputPrice);         inputDesc = (EditText) findViewById(R.id.inputDesc);         // Create button         Button btnCreateProduct = (Button) findViewById(R.id.btnCreateProduct);         // button click event         btnCreateProduct.setOnClickListener(new View.OnClickListener() {             @Override             public void onClick(View view) {                 // creating new product in background thread                 new CreateNewProduct().execute();             }         });     }     /**      * Background Async Task to Create new product      * */     class CreateNewProduct extends AsyncTask<String, String, String> {         /**          * Before starting background thread Show Progress Dialog          * */         @Override         protected void onPreExecute() {             super.onPreExecute();             pDialog = new ProgressDialog(NewProductActivity.this);             pDialog.setMessage("Creating Product..");             pDialog.setIndeterminate(false);             pDialog.setCancelable(true);             pDialog.show();         }         /**          * Creating product          * */         protected String doInBackground(String... args) {             String name = inputName.getText().toString();             String price = inputPrice.getText().toString();             String description = inputDesc.getText().toString();             // Building Parameters             List<NameValuePair> params = new ArrayList<NameValuePair>();             params.add(new BasicNameValuePair("name", name));             params.add(new BasicNameValuePair("price", price));             params.add(new BasicNameValuePair("description", description));             // getting JSON Object             // Note that create product url accepts POST method             JSONObject json = jsonParser.makeHttpRequest(url_create_product,                     "POST", params);             // check log cat fro response             Log.d("Create Response", json.toString());             // check for success tag             try {                 int success = json.getInt(TAG_SUCCESS);                 if (success == 1) {                     // successfully created product                     Intent i = new Intent(getApplicationContext(), AllProductsActivity.class);                     startActivity(i);                     // closing this screen                     finish();                 } else {                     // failed to create product                 }             } catch (JSONException e) {                 e.printStackTrace();             }             return null;         }         /**          * After completing background task Dismiss the progress dialog          * **/         protected void onPostExecute(String file_url) {             // dismiss the dialog once done             pDialog.dismiss();         }     } }

Menampilkan data sudah, memasukkan data juga sudah, apalagi yah? :D

owh ia sekarang tinggal mengubah dan menghapus data pada database. buatlah user interface dengan nama edit_product.xml.

berikut listing kodenya:

edit_product.xml

<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"     android:layout_width="match_parent"     android:layout_height="match_parent"     android:orientation="vertical" >     <!-- Name Label -->     <TextView android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="Product Name"         android:paddingLeft="10dip"         android:paddingRight="10dip"         android:paddingTop="10dip"         android:textSize="17dip"/>     <!-- Input Name -->     <EditText android:id="@+id/inputName"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:layout_margin="5dip"         android:layout_marginBottom="15dip"         android:singleLine="true"/>     <!-- Price Label -->     <TextView android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="Price"         android:paddingLeft="10dip"         android:paddingRight="10dip"         android:paddingTop="10dip"         android:textSize="17dip"/>     <!-- Input Price -->     <EditText android:id="@+id/inputPrice"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:layout_margin="5dip"         android:layout_marginBottom="15dip"         android:singleLine="true"         android:inputType="numberDecimal"/>     <!-- Description Label -->     <TextView android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="Description"         android:paddingLeft="10dip"         android:paddingRight="10dip"         android:paddingTop="10dip"         android:textSize="17dip"/>     <!-- Input description -->     <EditText android:id="@+id/inputDesc"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:layout_margin="5dip"         android:layout_marginBottom="15dip"         android:lines="4"         android:gravity="top"/>     <LinearLayout android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:orientation="horizontal">         <!-- Button Create Product -->     <Button android:id="@+id/btnSave"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="Save Changes"         android:layout_weight="1"/>     <!-- Button Create Product -->     <Button android:id="@+id/btnDelete"         android:layout_width="fill_parent"         android:layout_height="wrap_content"         android:text="Delete"         android:layout_weight="1"/>     </LinearLayout> </LinearLayout>

seperti biasa setelah kita membuat user interfacenya sekarang kita buat class activitynya dengan nama EditProductActivity.java.

langsung saja copy listing kode berikut ini:

EditProductActivity.java

package com.example.androidhive; import java.util.ArrayList; import java.util.List; import org.apache.http.NameValuePair; import org.apache.http.message.BasicNameValuePair; import org.json.JSONArray; import org.json.JSONException; import org.json.JSONObject; import android.app.Activity; import android.app.ProgressDialog; import android.content.Intent; import android.os.AsyncTask; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.Button; import android.widget.EditText; public class EditProductActivity extends Activity {     EditText txtName;     EditText txtPrice;     EditText txtDesc;     EditText txtCreatedAt;     Button btnSave;     Button btnDelete;     String pid;     // Progress Dialog     private ProgressDialog pDialog;     // JSON parser class     JSONParser jsonParser = new JSONParser();     // single product url     private static final String url_product_detials = "http://api.androidhive.info/android_connect/get_product_details.php";     // url to update product     private static final String url_update_product = "http://api.androidhive.info/android_connect/update_product.php";     // url to delete product     private static final String url_delete_product = "http://api.androidhive.info/android_connect/delete_product.php";     // JSON Node names     private static final String TAG_SUCCESS = "success";     private static final String TAG_PRODUCT = "product";     private static final String TAG_PID = "pid";     private static final String TAG_NAME = "name";     private static final String TAG_PRICE = "price";     private static final String TAG_DESCRIPTION = "description";     @Override     public void onCreate(Bundle savedInstanceState) {         super.onCreate(savedInstanceState);         setContentView(R.layout.edit_product);         // save button         btnSave = (Button) findViewById(R.id.btnSave);         btnDelete = (Button) findViewById(R.id.btnDelete);         // getting product details from intent         Intent i = getIntent();         // getting product id (pid) from intent         pid = i.getStringExtra(TAG_PID);         // Getting complete product details in background thread         new GetProductDetails().execute();         // save button click event         btnSave.setOnClickListener(new View.OnClickListener() {             @Override             public void onClick(View arg0) {                 // starting background task to update product                 new SaveProductDetails().execute();             }         });         // Delete button click event         btnDelete.setOnClickListener(new View.OnClickListener() {             @Override             public void onClick(View arg0) {                 // deleting product in background thread                 new DeleteProduct().execute();             }         });     }     /**      * Background Async Task to Get complete product details      * */     class GetProductDetails extends AsyncTask<String, String, String> {         /**          * Before starting background thread Show Progress Dialog          * */         @Override         protected void onPreExecute() {             super.onPreExecute();             pDialog = new ProgressDialog(EditProductActivity.this);             pDialog.setMessage("Loading product details. Please wait...");             pDialog.setIndeterminate(false);             pDialog.setCancelable(true);             pDialog.show();         }         /**          * Getting product details in background thread          * */         protected String doInBackground(String... params) {             // updating UI from Background Thread             runOnUiThread(new Runnable() {                 public void run() {                     // Check for success tag                     int success;                     try {                         // Building Parameters                         List<NameValuePair> params = new ArrayList<NameValuePair>();                         params.add(new BasicNameValuePair("pid", pid));                         // getting product details by making HTTP request                         // Note that product details url will use GET request                         JSONObject json = jsonParser.makeHttpRequest(                                 url_product_detials, "GET", params);                         // check your log for json response                         Log.d("Single Product Details", json.toString());                         // json success tag                         success = json.getInt(TAG_SUCCESS);                         if (success == 1) {                             // successfully received product details                             JSONArray productObj = json                                     .getJSONArray(TAG_PRODUCT); // JSON Array                             // get first product object from JSON Array                             JSONObject product = productObj.getJSONObject(0);                             // product with this pid found                             // Edit Text                             txtName = (EditText) findViewById(R.id.inputName);                             txtPrice = (EditText) findViewById(R.id.inputPrice);                             txtDesc = (EditText) findViewById(R.id.inputDesc);                             // display product data in EditText                             txtName.setText(product.getString(TAG_NAME));                             txtPrice.setText(product.getString(TAG_PRICE));                             txtDesc.setText(product.getString(TAG_DESCRIPTION));                         }else{                             // product with pid not found                         }                     } catch (JSONException e) {                         e.printStackTrace();                     }                 }             });             return null;         }         /**          * After completing background task Dismiss the progress dialog          * **/         protected void onPostExecute(String file_url) {             // dismiss the dialog once got all details             pDialog.dismiss();         }     }     /**      * Background Async Task to  Save product Details      * */     class SaveProductDetails extends AsyncTask<String, String, String> {         /**          * Before starting background thread Show Progress Dialog          * */         @Override         protected void onPreExecute() {             super.onPreExecute();             pDialog = new ProgressDialog(EditProductActivity.this);             pDialog.setMessage("Saving product ...");             pDialog.setIndeterminate(false);             pDialog.setCancelable(true);             pDialog.show();         }         /**          * Saving product          * */         protected String doInBackground(String... args) {             // getting updated data from EditTexts             String name = txtName.getText().toString();             String price = txtPrice.getText().toString();             String description = txtDesc.getText().toString();             // Building Parameters             List<NameValuePair> params = new ArrayList<NameValuePair>();             params.add(new BasicNameValuePair(TAG_PID, pid));             params.add(new BasicNameValuePair(TAG_NAME, name));             params.add(new BasicNameValuePair(TAG_PRICE, price));             params.add(new BasicNameValuePair(TAG_DESCRIPTION, description));             // sending modified data through http request             // Notice that update product url accepts POST method             JSONObject json = jsonParser.makeHttpRequest(url_update_product,                     "POST", params);             // check json success tag             try {                 int success = json.getInt(TAG_SUCCESS);                 if (success == 1) {                     // successfully updated                     Intent i = getIntent();                     // send result code 100 to notify about product update                     setResult(100, i);                     finish();                 } else {                     // failed to update product                 }             } catch (JSONException e) {                 e.printStackTrace();             }             return null;         }         /**          * After completing background task Dismiss the progress dialog          * **/         protected void onPostExecute(String file_url) {             // dismiss the dialog once product uupdated             pDialog.dismiss();         }     }     /*****************************************************************      * Background Async Task to Delete Product      * */     class DeleteProduct extends AsyncTask<String, String, String> {         /**          * Before starting background thread Show Progress Dialog          * */         @Override         protected void onPreExecute() {             super.onPreExecute();             pDialog = new ProgressDialog(EditProductActivity.this);             pDialog.setMessage("Deleting Product...");             pDialog.setIndeterminate(false);             pDialog.setCancelable(true);             pDialog.show();         }         /**          * Deleting product          * */         protected String doInBackground(String... args) {             // Check for success tag             int success;             try {                 // Building Parameters                 List<NameValuePair> params = new ArrayList<NameValuePair>();                 params.add(new BasicNameValuePair("pid", pid));                 // getting product details by making HTTP request                 JSONObject json = jsonParser.makeHttpRequest(                         url_delete_product, "POST", params);                 // check your log for json response                 Log.d("Delete Product", json.toString());                 // json success tag                 success = json.getInt(TAG_SUCCESS);                 if (success == 1) {                     // product successfully deleted                     // notify previous activity by sending code 100                     Intent i = getIntent();                     // send result code 100 to notify about product deletion                     setResult(100, i);                     finish();                 }             } catch (JSONException e) {                 e.printStackTrace();             }             return null;         }         /**          * After completing background task Dismiss the progress dialog          * **/         protected void onPostExecute(String file_url) {             // dismiss the dialog once product deleted             pDialog.dismiss();         }     } }

proses edit dan hapus data itu berdasarkan pid dari product.

Setelah semua proses crud selesai dibuat pasti listing diatas akan menampilkan error karena membutuhkan file JSONParser.java, untuk mengatasinya buat classnya dan copy listing berikut ini:

JSONParser.java

package com.example.androidhive; import java.io.BufferedReader; import java.io.IOException; import java.io.InputStream; import java.io.InputStreamReader; import java.io.UnsupportedEncodingException; import java.util.List; import org.apache.http.HttpEntity; import org.apache.http.HttpResponse; import org.apache.http.NameValuePair; import org.apache.http.client.ClientProtocolException; import org.apache.http.client.entity.UrlEncodedFormEntity; import org.apache.http.client.methods.HttpGet; import org.apache.http.client.methods.HttpPost; import org.apache.http.client.utils.URLEncodedUtils; import org.apache.http.impl.client.DefaultHttpClient; import org.json.JSONException; import org.json.JSONObject; import android.util.Log; 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) {         // Making HTTP request         try {             // check for request method             if(method == "POST"){                 // request method is POST                 // defaultHttpClient                 DefaultHttpClient httpClient = new DefaultHttpClient();                 HttpPost httpPost = new HttpPost(url);                 httpPost.setEntity(new UrlEncodedFormEntity(params));                 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;                 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();         }         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");             }             is.close();             json = sb.toString();         } catch (Exception e) {             Log.e("Buffer Error", "Error converting result " + e.toString());         }         // 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());         }         // return JSON String         return jObj;     } }

kemudian setelah semua selesai, langkah terakhir adalah memberi permision atau ijin supaya aplikasi dapat mengakses internet, buat file AndroidManifest.xml dan ubah listingnya seperti berikut ini:

AndroidManifest.xml

<?xml version="1.0" encoding="utf-8"?> <manifest xmlns:android="http://schemas.android.com/apk/res/android"     package="com.example.androidhive"     android:versionCode="1"     android:versionName="1.0" >     <uses-sdk android:minSdkVersion="8" />     <application         android:configChanges="keyboardHidden|orientation"         android:icon="@drawable/ic_launcher"         android:label="@string/app_name" >         <activity             android:name=".MainScreenActivity"             android:label="@string/app_name" >             <intent-filter>                 <action android:name="android.intent.action.MAIN" />                 <category android:name="android.intent.category.LAUNCHER" />             </intent-filter>         </activity>         <!-- All Product Activity -->         <activity             android:name=".AllProductsActivity"             android:label="All Products" >         </activity>         <!-- Add Product Activity -->         <activity             android:name=".NewProductActivity"             android:label="Add New Product" >         </activity>         <!-- Edit Product Activity -->         <activity             android:name=".EditProductActivity"             android:label="Edit Product" >         </activity>     </application>     <!--  Internet Permissions -->     <uses-permission android:name="android.permission.INTERNET" /> </manifest>

tambahkan listing yang berwarna merah seperti diatas.

Selesai sudah pembuatan CRUD sederhana pada Android dan coba jalankan aplikasinya,selalu gunakan logcat untuk melihat error dari aplikasi jika terjadi error saat aplikasi dijalankan.

artikel ini diambil dari sumber: http://www.androidhive.info/2012/05/how-to-connect-android-with-php-mysql/

karena mungkin sulit memahami artikelnya karena bahasanya menggunakan Inggris, mungkin postigan ini dapat membantu untuk memahaminya. terima kasih. ;)

SELAMAT BELAJAR ANDROID