membuat login 2 bagian user dan program record member bank sampah dengan database mysql ~ Rival Achmadani

~Salam

Pada kesempatan kali ini, penulis ingin sharing tentang bagaimana membuat aplikasi android yang tersambung dengan database mysql. langusng saja pertama kita buat databasenya terlebih dahulu seperti dibawah ini

Selanjutnya kita persiapkan file php untuk koneksi, proses, daftar, hapus, dan menampilkan data.

koneksi.php

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "banksampah";

$connect = mysql_connect($servername, $username, $password) or die ("failed");
mysql_select_db($dbname) or die ("failed");
?>

<?php
include 'koneksi.php';
if($_SERVER['REQUEST_METHOD']=='POST'){
    $no_id = $_POST['no_id'];
    $pass_user = $_POST['pass_user'];

    $sql = "SELECT * FROM tbl_user WHERE no_id = '".$no_id."' AND pass_user = '".$pass_user."'";

    $result = mysql_query($sql);
    $check = mysql_fetch_array($result);

    if(isset($check)){
        echo 'success';
    } else {
        echo 'failure';
    }
    mysql_close($connect);
}
?>

daftar.php

<?php
   include 'koneksi.php';
   class usr{}

   $nama = $_POST['nama'];
   $pass_user = $_POST['pass_user'];
   $jenis_kelamin = $_POST['jenis_kelamin'];
   $alamat = $_POST['alamat'];
   $tanggal_lahir = $_POST['tanggal_lahir'];
   $no_telp = $_POST['no_telp'];
   $kewarganegaraan = $_POST['kewarganegaraan'];
   $id_status = $_POST['id_status'];

   if ((empty($nama))) {
       $response = new usr();
       $response->success = 0;
       $response->message = "Kolom username tidak boleh kosong";
       die(json_encode($response));
   } else if ((empty($pass_user))) {
       $response = new usr();
       $response->success = 0;
       $response->message = "Kolom password tidak boleh kosong";
       die(json_encode($response));
   } else {
           mysql_query(mysql_query("insert into tbl_user VALUES (null, '$pass_user', '$nama', '$jenis_kelamin', '$alamat', '$tanggal_lahir', '$no_telp', '$kewarganegaraan', '$id_status')"));
                   $response = new usr();
                   $response->success = 1;
                   $response->message = "Register berhasil";
                   die(json_encode($response));
   }

   mysql_close();
?>

select.php

<?php
    include "koneksi.php";

    $query = mysql_query("SELECT * FROM tbl_user ORDER BY nama ASC");

    $json = array();

    while($row = mysql_fetch_assoc($query)){
        $json[] = $row;
    }

    echo json_encode($json);

    mysql_close($connect);

?>

hapus.php

<?php
    include "koneksi.php";

    $no_id     = $_POST['no_id'];

    class emp{}

    if (empty($no_id)) {
        $response = new emp();
        $response->success = 0;
        $response->message = "Error hapus Data";
        die(json_encode($response));
    } else {
        $query = mysql_query("DELETE FROM tbl_user WHERE no_id='".$no_id."'");

        if ($query) {
            $response = new emp();
            $response->success = 1;
            $response->message = "Data berhasil di hapus";
            die(json_encode($response));
        } else{
            $response = new emp();
            $response->success = 0;
            $response->message = "Error hapus Data";
            die(json_encode($response));
        }
    }
?>

Sekarang saatnya kita buat scriptnya pada android studio. Mula-mula kita buat dulu MainActivity. pada MainActivity akan kita gunakan sebagai activity login. berikut kode xmlnya.

