wordpress：文章删除时自动删除内容文章中的图片和附件内容

这个功能我还是很喜欢的因为前两天网站搬家，我检查了一下 uploads 图片文件夹，光图片就已经占用半个服务器空间，因此有了这个文章删除时自动删掉图片附件还是很香的，可以很大程度减缓服务器压力和时间成本。

wordpress-640x346.png" alt="1650599483 Wordpress" width="480" height="260" title="wordpress：文章删除时自动删除内容文章中的图片和附件内容 3" srcset="https://www.52pchome.com/wp-content/uploads/2019/08/1650599483-Wordpress-640x346.png 640w, https://www.52pchome.com/wp-content/uploads/2019/08/1650599483-Wordpress-820x443.png 820w, https://www.52pchome.com/wp-content/uploads/2019/08/1650599483-Wordpress-768x415.png 768w, https://www.52pchome.com/wp-content/uploads/2019/08/1650599483-Wordpress.png 1010w" sizes="(max-width: 480px) 100vw, 480px" />

只需将下面的 PHP 代码加入到主题目录下的functions.php 文件底部就可以了。

//删除文章时删除图片附件开始
function delete_post_and_attachments($post_ID) {
global $wpdb;
//删除特色图片
$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 );
}
//删除图片附件
$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');
//删除文章时删除图片附件结束