How can I remove orphan files?

[cadkins23]

After removing more than 1,000 videos I see my code does not remove the actual file from the server, only database references.

So now I have more than 1,000 videos on my server that shouldn't be there.

If I look at sample rows in my database for existing videos I can see the naming convention is like this:

Video Id: 13
Video url: videos/2006/145-13.wmv
thumbnail: videos/2006/145-13.jpg

As you can see the video id is stored in the video and thumb filenames.

I'm not exactly sure how to write code to disect filenames on my server, take out the number between the dash and the period and then check the database for the video id and if it doesn't exist delete the file on the server.

Can anyone point me in the right direction or provide a simple code sample? I don't imagine it should be too difficult.

Thank you in advance

Chris

[etully]

<?php

$path = realpath('/path/to/your/videos/2006');

$objects = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($path),
RecursiveIteratorIterator::SELF_FIRST);

foreach($objects as $name => $object){
    if (ereg($path."/([0-9]+)-([0-9]+)\.wmv",$name,$regs)) {

        $first_digits = $regs[1];
        // in your example, $first_digits would be 145

        $second_digits = $regs[2];
        // in your example, $video_id would be 13

        $query = "select id from video_table where id=$second_digits";
        $result = mysql_query($query);

        if (mysql_num_rows($result)==0) { // delete the file
            // run this file once to see if it's working right.
            // then uncomment the unlink commands and run it again
            // to blow away the orphans
            // unlink($path."/".$first_digits."-".$second_digits.".wmv");
            // unlink($path."/".$first_digits."-".$second_digits.".jpg");

            echo "I dont' see " . $first_digits."-".$second_digits.".wmv in ";
            echo "in the db so I'm gonna delete it<br>";
        }
        else {
            echo  $first_digits."-".$second_digits.".wmv is in the db so not ";
            echo "gonna delete it<br>";
        }
}

?>

Regular expressions (using the ereg command) are able to find things in strings.

The code finds the number before the hyphen and it finds the number after the hyphen. Then it looks it up in the database. If it DOES NOT exist in the database, then it deletes the file and the thumb.

Edit: Whenever you are going to use a script to mass delete stuff, use echo statements to show precisely what the unlink command will do. I may have made a typo when I wrote the script above and it would be better to discover that typo in an echo command rather than have my script wipe out an entire directory or a bunch of good files.

• Eric

[Kudose]

cough
ereg is bad, use preg ... ereg is deprecated and will not be included in PHP6
cough*

[etully]

Sigh.

I'm so old school.

Yes, look at preg. It's faster.