<?xml version="1.0" encoding="utf-8"?>
<android.support.constraint.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:background="#689a84"
    tools:context=".MainActivity">

    <EditText
        android:id="@+id/txtpass"
        android:layout_width="281dp"
        android:layout_height="43dp"
        android:layout_marginStart="8dp"
        android:layout_marginLeft="8dp"
        android:layout_marginTop="8dp"
        android:layout_marginEnd="8dp"
        android:layout_marginRight="8dp"
        android:layout_marginBottom="8dp"
        android:background="@android:color/white"
        android:ems="10"
        android:hint="password"
        android:inputType="textPassword"
        app:layout_constraintBottom_toBottomOf="parent"
        app:layout_constraintEnd_toEndOf="parent"
        app:layout_constraintHorizontal_bias="0.552"
        app:layout_constraintStart_toStartOf="parent"
        app:layout_constraintTop_toTopOf="parent"
        app:layout_constraintVertical_bias="0.753" />

    <EditText
        android:id="@+id/txtid"
        android:layout_width="277dp"
        android:layout_height="45dp"
        android:layout_marginStart="8dp"
        android:layout_marginLeft="8dp"
        android:layout_marginTop="8dp"
        android:layout_marginEnd="8dp"
        android:layout_marginRight="8dp"
        android:layout_marginBottom="8dp"
        android:background="@android:color/white"
        android:ems="10"
        android:hint="user ID"
        android:inputType="textPersonName"
        app:layout_constraintBottom_toBottomOf="parent"
        app:layout_constraintEnd_toEndOf="parent"
        app:layout_constraintHorizontal_bias="0.533"
        app:layout_constraintStart_toStartOf="parent"
        app:layout_constraintTop_toTopOf="parent"
        app:layout_constraintVertical_bias="0.653" />

    <Button
        android:id="@+id/bt_login"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_marginStart="8dp"
        android:layout_marginLeft="8dp"
        android:layout_marginTop="8dp"
        android:layout_marginEnd="8dp"
        android:layout_marginRight="8dp"
        android:layout_marginBottom="8dp"
        android:text="LOGIN"
        app:layout_constraintBottom_toBottomOf="parent"
        app:layout_constraintEnd_toEndOf="parent"
        app:layout_constraintHorizontal_bias="0.498"
        app:layout_constraintStart_toStartOf="parent"
        app:layout_constraintTop_toTopOf="parent"
        app:layout_constraintVertical_bias="0.868" />

    <ImageView
        android:id="@+id/imageView"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_marginStart="52dp"
        android:layout_marginLeft="52dp"
        android:layout_marginTop="64dp"
        android:layout_marginEnd="8dp"
        android:layout_marginRight="8dp"
        android:layout_marginBottom="8dp"
        app:layout_constraintBottom_toTopOf="@+id/txtid"
        app:layout_constraintEnd_toEndOf="parent"
        app:layout_constraintHorizontal_bias="0.228"
        app:layout_constraintStart_toStartOf="parent"
        app:layout_constraintTop_toTopOf="parent"
        app:layout_constraintVertical_bias="0.239"
        app:srcCompat="@drawable/logo" />

</android.support.constraint.ConstraintLayout>

kemudian berikut ini script kode untuk MainActivity.java

package net.houseoflife.rivalachmadani_161011400853;

import android.app.ProgressDialog;
import android.content.Context;
import android.content.Intent;
import android.content.SharedPreferences;
import android.net.ConnectivityManager;
import android.os.Build;
import android.support.annotation.RequiresApi;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

import com.android.volley.AuthFailureError;
import com.android.volley.Request;
import com.android.volley.RequestQueue;
import com.android.volley.Response;
import com.android.volley.VolleyError;
import com.android.volley.VolleyLog;
import com.android.volley.toolbox.JsonArrayRequest;
import com.android.volley.toolbox.StringRequest;
import com.android.volley.toolbox.Volley;

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

import java.util.HashMap;
import java.util.Map;

import static net.houseoflife.rivalachmadani_161011400853.AppVar.id_status;

public class MainActivity extends AppCompatActivity {
    private EditText noid;
    private EditText passuser, status;
    private Button btlogin1;
    private Context context;
    ConnectivityManager conMgr;
    int success;
    private ProgressDialog pDialog;
    private String url = AppVar.URL + "login.php";
    private static final String TAG = MainActivity.class.getSimpleName();
    public static final String TAG_STATUS   = "id_status";
    String tag_json_obj = "json_obj_req";
    SharedPreferences sharedpreferences;
    Boolean session = false;
    String id, name,idstatus;
    public static final String my_shared_preferences = "my_shared_preferences";
    public static final String session_status = "session_status";
    private static final String TAG_SUCCESS = "success";

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        context = MainActivity.this;
        pDialog = new ProgressDialog(context);
        noid = (EditText) findViewById(R.id.txtid);
        passuser = (EditText) findViewById(R.id.txtpass);
        btlogin1 = (Button) findViewById(R.id.bt_login);

