Page 1 of 1

Load dir and file metadata in mySQL

Posted: Mon Feb 02, 2009 9:49 pm
by bethafin2000
Hello,
I have a number of PDF files stored in multiple directories and subdirectories. The whole structure has no rhyme or reason.

I want to be able to take each directory path and filename and store it in a mySQL database so they can be "pointing" to the actual PDF files (via a web-accessible interface written in PHP).

Preferably I would like to be able to parse the components of the file path but this is not necessary.

I know I can traverse all the files, create an ASCII delimited file and then load that up to mySQL but is there a PHP library that could help me do this without having to write the parsing code etc?

Thank you for any help,
Ethan