<?php 
include('../../koneksi.php');
$key=$_POST['key'];

if ($key=='simpan_jns_pejabat') {
$id=$_POST['id'];
$nama=$_POST['nama'];

$cek_jns_pejabat=pg_query("SELECT id FROM sp_jenis_pejabat WHERE id='$id'");
 $row_jns_pejabat = pg_fetch_row($cek_jns_pejabat);
 if ($row_jns_pejabat[0] > 0) {
 $upd_jns_pejabat = pg_query("UPDATE sp_jenis_pejabat SET 
 	nama='$nama'
 	WHERE id='$id'");
 } else {
 $ins_jns_pejabat = pg_query("INSERT into sp_jenis_pejabat (
 	nama
 	) values(
 	'$nama'
 	)
 ");
 }
} else
if ($key=='delete_jns_pejabat') {
$id=$_POST['id'];
 $del_jns_pejabat = pg_query("DELETE FROM sp_jenis_pejabat WHERE id='$id'");
}
?>