Load dir and file metadata in mySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bethafin2000
Forum Newbie
Posts: 1
Joined: Mon Feb 02, 2009 9:36 pm

Load dir and file metadata in mySQL

Post 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
Post Reply