Delete files based on file records in the database
Release： 2016-07-25 09:11:32
Original
1124 people have browsed it
Determine whether the fields in the database correspond to the files in the folder. If there is no correspondence, delete the files, which greatly reduces the occupation of system resources.
- //Created on 2010-4-24 Made by Wolf QQ116311316
- //Function: It is to determine whether the fields in the database correspond to the files in the folder. If there is no correspondence
- //then Deleting files greatly reduces system resource usage.
- //$dir is the file directory to be searched
- //$table is the table to be searched
- //$field is the field name
- //================ ====
- function delfile($dir = "",$table,$field){
- //Get the files in the directory
- if (is_dir($dir)) {
- if ($dh = opendir($ dir)) {
- while (($file = readdir($dh)) !== false) {
- if($file!="."&&$file!=".."){
- $exit[ ]=$file;}
- }
- closedir($dh);
- }
- }
- //Get the file image address in the database
- $sql="select $field from $table";
- $query=mysql_query ($sql);
- while($row=mysql_fetch_array($query)){
- $pic[]=$row[pic];
- }
- //The function here is very important. array_diff_key was originally used. There seems to be something wrong
- $result = @array_diff($exit, $pic);
- if($result==null){
- echo "You have no files to delete";
- }
- foreach($result as $id=>$values){
-
-
- echo "The file deleted by the system is ".$values."
";
- $file=$dir.$values;
- unlink("$file") ;
-
-
- }
-
-
-
- }
-
- ?>
|
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
-
2024-09-20 15:51:33
-
2024-09-20 15:47:32
-
2024-09-20 15:45:32
-
2024-09-20 15:39:32
-
2024-09-20 15:38:32
-
2024-09-20 15:27:32
-
2024-09-20 15:26:32
-
2024-09-20 15:12:32
-
2024-09-20 14:53:01
-
2024-09-20 14:51:01
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
