56 lines
1.4 KiB
PHP
56 lines
1.4 KiB
PHP
<?php
|
|
include('../../koneksi.php');
|
|
$key=$_POST['key'];
|
|
if ($key=='simpan_ket') {
|
|
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
|
|
$ket_acara=$_POST['ket_acara'];
|
|
$upd=pg_query("UPDATE riwayat_kegiatan SET ket_acara='$ket_acara' WHERE id='$riwayat_kegiatan_id'");
|
|
} else
|
|
if ($key=='simpan_jadwal') {
|
|
$id=$_POST['id'];
|
|
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
|
|
$hari_ke=$_POST['hari_ke'];
|
|
$waktu_mulai=$_POST['waktu_mulai'];
|
|
$waktu_selesai=$_POST['waktu_selesai'];
|
|
$materi=$_POST['materi'];
|
|
$pj=$_POST['pj'];
|
|
$keterangan=$_POST['keterangan'];
|
|
|
|
|
|
$cek_add=pg_query("SELECT id FROM jadwal_kegiatan WHERE id='$id'");
|
|
$row_add = pg_fetch_row($cek_add);
|
|
if ($row_add[0] > 0) {
|
|
$upd_add = pg_query("UPDATE jadwal_kegiatan SET
|
|
hari_ke='$hari_ke',
|
|
waktu_mulai='$waktu_mulai',
|
|
waktu_selesai='$waktu_selesai',
|
|
materi='$materi',
|
|
pj='$pj',
|
|
keterangan='$keterangan'
|
|
WHERE id='$id'");
|
|
} else {
|
|
$ins_add = pg_query("INSERT into jadwal_kegiatan (
|
|
riwayat_kegiatan_id,
|
|
hari_ke,
|
|
waktu_mulai,
|
|
waktu_selesai,
|
|
materi,
|
|
pj,
|
|
keterangan
|
|
) values(
|
|
'$riwayat_kegiatan_id',
|
|
'$hari_ke',
|
|
'$waktu_mulai',
|
|
'$waktu_selesai',
|
|
'$materi',
|
|
'$pj',
|
|
'$keterangan'
|
|
)
|
|
");
|
|
}
|
|
} else
|
|
if ($key=='hapus_data') {
|
|
$id=$_POST['id'];
|
|
$del=pg_query("DELETE FROM jadwal_kegiatan WHERE id='$id'");
|
|
}
|
|
?>
|