28 lines
667 B
PHP
28 lines
667 B
PHP
<?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'");
|
|
}
|
|
?>
|