        btlogin1.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                login();
            }
        });
    }

    private void login() {
        //Getting values from edit texts
        final String no_id = noid.getText().toString().trim();
        final String pass_user = passuser.getText().toString().trim();
        pDialog.setMessage("Login Process...");
        showDialog();
        //Creating a string request
        StringRequest stringRequest = new StringRequest(Request.Method.POST, AppVar.LOGIN_URL,
                new Response.Listener<String>() {
                    @Override
                    public void onResponse(String response) {
                        hideDialog();
                        if (response.contains(AppVar.LOGIN_ADMIN)) {
                            gotoCourseActivity();
                        }else if(response.contains(AppVar.LOGIN_MEMBER)) {
                            gotoMemberActivity();
                         }else {
                            Toast.makeText(context, "Invalid username or password", Toast.LENGTH_LONG).show();
                        }
                    }
                },
                new Response.ErrorListener() {
                    @Override
                    public void onErrorResponse(VolleyError error) {
                        //You can handle error here if you want
                        hideDialog();
                        Toast.makeText(context, "The server unreachable", Toast.LENGTH_LONG).show();

                    }
                }) {
            @Override
            protected Map<String, String> getParams() throws AuthFailureError {
                Map<String, String> params = new HashMap<>();
                //Adding parameters to request
                params.put(AppVar.TAG_ID, no_id);
                params.put(AppVar.TAG_PASS, pass_user);

                //returning parameter
                return params;
            }
        };

        //Adding the string request to the queue
        Volley.newRequestQueue(this).add(stringRequest);

    }

    private void gotoCourseActivity() {
        Intent intent = new Intent(context, AdminActivity.class);
        startActivity(intent);
        finish();
    }

    private void gotoMemberActivity() {
        Intent i = new Intent(context, MemberActivity.class);
        startActivity(i);
        finish();
    }

    private void showDialog() {
        if (!pDialog.isShowing())
            pDialog.show();
    }

    private void hideDialog() {
        if (pDialog.isShowing())
            pDialog.dismiss();
    }

}

Dan Seperti ini lah tampilannya

Selanjutnya buat Java class baru untuk setting url nya. beri nama AppVar.Java.
Berikut kode Scriptnya

package net.houseoflife.rivalachmadani_161011400853;

public class AppVar {

    public static final String LOGIN_URL = "http://192.168.0.100/banksampahandroid/login.php";
    public static final String URL = "http://192.168.0.100/banksampahandroid/";
    public static final String no_id = "no_id";
    public static final String pass_user = "pass_user";
    public static final String nama = "nama";
    public static final String alamat = "alamat";
    public static final String tanggal_lahir = "tanggal_lahir";
    public static final String jenis_kelamin = "jenis_kelamin";
    public static final String no_telp = "no_telp";
    public static final String kewarganegaraan = "kewarganegaraan";
    public static final String id_status = "id_status";
    public static final String LOGIN_MEMBER= "Member";
    public static final String LOGIN_ADMIN= "Admin";
    public static final String TAG_ID       = "no_id";
    public static final String TAG_NAMA     = "nama";
    public static final String TAG_PASS     = "pass_user";
    public static final String TAG_ALAMAT   = "alamat";
    public static final String TAG_GENDER   = "jenis_kelamin";
    public static final String TAG_TGLLHR   = "tanggal_lahir";
    public static final String TAG_KWG      = "kewarganegaraan";
    public static final String TAG_STATUS   = "id_status";
    public static final String TAG_TELP   = "no_telp";
    private static final String TAG_ADMIN = "Admin";
    public static final String TAG_MEMBER = "Member";
    public static final String TAG_MESSAGE = "message";

}

