如何像WordPress和ACF那样在数据库中存储用户上传文件？

Absolutely yes—you need to create WordPress attachments for files uploaded via Caldera Forms if you want to tap into WordPress’s native media capabilities and integrate smoothly with ACF. Here’s why, plus how to pull it off:

Why Attachments Are Non-Negotiable #

• WordPress’s media handling relies on them: Attachments are the core post type WordPress uses to manage media files. Only by creating an attachment will WordPress automatically generate all configured image sizes, store file metadata (like size, type, upload date), and let you manage the file in the Media Library.
• ACF depends on attachment IDs: ACF’s image/file fields are designed to work with attachment IDs (not raw URLs). If you just save a file URL, you’ll lose access to ACF’s built-in features like returning different image sizes, pulling file metadata, or easily updating the file later.

Step-by-Step Implementation #

Here’s a practical example of how to convert a Caldera Forms upload into a WordPress attachment, then link it to ACF:

1. Retrieve the Uploaded File from Caldera Forms #

First, grab the file data from your Caldera Forms submission. The exact structure depends on your form setup, but it’ll usually include the temporary file path and filename:

// Get submission data (replace $submission_id with your actual submission ID)
$submission_data = Caldera_Forms::get_submission_data( $submission_id );
// Target your file field (replace 'your_file_field_slug' with your field's slug)
$caldera_file = $submission_data['fields']['your_file_field_slug'];

$temp_file_path = $caldera_file['file_path'];
$file_name = $caldera_file['name'];
$file_type = $caldera_file['type'];

2. Move the File to WordPress’s Uploads Directory #

Use WordPress’s native wp_handle_upload() to safely move the temporary file to the standard wp-content/uploads/[year]/[month] directory:

$upload_overrides = array(
    'test_form' => false, // Bypass default form validation (we trust Caldera's upload)
    'mimes' => wp_get_mime_types() // Use WordPress's allowed mime types
);

// Move the file
$upload_result = wp_handle_upload( $temp_file_path, $upload_overrides );

if ( $upload_result && ! isset( $upload_result['error'] ) ) {
    // File moved successfully—proceed to create attachment
} else {
    // Handle upload errors
    error_log( 'Caldera Forms upload error: ' . $upload_result['error'] );
    return;
}

3. Create the WordPress Attachment #

Use wp_insert_attachment() to register the file as an attachment post, then generate its metadata (including image sizes):

// Prepare attachment post data
$attachment_args = array(
    'guid'           => $upload_result['url'],
    'post_mime_type' => $upload_result['type'],
    'post_title'     => sanitize_file_name( $file_name ),
    'post_content'   => '',
    'post_status'    => 'inherit' // Attachments inherit status from their parent post
);

// Insert the attachment (replace $parent_post_id with your post ID, or use 0 for no parent)
$attach_id = wp_insert_attachment( $attachment_args, $upload_result['file'], $parent_post_id );

// Generate and save image metadata (only needed for image files)
if ( str_starts_with( $file_type, 'image/' ) ) {
    require_once ABSPATH . 'wp-admin/includes/image.php';
    $attach_metadata = wp_generate_attachment_metadata( $attach_id, $upload_result['file'] );
    wp_update_attachment_metadata( $attach_id, $attach_metadata );
}

4. Link the Attachment to ACF #

Finally, save the attachment ID to your ACF field (make sure your ACF field is set to store Attachment ID in its settings):

// Replace 'your_acf_image_field' with your ACF field's slug
update_field( 'your_acf_image_field', $attach_id, $parent_post_id );

Key Notes #

• Permissions: Ensure your WordPress uploads directory has correct write permissions so wp_handle_upload() can move files.
• Multiple Files: If your form allows multiple uploads, loop through each file in the Caldera Forms submission data and repeat the above steps for each.
• Cleanup: Caldera Forms may leave temporary files in its uploads directory—consider adding cleanup logic to delete them after creating the attachment.

内容的提问来源于stack exchange，提问作者mikemike