Files
2024-08-13 05:44:19 +00:00

59 lines
1.2 KiB
PHP

<?php
include('../../koneksi.php');
$key=$_POST['key'];
if ($key=='simpan_mprodi') {
$id=$_POST['id'];
$nama=$_POST['nama'];
$cek_satker=pg_query("SELECT id FROM prodi WHERE id='$id'");
$row_satker = pg_fetch_row($cek_satker);
if ($row_satker[0] > 0) {
$upd_satker = pg_query("UPDATE prodi SET
nama='$nama'
WHERE id='$id'");
} else {
$ins_satker = pg_query("INSERT into prodi (
nama
) values(
'$nama'
)
");
}
} else
if ($key=='simpan_mjurusan') {
$id=$_POST['id'];
$nama=$_POST['nama'];
$cek_satker=pg_query("SELECT id FROM jurusan WHERE id='$id'");
$row_satker = pg_fetch_row($cek_satker);
if ($row_satker[0] > 0) {
$upd_satker = pg_query("UPDATE jurusan SET
nama='$nama'
WHERE id='$id'");
} else {
$ins_satker = pg_query("INSERT into jurusan (
nama
) values(
'$nama'
)
");
}
} else
if ($key=='simpan_muniv') {
$id=$_POST['id'];
$nama=$_POST['nama'];
$cek_satker=pg_query("SELECT id FROM univ WHERE id='$id'");
$row_satker = pg_fetch_row($cek_satker);
if ($row_satker[0] > 0) {
$upd_satker = pg_query("UPDATE univ SET
nama='$nama'
WHERE id='$id'");
} else {
$ins_satker = pg_query("INSERT into univ (
nama
) values(
'$nama'
)
");
}
}
?>