CRUD Json PHP Mysqli

Buat tabel member:


CREATE TABLE `member` (
  `id` tinyint(4) UNSIGNED NOT NULL,
  `nama` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `alamat` varchar(200) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `member` (`id`, `nama`, `alamat`) VALUES
(1, 'Riadi Marta Dinata', 'Jakarta'),
(2, 'Khanza Humaira Dinata', 'Jakarta'),
(3, 'Rini Dyah Anggorowati', 'Jakarta');


ketik kode CRUD sebagai berikut untuk menjalankan aplikasi

anggota.php

<?php
require_once"../konmysqli.php";

$tanggal=WKT(date("Y-m-d"));
$pro="simpan";

?>

<?php
$id="";
$nama="";
$alamat="";

if(isset($_GET["pro"]) && ($_GET["pro"]=="update")){
$pro="update";
if (isset($_GET["kode"])) {
$kode = $_GET['kode'];
$sql="SELECT * FROM member WHERE `id` = '$kode'";
$jum=getJum($conn,$sql);
if ($jum>0) {
$d=getField($conn,$sql);
$member = array();

$id=$d["id"];$member["id"] = $id;
$nama=$d["nama"];$member["nama"] = $nama;
$alamat=$d["alamat"];$member["alamat"] = $alamat;

$respon["sukses"] = 1;
$respon["member"] = array();

array_push($respon["member"], $member);//tambahkan array 'mebmer' pada array final 'respon'
$respon["pesan"] = "$jum member";
echo json_encode($respon);// memprint/mencetak JSON respon
} else {
$respon["sukses"] = 0;
$respon["pesan"] = "0 member";
echo json_encode($respon);
}

} else {
$respon["sukses"] = 0;
$respon["pesan"] = "? lengkapi data";
echo json_encode($respon);
}

}

if(isset($_GET["pro"]) && ($_GET["pro"]=="add"||$_GET["pro"]=="update")){
?>
<br>
<h1>Data Anggota</h1>
<form action="" method="post" enctype="multipart/form-data">
<table width="40%" >
<tr>
<td height="24"><label for="nama">nama</label>
<td>:<td><input name="nama" type="text" id="nama" value="<?php echo $nama;?>" size="25" />
</td>
</tr>

<tr>
<td height="24"><label for="alamat">alamat</label>
<td>:<td><input name="alamat" type="text" id="alamat" value="<?php echo $alamat;?>" size="25" />
</td>
</tr>

<tr>
<td>
<td>
<td colspan="2"><input name="Simpan" type="submit" id="Simpan" value="Simpan" />
        <input name="pro" type="hidden" id="pro" value="<?php echo $pro;?>" />
        <input name="id0" type="hidden" id="id0" value="<?php echo $id0;?>" />
<input name="pro" type="hidden" id="pro" value="<?php echo $pro;?>" />
        <a href="?mnu=anggota"><input name="Batal" type="button" id="Batal" value="Batal" /></a>
</td></tr>
</table>
</form>
<hr>
<?php
}
?>

Tampilan saat kita klik tombol Update.....data yang lama akan muncul pada GUI dan siap di ubah...

<h1><a href="?mnu=anggota">LIST</a> | <a href="?mnu=anggota&pro=add">ADD</a> |  <a href="?mnu=anggota&pro=update&kode=1">UPDATE</a> | <a href="?mnu=anggota&pro=del&kode=1">DEL</a> </h1>
<?php
$respon = array();
$sql="SELECT * FROM `member` order by `id` desc";
$jum=getJum($conn,$sql);
if ($jum> 0) {
    $respon["member"] = array();
$arr=getData($conn,$sql);
foreach($arr as $d) {
        $member = array();
        $member["id"] = $d["id"];
        $member["nama"] = $d["nama"];
        $member["alamat"] = $d["alamat"];
       
        array_push($respon["member"], $member);       //tambahkan array 'member' pada array final 'respon'
    }
    // sukses
    $respon["sukses"] = 1;
$respon["pesan"] = "$jum member";
    echo json_encode($respon);
} else {
    // jika data kosong
$respon["member"]="";
    $respon["sukses"] = 0;
    $respon["pesan"] = "0 member";
    echo json_encode($respon);
}
?>

<?php
if(isset($_POST["Simpan"])){
$nama = $_POST['nama'];
    $alamat = $_POST['alamat'];

if($pro=="simpan"){$sql="INSERT INTO `member`(`nama`, `alamat`) VALUES('$nama', '$alamat')";

   $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);
    }
if($simpan) {echo "<script>alert('Data $kode_admin berhasil disimpan !');document.location.href='?mnu=anggota';</script>";}
else{echo"<script>alert('Data $kode_admin gagal disimpan...');document.location.href='?mnu=anggota';</script>";}
}
else{
$sql="UPDATE `member` SET `nama` = '$nama', `alamat` = '$alamat' WHERE `id` = $kode";
    $ubah=process($conn,$sql);

    if ($simpan) {
        $respon["sukses"] = 1;
        $respon["pesan"] = "1 sukses tambah.";    
        echo json_encode($respon);
    } else {
        $respon["sukses"] = 0;
        $respon["pesan"] = "Gagal update data.";
        echo json_encode($respon);
    }
if($ubah) {echo "<script>alert('Data $kode_admin berhasil diubah !');document.location.href='?mnu=anggota';</script>";}
else{echo"<script>alert('Data $kode_admin gagal diubah...');document.location.href='?mnu=anggota';</script>";}
}//else simpan
}
?>

<?php
if($_GET["pro"]=="del"){
$id=$_GET["kode"];
$sql="delete from `member` where `id`='$id'";
$hapus=process($conn,$sql);
if($hapus) {echo "<script>alert('Data $id berhasil dihapus !');document.location.href='?mnu=anggota';</script>";}
else{echo"<script>alert('Data $id gagal dihapus...');document.location.href='?mnu=anggota';</script>";}
}
?>

Cukup 1 tampilan bisa untuk CRUD sekaligus :-)

Download Source Code