Form Pengaduan
connect_error) {
die("Koneksi database gagal: " . $koneksi->connect_error);
}
// Ambil data dari form
$nama = $_POST['nama'];
$nip = $_POST['nip'];
$golongan = $_POST['golongan'];
$tempat_tugas = $_POST['tempat_tugas'];
$alamat_rumah = $_POST['alamat_rumah'];
$email_aktif = $_POST['email_aktif'];
$no_hp = $_POST['no_hp'];
$uraian_aduan = $_POST['uraian_aduan'];
$penjelasan_tambahan = $_POST['penjelasan_tambahan'];
// Upload bukti PDF
$file_name = $_FILES['bukti_pdf']['name'];
$file_tmp = $_FILES['bukti_pdf']['tmp_name'];
$file_ext = strtolower(pathinfo($file_name, PATHINFO_EXTENSION));
// ...
// Simpan data ke database
$sql = "INSERT INTO pengaduan (nama, nip, golongan, tempat_tugas, alamat_rumah, email_aktif, no_hp, uraian_aduan, penjelasan_tambahan, bukti_pdf) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = $koneksi->prepare($sql);
if (!$stmt) {
die("Error in prepare: " . $koneksi->error);
}
// Mengubah tipe data parameter sesuai dengan perubahan ke "varchar" untuk kolom bukti_pdf
$stmt->bind_param("ssssssssss", $nama, $nip, $golongan, $tempat_tugas, $alamat_rumah, $email_aktif, $no_hp, $uraian_aduan, $penjelasan_tambahan, $file_name);
if ($stmt->execute()) {
// Pindahkan file PDF ke folder tertentu
$upload_dir = "uploads/";
move_uploaded_file($file_tmp, $upload_dir . $file_name);
} else {
echo "Error: " . $stmt->error;
}
// Tutup koneksi
$stmt->close();
$koneksi->close();
}
?>
