CRUD PHP ANDROID

 Android ADD

<?php 

require_once"../konmysqli.php";

$respon = array();

if (isset($_POST['nama_admin'])) { 

 $sql="select `id_admin` from `$tbadmin` order by `id_admin` desc";

  $jum= getJum($conn,$sql);

  $kd="ADM";

if($jum > 0){

$d=getField($conn,$sql);

    $idmax=$d['id_admin'];

$urut=substr($idmax,3,2)+1;//01

if($urut<10){$idmax="$kd"."0".$urut;}

else{$idmax="$kd".$urut;}

}

else{$idmax="$kd"."01";}

  $id_admin=$idmax;

  

$nama_admin= $_POST['nama_admin'];

$username = $_POST['username'];

$password = $_POST['password'];

$telepon = $_POST['telepon'];

$email = $_POST['email'];

$status = $_POST['status'];

$keterangan = $_POST['keterangan'];

$sql="INSERT INTO `$tbadmin`

(`id_admin`, `nama_admin`, `username`, `password`, `telepon`,`email`,`keterangan`, `status`) VALUES

('$id_admin', '$nama_admin', '$username', '$password', '$telepon', '$email', '$keterangan', '$status')";

$simpan=process($conn,$sql);

   if($simpan){

        $respon["sukses"] = 1;

        $respon["pesan"] = "1 sukses tambah.";

        echo json_encode($respon);

    } else {

        $respon["sukses"] = 0;

        $respon["pesan"] = "0 gagal tambah";

        echo json_encode($respon);

    }

} else {

    $respon["sukses"] = 0;

    $respon["pesan"] = "? lengkapi data";

    echo json_encode($respon);

}

?>

ANDROID DELETE

<?php 

require_once"../konmysqli.php";

$response = array();

if (isset($_GET['id_admin'])) {

    $id_admin = $_GET['id_admin'];

$sql="DELETE FROM `$tbadmin` WHERE `id_admin` = '$id_admin'";

$hapus=process($conn,$sql);

   if($hapus){

        $respon["sukses"] = 1;

        $respon["pesan"] = "1 berhasil dihapus";

        echo json_encode($respon);

    } else {

        $respon["sukses"] = 0;

        $respon["pesan"] = "0 Gagal dihapus";

        echo json_encode($respon);

    }

} else {

    $respon["sukses"] = 0;

    $respon["pesan"] = "? lengkapi data";

    echo json_encode($respon);

}

?>

SHOW DATA

<?php 

require_once"../konmysqli.php";

$respon = array();

$sql="SELECT * FROM `$tbadmin` order by `id_admin` desc";

$jum=getJum($conn,$sql);

if ($jum> 0) {

    $respon["record"] = array();  

$arr=getData($conn,$sql);

foreach($arr as $d) {

        $record = array();

            $record["id_admin"] = $d["id_admin"];

$record["nama_admin"] = $d["nama_admin"];

$record["username"] = $d["username"];

$record["password"] = $d["password"];

$record["telepon"] = $d["telepon"];

$record["email"] = $d["email"];

$record["status"] = $d["status"];

$record["keterangan"] = $d["keterangan"];

        

        array_push($respon["record"], $record);       //tambahkan array 'record' pada array final 'respon'

    }

    // sukses

    $respon["sukses"] = 1;

$respon["pesan"] = "$jum record";

    echo json_encode($respon);

} else {

    // jika data kosong

$respon["record"]="";

    $respon["sukses"] = 0;

    $respon["pesan"] = "0 record";

    echo json_encode($respon);

}

?>

DETAIL DATA

<?php 

require_once"../konmysqli.php";

$respon = array();

if (isset($_GET["id_admin"])) {

    $id_admin = $_GET['id_admin'];

$sql="SELECT * FROM `$tbadmin` WHERE `id_admin` = '$id_admin'";

    $jum=getJum($conn,$sql);

    if ($jum>0) {

            $d=getField($conn,$sql);

    $record = array();

            $record["id_admin"] = $d["id_admin"];

$record["nama_admin"] = $d["nama_admin"];

$record["username"] = $d["username"];

$record["password"] = $d["password"];

$record["telepon"] = $d["telepon"];

$record["email"] = $d["email"];

$record["status"] = $d["status"];

$record["keterangan"] = $d["keterangan"];

            $respon["sukses"] = 1;

            $respon["record"] = array();

            array_push($respon["record"], $record);

             $respon["pesan"] = "$jum record";

echo json_encode($respon);

        } else {

            $respon["sukses"] = 0;

            $respon["pesan"] = "0 record";

            echo json_encode($respon);

        }

} else {

    $respon["sukses"] = 0;

    $respon["pesan"] = "? lengkapi data";

    echo json_encode($respon);

}

?>

 

UPDATE DATA 

<?php 

require_once"../konmysqli.php";

$respon = array();

if (isset($_POST['id_admin'])) {    

$id_admin= $_POST['id_admin'];

$nama_admin= $_POST['nama_admin'];

$username = $_POST['username'];

$password = $_POST['password'];

$telepon = $_POST['telepon'];

$email = $_POST['email'];

$status = $_POST['status'];

$keterangan = $_POST['keterangan'];

$sql="UPDATE `$tbadmin` SET 

`nama_admin` = '$nama_admin',

`username` = '$username', 

`password` = '$password', 

`telepon` = '$telepon', 

`email` = '$email', 

`keterangan` = '$keterangan', 

`status` = '$status' 

WHERE `id_admin` = '$id_admin'";

    $ubah=process($conn,$sql);

    if ($ubah) {

        $respon["sukses"] = 1;

        $respon["pesan"] = "1 sukses update.";     

        echo json_encode($respon);

    } else {

        $respon["sukses"] = 0;

        $respon["pesan"] = "Gagal update data.";

        echo json_encode($respon);

        

    }

} else {

    $respon["sukses"] = 0;

    $respon["pesan"] = "data belum terset/terisi";

    echo json_encode($respon);

}

?>