process into mysql

[desibaba]

How do I process something like this with php and MySQL?

I want to create a download.php file where they can download those files like this: domain.com/download.php?fileid=wordfile.doc

In MYSQL there are three fields.

1) filenumber (Auto increment)
2) fileid (the name after fileid= is this)
3) fileaddress (The actual location of the file)

Only problem is that my files are in sub-folders like

1. /documents/2005/ (632 files: .doc, .ppt, .xml, .zip)
2. /documents/2004/ (1851 files: .doc, .zip, .ppt, .xml)
3. /documents/...... (another 30 folders)/ (more than 10000 files: .exe, .zip, .rar, .doc, .mpg file formats)

And each fileid is unique but it would take me years to process all 10K files one by one. So is there any scripts that someone can help me to write so that I can process all files at the same time with ease of MySQL or php.

[eriksmoen]

create a mysql table like so:

downloads{ id, path, filename, filetype }

in the "path", create the full hard path to the file including the filename (eg /documents/2005/wordfile.doc)
in "filename" just list the name of the file (eg wordfile.doc)
in "filetype" you'd want just the type of file (eg .doc)

now all you need to know is either the id or the filename in order to find out where the file is located... have fun putting that database together... it sound like it will be big 😛

[desibaba]

Is there any wany I can do it in bulk? I really dont want to enter each one at a time.

[eriksmoen]

don't really have a script for this but you can use a foreach statement to loop through each directory

here's the psuedo i'd use:

array = folders to search
(eg $arr = array("/documents/2004","/documents/2005", ...etc... ))

foreach $arr
foreach $file in $arr (ignore ".." and ".")
insert $file_info from $file into database

I don't have time at the moment for creating the actual code, but if there is no response by the time I get some time, I will try to put something together for you if you don't already have something.