Create wprdpress posts by csv with featured image by code.

• 2024-04-17
• 151

• Posted by Avi

<?php
// Include WordPress bootstrap file
require_once 'wp-load.php';

// Path to your CSV file
$csv_file = '1.csv';

// Function to download and attach the image to the post
function attach_featured_image($post_id, $image_url) {
    // Download the image from the URL
    $image_contents = file_get_contents($image_url);
    
    if ($image_contents !== false) {
        // Get the filename from the URL
        $filename = basename($image_url);
        
        // Upload the image to the WordPress media library
        $upload = wp_upload_bits($filename, null, $image_contents);
        
        if (!$upload['error']) {
            // Prepare the attachment data
            $attachment_data = array(
                'post_mime_type' => $upload['type'],
                'post_parent' => $post_id,
                'post_title' => sanitize_file_name(pathinfo($filename, PATHINFO_FILENAME)),
                'post_content' => '',
                'post_status' => 'inherit'
            );
            // Insert the attachment into the database
            $attach_id = wp_insert_attachment($attachment_data, $upload['file']);
            // Set the featured image
            if (!is_wp_error($attach_id)) {
                set_post_thumbnail($post_id, $attach_id);
                return true;
            } else {
                return false;
            }
        }
    }
    return false;
}




// Open the CSV file for reading
if (($handle = fopen($csv_file, 'r')) !== false) {
    // Loop through each row in the CSV file
    while (($data = fgetcsv($handle, 1000, ',')) !== false) {
        // Extract data from CSV row
        $post_title    = $data[0]; // Assuming first column is post title        
        $custom_field1 = $data[1]; // Assuming fourth column is custom field 1 value
        $custom_field2 = $data[2]; // Assuming fifth column is custom field 2 value
        $custom_field3 = $data[3]; // Assuming fifth column is custom field 2 value
        $custom_field4 = $data[4]; // Assuming fifth column is custom field 2 value
        $image_url     = $data[5]; // Assuming third column is image URL
        $post_content  = $data[6]; // Assuming second column is post content        
        
        // Add more custom fields as needed
        //title   seo_title   seo_description keyword published_at    featured_image  content

        // Create post array with custom fields

        $existing_post = get_page_by_title($post_title, OBJECT, 'post');

        if ($existing_post) {
                    // Post already exists, update the post content and featured image
                    $post_id = $existing_post->ID;
                    $post_data = array(
                        'ID'           => $post_id,
                        'post_content' => $post_content,
                    );
                    wp_update_post($post_data);

                    // Attach featured image if URL is provided
                    if (!empty($image_url) && !is_wp_error($post_id)) {
                        attach_featured_image($post_id, $image_url);
                    }
                    
                    echo "Post updated: $post_title<br>";
                } else {

                    $new_post = array(
                        'post_title'   => $post_title,
                        'post_content' => $post_content,
                        // Add more fields as needed
                        'post_status'  => 'publish', // You can change post status if needed
                        'post_author'  => 1, // Change the author ID if needed
                        'post_type'    => 'post', // Change the post type if needed
                        'meta_input'   => array(
                            'seo_title'       => $custom_field1,
                            'seo_description' => $custom_field2,
                            'keyword'         => $custom_field3,
                            'published_at'    => $custom_field4,
                            'featured_img'    => $image_url,
                            // Add more custom fields as needed
                        ),
                    );
                }

        // Insert the post into the database
        $post_id = wp_insert_post($new_post);

        // Attach featured image if URL is provided
        if (!empty($image_url) && !is_wp_error($post_id)) {
            attach_featured_image($post_id, $image_url);
        }
        // Handle errors if any
        if (is_wp_error($post_id)) {
            $errors = $post_id->get_error_messages();
            foreach ($errors as $error) {
                echo $error . '<br>';
            }
        }
    }
    // Close the CSV file
    echo "CSV uploaded successfully!";
    fclose($handle);
} else {
    echo 'Error opening CSV file';
}
?>

• Php
• Wordpress