File Directory --- Into Array --- Into Mysql Database Table??

Hello all...

What I'm trying to do may or may not be relatively simple. I have a
directory of text files online that I'd like to be able to search
using php/mysql.

The directory structure is like so...

music/eric_clapton/this_songs_name.txt

Now Ideally what I'd like to do... is parse the path/file info into an
array, like below:

Dir | Sub Dir | File Name | Type | FullPath
-------------------------------------------------------------
music | Eric Clapton | This Songs Name | .txt | FileUrl


I'll need to replace the underscores/spaces in the path for the sub
dir and file name fields (for result display purposes), and ucwords?
to make each word in these fields begin with an uppercase letter...

Is there any way of going about this that would make it easier to
import the results into a mysql table?

I hope this makes sense.

Thanks in advance...

Don Bedford.