
最近在整理网站内容时,发现之前发布的一些文章内容已经失效,删除文章时,文章对应的媒体文件无法同事被删除掉,于是就在网上搜索了一番,最终找到了解决方法。
如何在Wordpress删除文章的同时删除媒体文件呢?
首先找到Wordpress站点的主题文件中的functions.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');