Code to delete all images from WordPress or nearly all

The other day I had a bit of a nightmare with a plugin that looped and created multiple images, in fact thousands of them.

I got bored with trying to delete them manually so wrote some code quickly.

The first thing was how to write code that runs using wordpress, you can use technique simply to load wordpress

// Include the wp-load'er
include('wp-load.php');

1 2	// Include the wp-load'er include('wp-load.php');

once loaded you can then use all the WordPress functions

First I want to get all the attachments, these are just post types so it is matter of calling get_posts

$args= array(
  'post_type'      => 'attachment', // obvious
  'posts_per_page' => -1            // get them all 
);

// get all attachments post ids
$posts = get_posts( $args );

$args= array(

'post_type' => 'attachment', // obvious

'posts_per_page' => -1 // get them all

);

// get all attachments post ids

$posts = get_posts( $args );

Then a loop getting the image data

foreach ($posts as $post_id) {
   // get an array of image data
   $image_attributes = wp_get_attachment_image_src( $post_id->ID );
   // do stuff
}

foreach ($posts as $post_id) {

// get an array of image data

$image_attributes = wp_get_attachment_image_src( $post_id->ID );

// do stuff

}

In this case I wanted to only delete images that had a certain string so I can do this with strpos to identify the right image by string and wp_delete_attachment to delete it. Of course you could use preg_match for complex matching http://php.net/manual/en/function.preg-match.php

if (strpos($image_attributes[0], 'mystring') !== false){
   echo 'Image Found : '.$image_attributes[0];
   if (false === wp_delete_attachment( wp_delete_attachment( $post_id->ID, true ) ) ) {
       echo ' and delete failed!<br>';
     } else {
       echo ' and delete succeeded!<br>';
     }
   }

if (strpos($image_attributes[0], 'mystring') !== false){

echo 'Image Found : '.$image_attributes[0];

if (false === wp_delete_attachment( wp_delete_attachment( $post_id->ID, true ) ) ) {

echo ' and delete failed!<br>';

} else {

echo ' and delete succeeded!<br>';

}

Add it all together and you get something like this. Be careful, use at your own risk, and always backup your database first. (I’d recommend commenting out the delete first too, to make sure )

<?php
/*  create this code in a file in the main wordpress directory e.g. delmedia.php
    and access it via mydomain.com/delmedia.php
*/
// Include the wp-load'er
include('wp-load.php');
$args= array(
  'post_type'      => 'attachment', // obvious
  'posts_per_page' => -1            // get them all 
);

// get all attachments post ids
$posts = get_posts( $args );
foreach ($posts as $post_id) {
   // get an array of image data
   $image_attributes = wp_get_attachment_image_src( $post_id->ID );
   if (strpos($image_attributes[0], 'mystring') !== FALSE){
   echo 'Image Found : '.$image_attributes[0];
   if (false === wp_delete_attachment( wp_delete_attachment( $post_id->ID, true ) ) ) {
       echo ' and delete failed!<br>';
     } else {
       echo ' and delete succeeded!<br>';
     }
   }
}
?>

<?php

/* create this code in a file in the main wordpress directory e.g. delmedia.php

and access it via mydomain.com/delmedia.php

// Include the wp-load'er

include('wp-load.php');