Risman Arisandy: Membuat kebutuhan API dari CRUD dalam 1 file menggunakan PHP

Dalam kesempatan kali ini saya berbagi salah satu contoh coding saya untuk menangani API, dimana kita akan membuat 1 file php untuk kebutuhan pengolahan 1 table di database. untuk pengembangan lebih lanjut teman-teman bisa kembangkan sendiri.

<?php
include('koneksi.php');

$act = $_GET['act'];
$index = 'id_laporan_harian';
$tabel = 'laporan_harian';
$limit = ($_GET['limit'] * 12) - 12;
$pesan = 'laporan harian';

// tambah / create
if ($act=='tambah'){
 $hasil = mysql_query("INSERT INTO $tabel(
                               id_user,
                               NAMA,
                                  NIP,
                                  KELAS_JABATAN,
                                  KODE_INSTANSI,
                                  JABATAN,
                                  INSTANSI,
                                  TEMPAT_DITETAPKAN
                                  ) 
                     VALUES(
                  '$_POST[id_user]',
                  '$_POST[NAMA]',
                                 '$_POST[NIP]',
                                 '$_POST[KELAS_JABATAN]',
                                 '$_POST[KODE_INSTANSI]',
                                 '$_POST[JABATAN]',
                                 '$_POST[INSTANSI]',
                                 '$_POST[TEMPAT_DITETAPKAN]')");
 if ($hasil){ 
     $respon["pesan"] = $pesan. ' berhasil ditambahkan';
 } 
 else {
     $respon["pesan"] = $pesan. ' gagal ditambahkan';
 } 
 echo json_encode($respon); 
}

// edit / update
elseif ($act=='edit'){
  $hasil =  mysql_query("UPDATE $tabel SET NAMA = '$_POST[NAMA]',
                                NIP = '$_POST[NIP]',
                                KELAS_JABATAN = '$_POST[KELAS_JABATAN]',
                                KODE_INSTANSI = '$_POST[KODE_INSTANSI]',
                                JABATAN = '$_POST[JABATAN]',
                                INSTANSI = '$_POST[INSTANSI]',
                               TEMPAT_DITETAPKAN = '$_POST[TEMPAT_DITETAPKAN]'
              WHERE id_laporan_harian = '$_POST[id_laporan_harian]'");  
 
 if ($hasil){ 
        $respon["pesan"] = $pesan. ' berhasil diupdate';
 } 
 else { 
        $respon["pesan"] = $pesan. ' gagal diupdate';
 } 
 echo json_encode($respon); 
}

// view / read
elseif ($act=='view'){
 $data = mysql_query("SELECT * 
                      FROM $tabel 
                      WHERE id_laporan_harian = '$_GET[id_laporan_harian]'
                      ORDER by id_laporan_harian desc");
 if (mysql_num_rows($data)>0){ 
  while ($row = mysql_fetch_assoc($data)){ 
  $respon[] = $row;
  } 
 } 
 else {

} 
 echo json_encode($respon,JSON_PRETTY_PRINT);
}

// Hapus / delete
elseif ($act=='delete'){
   $id_laporan_harian = $_POST['id_laporan_harian'];
   $hasil = mysql_query("DELETE 
                         FROM $tabel 
                         WHERE id_laporan_harian = $id_laporan_harian");
 if ($hasil){ 
    $respon["pesan"] = $pesan. ' berhasil di delete'; 
 } 
 else { 
      $respon["pesan"] = $pesan. ' gagal di delete';
 } 
 echo json_encode($respon); 
}

//========================= TABLE ===================================================
// table
elseif ($act=='table'){
 $data = mysql_query("SELECT *, 
                            DATE_FORMAT(TANGGAL_DITETAPKAN, '%d/%m/%Y') as TANGGAL_D 
                      FROM $tabel 
                      WHERE id_user= '$_GET[id_user]'
                      ORDER by TANGGAL_DITETAPKAN desc
                      LIMIT $limit,12");
 if (mysql_num_rows($data)>0){ 
  while ($row = mysql_fetch_assoc($data)){ 
  $respon["data"][] = $row;
  } 
 } 
    $data2 = mysql_query("SELECT (count($index) DIV 12) as JDIV, 
                                MOD(count($index),12) as JMOD 
                          FROM $tabel 
                          WHERE id_user = '$_GET[id_user]'");
  
     while ($row = mysql_fetch_array($data2)){  
     $respon["JDIV"] = $row["JDIV"];
     $respon["JMOD"] = $row["JMOD"];
     }
 echo json_encode($respon,JSON_PRETTY_PRINT);
}

//========================= CARI TABLE ================================================
// cari
elseif ($act=='cari'){
   $kata = $_GET['kata'];
   $limit =($_GET['limit'] * 12) - 12;
   
   $data = mysql_query("SELECT * FROM $table WHERE INSTANSI like '%$kata%' or NAMA_ATASAN like '%$kata%' order by id_laporan_harian desc  limit $limit,12");
   if (mysql_num_rows($data)>0){ 
    while ($row = mysql_fetch_assoc($data)){ 
    $respon["data"][] = $row;
    }  
   } 
     $data2 = mysql_query("SELECT (count(id_buku) DIV 12) as JDIV, MOD(count(id_buku),12) as JMOD FROM $table WHERE INSTANSI like '%$kata%' or NAMA_ATASAN like '%$kata%'");
  
     while ($row = mysql_fetch_array($data2)){  
     $respon["JDIV"] = $row["JDIV"];
     $respon["JMOD"] = $row["JMOD"];
     }
   echo json_encode($respon,JSON_PRETTY_PRINT);
  }

Risman Arisandy

Membuat kebutuhan API dari CRUD dalam 1 file menggunakan PHP

1 komentar:

Popular Posts

Arsip Blog