?
Solved

PHP delete smaller files

Posted on 2013-06-29
13
Medium Priority
?
202 Views
Last Modified: 2013-06-29
Hello,

I am not sure if this is possible but I am optimistic.

I have an images folder with 75,000 images. I had a db that separated them as origina/small/thumb but I lost the db.

I now have one images folder with 3 versions of each file and I need to strip out the small and thumbs and just keep the originals.

Is there a way to query the folder and keep the largest file size of each filename and delete the other 2?

example

1221-93939a-280-510.jpg
1221-93939a-180-180.jpg
1221-93939a-580-720.jpg


175753-a344va-280-500.jpg
175753-a344va-180-160.jpg
175753-a344va-580-735.jpg

I used this code to echo the file names in the folder.

<?php
 foreach(glob('./images/*.*') as $filename){
     echo $filename;
 } 
?>

Open in new window

0
Comment
Question by:movieprodw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 5
13 Comments
 
LVL 58

Expert Comment

by:Gary
ID: 39287064
Whats the common denominator to identify the image groups?
Is it this bit 175753-a344va and 1221-93939a
Is there something in the filename to identify the size?
0
 
LVL 1

Author Comment

by:movieprodw
ID: 39287070
the common pattern would be the -xxx-xxx.jpg
0
 
LVL 58

Expert Comment

by:Gary
ID: 39287089
Hmmm, the examples you gave xxx-xxx,jpg is not common this bit is 175753-a344va.
Also asking do the numbers 280/500, 180/160, 580/735 represent the sizes or something in this block.

175753-a344va-280-500.jpg
175753-a344va-180-160.jpg
175753-a344va-580-735.jpg
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 1

Author Comment

by:movieprodw
ID: 39287099
Yeah, well the are in that pattern but they do not always match, the beginning number does.

for example I would like to delete all that are ending in

-320-xxx.jpg
0
 
LVL 1

Author Comment

by:movieprodw
ID: 39287107
I found this, not sure if it helps.

// Get a list of all CSV files in your folder.
$csv = glob("*.csv");

// Sort them by modification date.
usort($csv, function($a, $b) { return filemtime($a) - filemtime($b); });

// Remove the newest from your list.
array_pop($csv);

// Delete all the rest.
array_map('unlink', $csv);

Open in new window

0
 
LVL 58

Expert Comment

by:Gary
ID: 39287109
You've lost me now, you have 3 images - thumb/small/original - what part of the filename is the same for all 3 images but unique from other images?
Is the 280,180,580 in the filenames something to do with the size - these seem to be consistent in your filenames.

x-x-280-510.jpg
x-x-180-180.jpg
x-x-580-720.jpg
0
 
LVL 1

Author Comment

by:movieprodw
ID: 39287119
Hello,

Yes they are the file size, the width is consistent but the height is not.

Sorry for being confusing.

Ideally it could grab the 'x' part and compare it to the 'y' part then delete the smaller and keep the larger. xxxxxx-xxxxxx-yyy-yyy.jpg

But if you have a way to delete by pattern such as explode filename and unset if $filename[2] = '280' then that would be great too.

Matt
0
 
LVL 58

Expert Comment

by:Gary
ID: 39287141
Just to be sure
x-x-280-510.jpg

the 280 represents the width and the 510 is the height

All images have a width of either
180, 280 or 580px

So we can delete all images with a width of 180 or 280px

<?php
$dir = "images/*";  
  
$pattern1 = '/.*?(180)([-+]\d+)(.)(jpg)/';
$pattern2 = '/.*?(280)([-+]\d+)(.)(jpg)/';

foreach(glob($dir) as $file)

{
if(preg_match($pattern1, $file) || preg_match($pattern2, $file)){

     echo $file.'<br>';
}

}

Open in new window


This doesn't delete the files - I just want you to test it shows the correct files for deletion
0
 
LVL 1

Author Comment

by:movieprodw
ID: 39287147
That does show the correct images to delete.
0
 
LVL 58

Accepted Solution

by:
Gary earned 2000 total points
ID: 39287158
If you are absolutely sure then replace
echo $file.'<br>';

Open in new window

with
unlink($file);

Open in new window


You definitely sure...? ;o)
0
 
LVL 1

Author Closing Comment

by:movieprodw
ID: 39287160
Thank you Gary, you are always very helpful.

I have a backup so if I mess up I will reinstate it.

Thanks again.
Matt
0
 
LVL 1

Author Comment

by:movieprodw
ID: 39287290
I ran the script and it does not unlink them, could their be a permissions error?

Thanks
0
 
LVL 1

Author Comment

by:movieprodw
ID: 39287296
Got it, it was a permissions error.
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question