5000000) { // 5MB limit
echo "Error: File size too large";
$upload_ok = false;
}
// Allow only certain file types
$allowed_types = array("pdf", "doc", "docx", "txt");
$file_type = strtolower(pathinfo($target_file, PATHINFO_EXTENSION));
if (!in_array($file_type, $allowed_types)) {
echo "Error: Invalid file type";
$upload_ok = false;
}
if ($upload_ok) {
// File uploaded successfully, insert file information into the sup_supdoc table
$docno = $_POST['docno'];
$filename = basename($_FILES["file"]["name"]);
$uploaddate = date('Y-m-d H:i:s'); // Assuming uploaddate is the current date/time
// Get the highest sequence number for the current document number
$query = "SELECT MAX(seqno) AS max_seqno FROM bankout_supdoc WHERE docno = '$docno'";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_assoc($result);
$seqno = $row['max_seqno'] + 1; // Increment the sequence number by 1
// Insert file information into the sup_supdoc table
$sql = "INSERT INTO bankout_supdoc (docno, seqno, filename, uploaddate) VALUES ('$docno', '$seqno', '$filename', '$uploaddate')";
if (mysqli_query($conn, $sql)) {
echo "The file " . htmlspecialchars($filename) . " has been uploaded and its information has been added to the sup_supdoc table.";
} else {
echo "Sorry, there was an error uploading your file.";
}
// Close the database connection
mysqli_close($conn);
header("Location: uploadbank.php"); // Redirect back to upload.php
exit; // Exit the script to prevent any further output
} else {
// Error while uploading file
echo "Sorry, there was an error uploading your file.";
}
}
?>
Upload Document - Perbelanjaan