jika sudah selanjutnya karna pada script kode di atas kita buat login untuk dua user, kita buat 2 Activity baru untuk Admin dan Member. Pada contoh ini penulis hanya akan mengisi Activity Admin. Namun untuk User Activity tetap harus dibuat agar tidak terjadi error pada script kode loginnya. Pada Admin activity penulis akan mengisinya dengan listview. berikut kode xml untuk Admin Activity

Berikut kode script untuk java class nya

package net.houseoflife.rivalachmadani_161011400853;

import android.app.Activity;
import android.app.ListActivity;
import android.content.Intent;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.Toast;

public class AdminActivity extends Activity{

    ListView lvw1;
    String [] menu = new String[]{"User","Record"};

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_admin);

        ArrayAdapter adapter = new ArrayAdapter(this,android.R.layout.simple_expandable_list_item_1,menu);

        lvw1 = (ListView)findViewById(R.id.lv1);
        lvw1.setAdapter(adapter);

        lvw1.setOnItemClickListener(new AdapterView.OnItemClickListener() {
            @Override
            public void onItemClick(AdapterView<?> arg0, View arg1, int arg2, long arg3) {

                int item = arg2;
                String itemText = (String) lvw1.getItemAtPosition(arg2);
                Toast.makeText(getBaseContext(),"" + itemText, Toast.LENGTH_LONG).show();

                if (itemText.equals("User")){
                    Intent User = new Intent(arg0.getContext(), AdminUser.class);
                    startActivity(User);
                }else {
                    Intent Record = new Intent(arg0.getContext(), AdminRecord.class);
                    startActivity(Record);
                }

            }
        });

    }
}

Tampilan AdminActivity seperti berikut

Tahap berikutnya kita isi listview tersebut dengan activity. Pada contoh ini penulisnya hanya mengisi listview user. pada listview user akan kita isi dengan tabhost. berikut kode xml nya

berikut ini script untuk java class

dan berikut ini kode script java nya

package net.houseoflife.rivalachmadani_161011400853;

import android.app.TabActivity;
import android.content.Intent;
import android.support.v4.app.FragmentTabHost;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.widget.TabHost;

public class AdminUser extends TabActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_admin_user);

        Intent intent;
        TabHost tabHost = getTabHost();
        TabHost.TabSpec spec;

        intent = new Intent().setClass(AdminUser.this,AdminUserAll.class);
        spec=getTabHost().newTabSpec("All").setIndicator("All",null).setContent(intent);
        tabHost.addTab(spec);

        intent = new Intent().setClass(AdminUser.this,AdminUserAdd.class);
        spec=getTabHost().newTabSpec("Add").setIndicator("Add",null).setContent(intent);
        tabHost.addTab(spec);

    }
}

kemudian untuk tabhostnya akan diisi dengan daftar user dan pendaftaran user. kita buat dua activitynya. Activity list user dan activity tambah user.

xml Activity list user

<?xml version="1.0" encoding="utf-8"?>
<android.support.design.widget.CoordinatorLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:fitsSystemWindows="true"
    tools:context=".AdminUserAll">

    <android.support.v4.widget.SwipeRefreshLayout
        android:id="@+id/swipe_refresh"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"/>

    <android.support.v4.widget.SwipeRefreshLayout
        android:id="@+id/swipe_refresh_layout"
        android:layout_width="match_parent"
        android:layout_height="wrap_content">

    <ListView
        android:id="@+id/list"
        android:dividerHeight="2dp"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"/>

    </android.support.v4.widget.SwipeRefreshLayout>

</android.support.design.widget.CoordinatorLayout>

berikut javascript nya

package net.houseoflife.rivalachmadani_161011400853;

import android.content.DialogInterface;
import android.content.Intent;
import android.os.Build;
import android.support.annotation.RequiresApi;
import android.support.v4.widget.SwipeRefreshLayout;
import android.support.v7.app.AlertDialog;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.widget.AdapterView;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.Toast;
import android.widget.Toolbar;

