Monday, 3 November 2014

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.

 

main screen

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:

android list products

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>


android adding new product

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





Posted by at
Labels: , ,

1 comment:

Subscribe to: Post Comments (Atom)