WordPress Tutorial: How to Delete Posts and Remove Image Attachments and Featured Images

For friends who use WordPress to build websites, you know that for some articles that you feel are outdated or you don’t like them, you want to delete them. However, when you delete the article, generally speaking, the pictures and other attachments uploaded to the media library in the article cannot be deleted. will be deleted automatically. Such long-term accumulation takes up a lot of resources. So how do you delete image attachments and featured images while deleting articles? The following code can automatically delete article image attachments and featured images when deleting an article, so that you don't have to manually search for and delete them in the media library, which is accurate and efficient. Place the code in the current theme's functions.php file to delete article image attachments.

/* Delete image attachments when deleting articles

/* ———————— */

function delete_post_and_attachments($post_ID) {

global $wpdb;

//Delete featured image

$thumbnails = $wpdb->get_results( “SELECT * FROM $wpdb->postmeta WHERE meta_key = ‘_thumbnail_id’ AND post_id = $post_ID” );

foreach ( $thumbnails as $thumbnail ) {

wp_delete_attachment( $thumbnail->meta_value, true );

}

//Delete image attachments

$attachments = $wpdb->get_results( “SELECT * FROM $wpdb->posts WHERE post_parent = $post_ID AND post_type = ‘attachment’” );

foreach ( $attachments as $attachment ) {

wp_delete_attachment( $attachment->ID, true );

}

$wpdb->query( “DELETE FROM $wpdb->postmeta WHERE meta_key = ‘_thumbnail_id’ AND post_id = $post_ID” );

}

add_action(‘before_delete_post’, ‘delete_post_and_attachments’);

The above code is feasible after testing. If you like to mess with it, you can give it a try! However, this website suggests that it is best to back up your original data before trying it!

Recommended site searches: Jiangxi server rental, vps server, space rental, php space rental, website space rental, free web server website, telecom ip proxy, best US server, mainland China dynamic ip proxy, US website space,