import com.android.volley.Request;
import com.android.volley.Response;
import com.android.volley.VolleyError;
import com.android.volley.VolleyLog;
import com.android.volley.toolbox.JsonArrayRequest;
import com.android.volley.toolbox.StringRequest;

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

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class AdminUserAll extends AppCompatActivity implements SwipeRefreshLayout.OnRefreshListener {

    Toolbar toolbar;
    ListView list;
    SwipeRefreshLayout swipe;
    List<Data> itemList = new ArrayList<Data>();
    Adapter adapter;
    int success;
    AlertDialog.Builder dialog;
    LayoutInflater inflater;
    View dialogView;
    EditText txt_id, txt_nama, txt_alamat, txt_pass, txt_tanggal, txt_telp, txt_kwg;
    RadioGroup rggender1, rgsts1;
    RadioButton rbboy, rbgirl, rbadmin1, rbmember1;
    String no_id, nama, alamat, jenis_kelamin, pass_user, no_telp, kewarganegaraan, id_status, tanggal_lahir, gender, stst;

    private static final String TAG = AdminUserAll.class.getSimpleName();

    private static String url_select     = AppVar.URL + "selectall.php";
    private static String url_insert     = AppVar.URL + "insert.php";
    private static String url_edit       = AppVar.URL + "prosesupdate.php";
    private static String url_update     = AppVar.URL + "prosesedit.php";
    private static String url_delete     = AppVar.URL + "deletedata.php";

    public static final String TAG_ID       = "no_id";
    public static final String TAG_NAMA     = "nama";
    public static final String TAG_PASS     = "pass_user";
    public static final String TAG_ALAMAT   = "alamat";
    public static final String TAG_GENDER   = "jenis_kelamin";
    public static final String TAG_TGLLHR   = "tanggal_lahir";
    public static final String TAG_KWG      = "kewarganegaraan";
    public static final String TAG_STATUS   = "id_status";
    public static final String TAG_TELP   = "no_telp";
    private static final String TAG_SUCCESS = "success";
    private static final String TAG_MESSAGE = "message";

    String tag_json_obj = "json_obj_req";

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_admin_user_all);

        swipe   = (SwipeRefreshLayout) findViewById(R.id.swipe_refresh_layout);
        list    = (ListView) findViewById(R.id.list);

        adapter = new Adapter(AdminUserAll.this, itemList);
        list.setAdapter(adapter);

        swipe.setOnRefreshListener(this);

        swipe.post(new Runnable() {
                       @Override
                       public void run() {
                           swipe.setRefreshing(true);
                           itemList.clear();
                           adapter.notifyDataSetChanged();
                           callVolley();
                       }
                   }
        );

        // listview ditekan lama akan menampilkan dua pilihan edit atau delete data
        list.setOnItemLongClickListener(new AdapterView.OnItemLongClickListener() {

            @Override
            public boolean onItemLongClick(final AdapterView<?> parent, View view,
                                           final int position, long id) {
                // TODO Auto-generated method stub
                final String idx = itemList.get(position).getNo_id();

                final CharSequence[] dialogitem = {"Edit", "Delete"};
                dialog = new AlertDialog.Builder(AdminUserAll.this);
                dialog.setCancelable(true);
                dialog.setItems(dialogitem, new DialogInterface.OnClickListener() {

                    @Override
                    public void onClick(DialogInterface dialog, int which) {
                        // TODO Auto-generated method stub
                        switch (which) {
                            case 0:
                                edit(idx);
                                Intent intent = new Intent(AdminUserAll.this, EditActivity.class);
                                startActivity(intent);
                                break;
                            case 1:
                                delete(idx);
                                break;
                        }
                    }

                }).show();
                return false;
            }
    });
}

    private void edit(final String idx) {
        StringRequest strReq = new StringRequest(Request.Method.POST, url_edit, new Response.Listener<String>() {

            @Override
            public void onResponse(String response) {
                Log.d(TAG, "Response: " + response.toString());

                try {
                    JSONObject jObj = new JSONObject(response);
                    success = jObj.getInt(TAG_SUCCESS);

                    // Cek error node pada json
                    if (success == 1) {
                        Log.d("get edit data", jObj.toString());
                        String idx      = jObj.getString(TAG_ID);
                        String namax    = jObj.getString(TAG_NAMA);
                        String alamatx = jObj.getString(TAG_ALAMAT);
                        String jenis_kelaminx = jObj.getString(TAG_GENDER);
                        String tanggal_lahirx = jObj.getString(TAG_TGLLHR);
                        String pass_userx = jObj.getString(TAG_PASS);
                        String no_telpx = jObj.getString(TAG_TELP);
                        String kwgx = jObj.getString(TAG_KWG);
                        String statusx = jObj.getString(TAG_STATUS);

                        Bundle bundle = new Bundle();
                        bundle.putString(nama, namax);
                        bundle.putString(pass_user, pass_userx);
                        bundle.putString(jenis_kelamin, jenis_kelaminx);
                        bundle.putString(alamat, alamatx);
                        bundle.putString(tanggal_lahir, tanggal_lahirx);
                        bundle.putString(no_telp, no_telpx);
                        bundle.putString(kewarganegaraan,kwgx);
                        bundle.putString(id_status,statusx);
                        Intent c = new Intent(AdminUserAll.this, EditActivity.class);
                        c.putExtras(bundle);
                        startActivity(c);

                        //DialogForm(idx, namax, alamatx,jenis_kelaminx,tanggal_lahirx,pass_userx,no_telpx,kwgx,statusx, "UPDATE");

                        adapter.notifyDataSetChanged();

                    } else {
                        Toast.makeText(AdminUserAll.this, jObj.getString(TAG_MESSAGE), Toast.LENGTH_LONG).show();
                    }
                } catch (JSONException e) {
                    // JSON error
                    e.printStackTrace();
                }
    }
        }, new Response.ErrorListener() {

            @Override
            public void onErrorResponse(VolleyError error) {
                Log.e(TAG, "Error: " + error.getMessage());
                Toast.makeText(AdminUserAll.this, error.getMessage(), Toast.LENGTH_LONG).show();
            }
        }) {

            @Override
            protected Map<String, String> getParams() {
                // Posting parameters ke post url
                Map<String, String> params = new HashMap<String, String>();
                params.put("no_id", idx);

                return params;
            }
    };
        appcontroller.getInstance().addToRequestQueue(strReq, tag_json_obj);
    }

    @Override
    public void onRefresh() {
        swipe.setRefreshing(true);
        itemList.clear();
        adapter.notifyDataSetChanged();
        callVolley();
    }
    private void callVolley(){
        itemList.clear();
        adapter.notifyDataSetChanged();
        swipe.setRefreshing(true);

        JsonArrayRequest jArr = new JsonArrayRequest(url_select, new Response.Listener<JSONArray>() {
            @Override
            public void onResponse(JSONArray response) {
                Log.d(TAG, response.toString());

                // Parsing json
                for (int i = 0; i < response.length(); i++) {
                    try {
                        JSONObject obj = response.getJSONObject(i);

                        Data item = new Data();

                        item.setNo_id(obj.getString(TAG_ID));
                        item.setNama(obj.getString(TAG_NAMA));
                        item.setPass_user(obj.getString(TAG_PASS));
                        item.setJenis_kelamin(obj.getString(TAG_GENDER));
                        item.setAlamat(obj.getString(TAG_ALAMAT));
                        item.setTanggal_lahir(obj.getString(TAG_TGLLHR));
                        item.setKewarganegaraan(obj.getString(TAG_KWG));
                        item.setId_status(obj.getString(TAG_STATUS));
                        item.setNo_telp(obj.getString(TAG_TELP));

                        // menambah item ke array
                        itemList.add(item);
                    } catch (JSONException e) {
                        e.printStackTrace();
                    }
                }

                adapter.notifyDataSetChanged();

                swipe.setRefreshing(false);
            }
        }, new Response.ErrorListener() {

            @Override
            public void onErrorResponse(VolleyError error) {
                VolleyLog.d(TAG, "Error: " + error.getMessage());
                swipe.setRefreshing(false);
            }
        });
        appcontroller.getInstance().addToRequestQueue(jArr);
    }

    private void delete(final String idx){
        StringRequest strReq = new StringRequest(Request.Method.POST, url_delete, new Response.Listener<String>() {

            @Override
            public void onResponse(String response) {
                Log.d(TAG, "Response: " + response.toString());

                try {
                    JSONObject jObj = new JSONObject(response);
                    success = jObj.getInt(TAG_SUCCESS);

                    // Cek error node pada json
                    if (success == 1) {
                        Log.d("delete", jObj.toString());

                        callVolley();

                        Toast.makeText(AdminUserAll.this, jObj.getString(TAG_MESSAGE), Toast.LENGTH_LONG).show();

                        adapter.notifyDataSetChanged();

                    } else {
                        Toast.makeText(AdminUserAll.this, jObj.getString(TAG_MESSAGE), Toast.LENGTH_LONG).show();
                    }
                } catch (JSONException e) {
                    // JSON error
                    e.printStackTrace();
                }

            }
        }, new Response.ErrorListener() {

            @Override
            public void onErrorResponse(VolleyError error) {
                Log.e(TAG, "Error: " + error.getMessage());
                Toast.makeText(AdminUserAll.this, error.getMessage(), Toast.LENGTH_LONG).show();
            }
        }) {

            @Override
            protected Map<String, String> getParams() {
                // Posting parameters ke post url
                Map<String, String> params = new HashMap<String, String>();
                params.put("no_id", idx);

                return params;
            }

        };

        appcontroller.getInstance().addToRequestQueue(strReq, tag_json_obj);
    }

}

