insert folder structure to mysql

[blodan]

This script simply inputs all folder names/lastchanged and file names/size/lastchanged into a mysql database, warning takes alot of time on folders with much files and subfolders.

To output the data you have gathered from this script in a nice browser you have to read this topic where i have posted my browser script

Line number On/Off | Expand/Contract | Select all

1. CREATE TABLE IF NOT EXISTS `files` (
2.   `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
3.   `folderid` BIGINT(20) NOT NULL,
4.   `name` TEXT NOT NULL,
5.   `size` BIGINT(20) NOT NULL,
6.   `lastchanged` INT(11) NOT NULL,
7.   PRIMARY KEY (`id`)
8. ) ENGINE=INNODB  DEFAULT CHARSET=latin1;
9.  
10. CREATE TABLE IF NOT EXISTS `folders` (
11.   `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
12.   `name` TEXT NOT NULL,
13.   `subfolder` BIGINT(20) NOT NULL,
14.   `lastchanged` INT(11) NOT NULL,
15.   PRIMARY KEY (`id`)
16. ) ENGINE=INNODB  DEFAULT CHARSET=latin1;

Line number On/Off | Expand/Contract | Select all

1. <?
2. $connecta = mysql_connect("host", "user", "password");
3. mysql_select_db("database");
4. $dir = "/jail/glftpd/site/";
5.  
6. function rd($dirr,$folderID) {
7.         if (is_dir($dirr)) {
8.                 if ($dh = opendir($dirr)) {
9.                         while (($file = readdir($dh)) !== false) {
10.                                 if($file != ".." && $file != ".") {
11.                                         if(filetype($dirr . $file) == "dir") {
12.                                                 echo "Folder: ".$dirr.$file."/\r\n";
13.                                                 mysql_query("insert into folders (name, subfolder, lastchanged) Values('".mysql_real_escape_string($file)."', '".$folderID."', '".mysql_real_escape_string(filemtime($dirr.$file))."')");
14.                                                 rd($dirr.$file."/", mysql_insert_id())."\r\n";
15.                                         }else{
16.                                                 echo "Filename: $file : filetype: " . filetype($dirr . $file) . "\r\n";
17.                                                 mysql_query("insert into files (name, folderid, size, lastchanged) Values('".mysql_real_escape_string($file)."', '".$folderID."', '".mysql_real_escape_string(filesize($dirr.$file))."', '".mysql_real_escape_string(filemtime($dirr.$file))."')");
18.                                         }
19.                                 }
20.                         }
21.                         closedir($dh);
22.                 }
23.         }
24. }
25.  
26. if (is_dir($dir)) {
27.         rd($dir,0);
28. }
29. mysql_close($connecta);
30. ?>

[butlins12]

This looks like it could be the answer to my head-scratching around a simple document management system for an extranet I'm doing - thanks. Just one thing - line 4 which sets the directory, is it based from the root of the web site, or the root of the FTP site?

[blodan]

This looks like it could be the answer to my head-scratching around a simple document management system for an extranet I'm doing - thanks. Just one thing - line 4 which sets the directory, is it based from the root of the web site, or the root of the FTP site?

Its the root from wherever its going to start reading folders/files, in this case its the root of the ftp site. I´ve only tried using this code with php-cli so i havent tried running it trough a webserver.

To display them you simply have to use the viewing script in the other thread thats linked to in this thread ( viewtopic.php?f=7&t=16&p=23 )

[butlins12]

If you save the following:

Line number On/Off | Expand/Contract | Select all

1. <?php
2. $p = getcwd();
3. echo $p;
4. ?>

as, say 'path.php' in the folder that your documents are saved in, and then browse to that file, then it'll return the absolute path that you need to enter as the variable in line 4. Then you can run the insert folder structure php by browsing to it. This is a great bit of script to start with - thanks a lot. I'll just need to work through it a bit so that it doesn't create duplicates if it's run more than once one the same folder - it basically just needs a trap somewhere in it so that each record is unique.

[Brumer]

Hi,

can anyone do it in reverse?