?php
$server = "localhost";
$username = "root";
$password = "";
$database = "android";
mysql_connect($server, $username, $password) or die("

Koneksi Mysql Error :

" . mysql_error());
mysql_select_db($database) or die("

Koneksi Kedatabase Error :

" . mysql_error());

@$operasi = $_GET['operasi'];

switch ($operasi) {
    case "view":
       // Source code untuk Menampilkan Biodata
        $query_tampil_biodata = mysql_query("SELECT * FROM tbl_biodata") or die(mysql_error());
        $data_array = array();
        while ($data = mysql_fetch_assoc($query_tampil_biodata)) {
            $data_array[] = $data;
        }
        echo json_encode($data_array);

        break;
    case "insert":
        // Source code untuk Insert data
        @$nama = $_GET['nama'];
        @$alamat = $_GET['alamat'];
        $query_insert_data = mysql_query("INSERT INTO tbl_biodata (nama, alamat) VALUES('$nama', '$alamat')");
        if ($query_insert_data) {
            echo "Data Berhasil Disimpan";
        } else {
            echo "Error Inser Biodata " . mysql_error();
        }

        break;
    case "get_biodata_by_id":
        // Source code untuk Edit data dan mengirim data berdasarkan id yang diminta */
        @$id = $_GET['id'];

        $query_tampil_biodata = mysql_query("SELECT * FROM tbl_biodata WHERE id='$id'") or die(mysql_error());
        $data_array = array();
        $data_array = mysql_fetch_assoc($query_tampil_biodata);
        echo "[" . json_encode($data_array) . "]";


        break;
    case "update":
         // Source code untuk Update Biodata
        @$nama = $_GET['nama'];
        @$alamat = $_GET['alamat'];
        @$id = $_GET['id'];
        $query_update_biodata = mysql_query("UPDATE tbl_biodata SET nama='$nama', alamat='$alamat' WHERE id='$id'");
        if ($query_update_biodata) {
            echo "Update Data Berhasil";
        } else {
            echo mysql_error();
        }
        break;
    case "delete":
         // Source code untuk Delete Biodata
        @$id = $_GET['id'];
        $query_delete_biodata = mysql_query("DELETE FROM tbl_biodata WHERE id='$id'");
        if ($query_delete_biodata) {
            echo "Delete Data Berhasil";
        } else {
            echo mysql_error();
        }

        break;

    default:
        break;
}