dan ini xml untuk activity tambah user

Berikut javascript nya

package net.houseoflife.rivalachmadani_161011400853;

import android.app.ProgressDialog;
import android.content.Context;
import android.content.Intent;
import android.net.ConnectivityManager;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.TextView;
import android.widget.Toast;

import com.android.volley.AuthFailureError;
import com.android.volley.Request;
import com.android.volley.Response;
import com.android.volley.VolleyError;
import com.android.volley.toolbox.StringRequest;
import com.android.volley.toolbox.Volley;

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

import java.util.HashMap;
import java.util.Map;

import static net.houseoflife.rivalachmadani_161011400853.AppVar.alamat;

public class AdminUserAdd extends AppCompatActivity {

    EditText namauser, password, almt, tgllhr, notlp, kwrg;
    RadioGroup rgsts, rgjklm;
    RadioButton rblk, rbpr, rbadmin, rbmember;
    Button input;
    private ProgressDialog progressDialog;
    private Context context;
    String gender, status;
    Intent intent;

    int success;
    ConnectivityManager conMgr;

    private String url = AppVar.URL + "prosesdaftar.php";

    private static final String TAG = AdminUserAdd.class.getSimpleName();

    private static final String TAG_SUCCESS = "success";
    private static final String TAG_MESSAGE = "message";

