WordPress.org
Get WordPress
WordPress.org

WordPress Developer Resources

wp_delete_auto_drafts()

wp_delete_auto_drafts()

In this article

Back to top

Deletes auto-drafts for new posts that are > 7 days old.

Source

function wp_delete_auto_drafts() {
	global $wpdb;

	// Cleanup old auto-drafts more than 7 days old.
	$old_posts = $wpdb->get_col( "SELECT ID FROM $wpdb->posts WHERE post_status = 'auto-draft' AND DATE_SUB( NOW(), INTERVAL 7 DAY ) > post_date" );
	foreach ( (array) $old_posts as $delete ) {
		// Force delete.
		wp_delete_post( $delete, true );
	}
}

View all references View on Trac View on GitHub

UsesDescription
wp_delete_post()wp-includes/post.php

Trashes or deletes a post or page.

wpdb::get_col()wp-includes/class-wpdb.php

Retrieves one column from the database.

Changelog

VersionDescription
3.4.0Introduced.

User Contributed Notes

  1. Skip to note 2 content
    petruciucur
    You must log in to vote on the helpfulness of this noteVote results for this note: 0You must log in to vote on the helpfulness of this note

    Delete now without waiting 7 days

    function wp_delete_autodraft() {
    global $wpdb;
 
    // Delete auto-drafts.
    $old_posts = $wpdb->get_col( "SELECT ID FROM $wpdb->posts WHERE post_status = 'auto-draft'" );
    foreach ( (array) $old_posts as $delete ) {
        // Force delete.
        wp_delete_post( $delete, true );
    }
}
add_action( 'init', 'wp_delete_autodraft' );

You must log in before being able to contribute a note or feedback.