28 lines
1.3 KiB
PHP
28 lines
1.3 KiB
PHP
<?php
|
|
print_r($_POST);
|
|
include("../../koneksi.php");
|
|
$syarat_spo_id=$_POST['syarat_spo_id_uploadz'];
|
|
$riwayat_spo_id=$_POST['riwayat_spo_id_uploadz'];
|
|
$cek_satker=pg_query("SELECT id FROM riwayat_syarat_spo WHERE riwayat_spo_id=$riwayat_spo_id AND syarat_spo_id=$syarat_spo_id");
|
|
$row_satker = pg_fetch_row($cek_satker);
|
|
if ($row_satker[0] > 0) {} else {
|
|
pg_query("INSERT INTO riwayat_syarat_spo (riwayat_spo_id,syarat_spo_id) VALUES ('$riwayat_spo_id','$syarat_spo_id')");
|
|
}
|
|
$d1=pg_query("SELECT id FROM riwayat_syarat_spo WHERE riwayat_spo_id=$riwayat_spo_id AND syarat_spo_id=$syarat_spo_id");
|
|
while($r1=pg_fetch_array($d1)) {$riwayat_syarat_spo_idxx=$r1[0];}
|
|
|
|
//$riwayat_syarat_spo_id=$_POST['riwayat_syarat_spo_id_uploadz'];
|
|
$riwayat_syarat_spo_id=$riwayat_syarat_spo_idxx;
|
|
$folder = "pdf";
|
|
$tmp_name = $_FILES["input_load_cvz"]["tmp_name"];
|
|
$name = $folder."/".$riwayat_syarat_spo_id."_".$_FILES["input_load_cvz"]["name"];
|
|
$name_pdf = $riwayat_syarat_spo_id."_".$_FILES["input_load_cvz"]["name"];
|
|
|
|
move_uploaded_file($tmp_name, $name);
|
|
$ins=pg_query("INSERT INTO dok_syarat_spo (riwayat_syarat_spo_id,file,tgl_upload) VALUES ('$riwayat_syarat_spo_id','$name_pdf',NOW())");
|
|
$upd=pg_query("UPDATE riwayat_syarat_spo SET tgl_upload_dok=NOW() WHERE id=$riwayat_syarat_spo_id");
|
|
echo $riwayat_syarat_spo_id.' - '.$name_pdf;
|
|
?>
|
|
|
|
|