    String tag_json_obj = "json_obj_req";

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_admin_user_add);

        conMgr = (ConnectivityManager) getSystemService(Context.CONNECTIVITY_SERVICE);
        {
            if (conMgr.getActiveNetworkInfo() != null
                    && conMgr.getActiveNetworkInfo().isAvailable()
                    && conMgr.getActiveNetworkInfo().isConnected()) {
            } else {
                Toast.makeText(getApplicationContext(), "No Internet Connection",
                        Toast.LENGTH_LONG).show();
            }
        }

        namauser = (EditText) findViewById(R.id.txtnama);
        password = (EditText) findViewById(R.id.txtpass);
        almt = (EditText) findViewById(R.id.txtalamat);
        tgllhr = (EditText) findViewById(R.id.txttgl);
        notlp = (EditText) findViewById(R.id.txttelp);
        kwrg = (EditText) findViewById(R.id.txtkwg);
        rgsts = (RadioGroup) findViewById(R.id.rgstatus);
        rgjklm = (RadioGroup) findViewById(R.id.rgjklm);
        rblk = (RadioButton) findViewById(R.id.rbpria);
        rbpr = (RadioButton) findViewById(R.id.rbperempuan);
        rbadmin = (RadioButton) findViewById(R.id.adminrb);
        rbmember = (RadioButton) findViewById(R.id.memberrb);
        input = (Button) findViewById(R.id.btdaftar);

        input.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                if (rblk.isChecked()) {
                    gender = "Laki-laki";
                } else {
                    gender = "Perempuan";
                }

                if (rbadmin.isChecked()) {
                    status = "1";
                } else {
                    status = "2";
                }

                final String pass_user = password.getText().toString().trim();
                final String nama = namauser.getText().toString().trim();
                final String jenis_kelamin = gender;
                final String alamat = almt.getText().toString().trim();
                final String tanggal_lahir = tgllhr.getText().toString().trim();
                final String no_telp = notlp.getText().toString().trim();
                final String kewarganegaraan = kwrg.getText().toString().trim();
                final String id_status = status;

                if (conMgr.getActiveNetworkInfo() != null
                        && conMgr.getActiveNetworkInfo().isAvailable()
                        && conMgr.getActiveNetworkInfo().isConnected()) {
                    checkRegister(pass_user, nama, jenis_kelamin, alamat, tanggal_lahir, no_telp, kewarganegaraan, id_status);
                } else {
                    Toast.makeText(getApplicationContext(), "No Internet Connection", Toast.LENGTH_SHORT).show();
                }
            }
        });

    }

    private void checkRegister(final String pass_user, final String nama, final String jenis_kelamin, final String alamat, final String tanggal_lahir, final String no_telp, final String kewarganegaraan, final String id_status) {
        progressDialog = new ProgressDialog(this);
        progressDialog.setCancelable(false);
        progressDialog.setMessage("Register ...");
        showDialog();

        StringRequest strReq = new StringRequest(Request.Method.POST, url, new Response.Listener<String>() {

            @Override
            public void onResponse(String response) {
                Log.e(TAG, "Register Response: " + response.toString());
                hideDialog();

                try {
                    JSONObject jObj = new JSONObject(response);
                    success = jObj.getInt(TAG_SUCCESS);

                    // Check for error node in json
                    if (success == 1) {

                        Log.e("Successfully Register!", jObj.toString());

                        Toast.makeText(getApplicationContext(),
                                jObj.getString(TAG_MESSAGE), Toast.LENGTH_LONG).show();

                    } else {
                        Toast.makeText(getApplicationContext(),
                                jObj.getString(TAG_MESSAGE), Toast.LENGTH_LONG).show();

                    }
                } catch (JSONException e) {
                    // JSON error
                    e.printStackTrace();
                }

            }
        }, new Response.ErrorListener() {

            @Override
            public void onErrorResponse(VolleyError error) {
                Log.e(TAG, "Login Error: " + error.getMessage());
                Toast.makeText(getApplicationContext(),
                        error.getMessage(), Toast.LENGTH_LONG).show();

                hideDialog();

            }
        }) {

            @Override
            protected Map<String, String> getParams() {
                // Posting parameters to login url
                Map<String, String> params = new HashMap<String, String>();
                params.put(AppVar.nama, nama);
                params.put(AppVar.pass_user, pass_user);
                params.put(AppVar.jenis_kelamin, jenis_kelamin);
                params.put(AppVar.alamat, alamat);
                params.put(AppVar.tanggal_lahir, tanggal_lahir);
                params.put(AppVar.no_telp, no_telp);
                params.put(AppVar.kewarganegaraan, kewarganegaraan);
                params.put(AppVar.id_status, id_status);
                return params;
            }

        };

        appcontroller.getInstance().addToRequestQueue(strReq, tag_json_obj);
    }

    private void showDialog() {
        if (!progressDialog.isShowing())
            progressDialog.show();
    }

    private void hideDialog() {
        if (progressDialog.isShowing())
            progressDialog.dismiss();
    }
}

dan tampilannya seperti ini

Seperti itulah tutorial bagaimana cara membuat sistem bank sampah dengan android studio. Akan lebih mudah jika kita pahami terlebih dahulu script yang ada dan ikuti langkah-langkahnya dengan benar,

Dan Pemulis mengucapkan terimakasih atas perhatian para pembaca semoga blog ini bisa bermanfaat

~Salam

Rival Achmadani

Kamis, 11 Juli 2019

membuat login 2 bagian user dan program record member bank sampah dengan database mysql

0 komentar:

Posting Komentar

Mengenai Saya

Arsip Blog

Blog Archive

Blogger templates

Blogroll

About