[SOLVED] remove file/mysql row in a week of its upload

[dezkit]

is there a way to remove a file in a directory in a week from its upload, and at the same time, remove the mysql row of it?

[DarkWater]

Uhh, this should get you started:

 

<?php
foreach (glob('yourdirectory/*') as $filename) {
    if (filemtime($filename) < (time() - 86400)) {
        unlink($filename);
        $sql = "DELETE FROM uploads WHERE filename='$filename'";
        mysql_query($sql) or die(mysql_error());
    }
}
?>

[FIREBALL5]

PHP scripts have to be run though. It won't execute that code automatically.

[dezkit]

Thanks a bunch darkwater, ill try that

[DarkWater]

PHP scripts have to be run though. It won't execute that code automatically.

 

Cron.