Sunday, December 11, 2016

Android code Delete dan edit

Tags

ANDROID

EditText txtKode,txtusername,txttelepon,txtemail,txtpassword,txtgambar, txtstatus;
 String kode_admin,username,telepon,email,password,gambar,status;
@Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.detailadmin);

        Intent io = this.getIntent();
        kode_admin=io.getStringExtra("kode_admin");
        username=io.getStringExtra("username");
        telepon=io.getStringExtra("telepon");
        email=io.getStringExtra("email");
        password=io.getStringExtra("password");
        status=io.getStringExtra("status");
        gambar=io.getStringExtra("gambar");
       
       
txtKode=(EditText)findViewById(R.id.dakode_admin);
txtusername=(EditText)findViewById(R.id.dausername);
txttelepon=(EditText)findViewById(R.id.datelepon);
txtemail=(EditText)findViewById(R.id.daemail);
txtpassword=(EditText)findViewById(R.id.dapassword);
txtstatus=(EditText)findViewById(R.id.dastatus);  
txtgambar=(EditText)findViewById(R.id.dagambar);    
     
txtKode.setText(kode_admin);txtKode.setEnabled(false);
txtusername.setText(username);
txtpassword.setText(password);
txttelepon.setText(telepon);
txtstatus.setText(status);
txtemail.setText(email);
txtgambar.setText(gambar);
     

       Button  btnUbah=(Button)findViewById(R.id.btnUbah);
       btnUbah.setOnClickListener(new View.OnClickListener() {
        public void onClick(View arg0) {
        String kode=txtKode.getText().toString().trim();
        String username=txtusername.getText().toString().trim();
        String password=txtpassword.getText().toString().trim();
        String telepon=txttelepon.getText().toString().trim();
        String email=txtemail.getText().toString().trim();
        String status=txtstatus.getText().toString().trim();
        String gambar=txtgambar.getText().toString().trim();
       
        if(kode.length()<1){lengkapi("kode_admin");}
        else if(username.length()<1){lengkapi("username");}
        else if(password.length()<1){lengkapi("password");}
        else if(telepon.length()<1){lengkapi("telepon");}
        else if(email.length()<1){lengkapi("email");}
        else if(status.length()<1){lengkapi("status");}
        else if(gambar.length()<1){lengkapi("gambar");}
        else{
        kode=kode.replaceAll(" ", "_");
        username=username.replaceAll(" ", "_");
        password=password.replaceAll(" ", "_");
        telepon=telepon.replaceAll(" ", "_");
        email=email.replaceAll(" ", "_");
        status=status.replaceAll(" ", "_");
        gambar=gambar.replaceAll(" ", "_");
       
        Utils ip=new Utils();
        String myip=ip.getIP();
        String URL = myip+"android/adminUpdate.php?kode_admin="+kode+"&username="+username+"&password="+password+"&telepon="+telepon+"&email="+email+"&status="+status+"&gambar="+gambar+"&ket=ok";
        Log.v("sql",URL);
        XMLParser parser = new XMLParser();
        String xml = parser.getXmlFromUrl(URL);
        if(xml.indexOf("sukses")>=0){sukses(kode,"Ubah");}
        else{gagal(kode);}
        }
       
       }});
       Button  btnDelete=(Button)findViewById(R.id.btnHapus);
       btnDelete.setOnClickListener(new View.OnClickListener() {
        public void onClick(View arg0) {
        String kode=txtKode.getText().toString().trim();
       
       
        if(kode.length()<1){lengkapi("kode_admin");}
       
        else{
        kode=kode.replaceAll(" ", "_");
       
        Utils ip=new Utils();
        String myip=ip.getIP();
        String URL = myip+"android/adminDelete.php?kode_admin="+kode+"&ket=ok";
        Log.v("sql",URL);
        XMLParser parser = new XMLParser();
        String xml = parser.getXmlFromUrl(URL);
        if(xml.indexOf("sukses")>=0){sukses(kode,"Delete");}
        else{gagal(kode);}
        }
       
       }});
     
   }

 public void lengkapi(String item){
    new AlertDialog.Builder(this)
.setTitle("Lengkapi Data")
.setMessage("Silakan lengkapi data "+item)
.setNeutralButton("OK", new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dlg, int sumthin) {
}})
.show();
   }

 public void sukses(String item,String ex){
    new AlertDialog.Builder(this)
.setTitle("Sukses "+ex)
.setMessage(ex+" data "+item+" Berhasil")
.setNeutralButton("OK", new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dlg, int sumthin) {
bersih();
Intent i = new Intent(detailAdmin.this,listAdmin.class);
             startActivity(i);
             finish();
}})
.show();
   }

 public void gagal(String item){
    new AlertDialog.Builder(this)
.setTitle("Gagal Ubah")
.setMessage("Ubah data "+item+" Gagal")
.setNeutralButton("OK", new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dlg, int sumthin) {
}})
.show();
   }


 void bersih(){
 txtKode.setText("");
 txtusername.setText("");
 txtpassword.setText("");
 txttelepon.setText("");
 txtemail.setText("");
 txtstatus.setText("");
 txtgambar.setText("");


 }

PHP EDIT

<?php
if (version_compare(phpversion(), "5.3.0", ">=")  == 1)
  error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
else
  error_reporting(E_ALL & ~E_NOTICE);
  ?>
<?php
require_once"../koneksi.php";
date_default_timezone_set("Asia/Jakarta");

if(isset($_GET["kode_admin"])){
//String URL = myip+"android/customersave.php?kode_admin="+kode+"&username="+username+"&password="+password+"&telepon="+telepon+"&email="+email+"&status="+status+"&gambar="+gambar+"&ket=ok";

$kode_admin=strip_tags($_REQUEST["kode_admin"]);$kode_admin=str_replace("_"," ",$kode_admin);
$username=strip_tags($_REQUEST["username"]);$username=str_replace("_"," ",$username);
$password=strip_tags($_REQUEST["password"]);$password=str_replace("_"," ",$password);
$telepon=strip_tags($_REQUEST["telepon"]);$telepon=str_replace("_"," ",$telepon);
$email=strip_tags($_REQUEST["email"]);$email=str_replace("_"," ",$email);
$status=strip_tags($_REQUEST["status"]);$status=str_replace("_"," ",$status);
$gambar=strip_tags($_REQUEST["gambar"]);$gambar=str_replace("_"," ",$gambar);
$sql="update `$tbadmin` set
`username`='$username',
`password`='$password',
`telepon`='$telepon' ,
`email`='$email',
`status`='$status',
`gambar`='$gambar'
 where `kode_admin`='$kode_admin'";

$simpan=mysql_query($sql);
if($simpan){echo"sukses";}
else{echo"gagal";}
}
else{echo"null";}
?>


PHP Delete

<?php
if (version_compare(phpversion(), "5.3.0", ">=")  == 1)
  error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
else
  error_reporting(E_ALL & ~E_NOTICE);
  ?>
<?php
require_once"../koneksi.php";
date_default_timezone_set("Asia/Jakarta");

if(isset($_GET["kode_admin"])){
$kode_admin=strip_tags($_REQUEST["kode_admin"]);$kode_admin=str_replace("_"," ",$kode_admin);

$sql="Delete from `$tbadmin`
where `kode_admin`='$kode_admin'";

$simpan=mysql_query($sql);
if($simpan){echo"sukses";}
else{echo"gagal";}
}
else{echo"null";}
?>


EmoticonEmoticon