<?php
print_r($_POST);
include("../../koneksi.php");
$syarat_kbel_id=$_POST['syarat_kbel_id_uploadz'];
$riwayat_kbel_id=$_POST['riwayat_kbel_id_uploadz'];
$cek_satker=pg_query("SELECT id FROM riwayat_syarat_kbel WHERE riwayat_kbel_id=$riwayat_kbel_id AND syarat_kbel_id=$syarat_kbel_id");
$row_satker = pg_fetch_row($cek_satker);
if ($row_satker[0] > 0) {} else {
pg_query("INSERT INTO riwayat_syarat_kbel (riwayat_kbel_id,syarat_kbel_id) VALUES ('$riwayat_kbel_id','$syarat_kbel_id')");
}
$d1=pg_query("SELECT id FROM riwayat_syarat_kbel WHERE riwayat_kbel_id=$riwayat_kbel_id AND syarat_kbel_id=$syarat_kbel_id");
while($r1=pg_fetch_array($d1)) {$riwayat_syarat_kbel_idxx=$r1[0];}

//$riwayat_syarat_kbel_id=$_POST['riwayat_syarat_kbel_id_uploadz'];
$riwayat_syarat_kbel_id=$riwayat_syarat_kbel_idxx;
$folder = "pdf";
$tmp_name = $_FILES["input_load_cvz"]["tmp_name"];
$name = $folder."/".$riwayat_syarat_kbel_id."_".$_FILES["input_load_cvz"]["name"];
$name_pdf = $riwayat_syarat_kbel_id."_".$_FILES["input_load_cvz"]["name"];

move_uploaded_file($tmp_name, $name);
$ins=pg_query("INSERT INTO dok_syarat_kbel (riwayat_syarat_kbel_id,file,tgl_upload) VALUES ('$riwayat_syarat_kbel_id','$name_pdf',NOW())");
$upd=pg_query("UPDATE riwayat_syarat_kbel SET tgl_upload_dok=NOW() WHERE id=$riwayat_syarat_kbel_id");
echo $riwayat_syarat_kbel_id.' - '.$name_pdf;
?>