[RESOLVED] Importing Site Structure into a database

[mrchuckles]

Hi,

I wonder if anyone can help, any help will be appreciated.

I want to reproduce the structure of my site into a database. From a given start directory I then went to import all sub folders and the filenames of the files in them minus the extension into a mysql database.

So if i state the start directory is http://www.mydomain.com/files
which includes the sub folder 'folder one' with the files in that subfolder file1.exe, file2.exe and another sub folder folder two with the files in that subfolder file3.exe, file4.exe

It then adds to a mysql database, the following rows:

file_id - 1
folder - folder one
file - file1

-and-

file_id - 2
folder - folder one
file - file2

-and-

file_id - 3
folder - folder two
file - file3

-and-

file_id - 4
folder - folder two
file - file4

etc..

I'm sure this must be achievable any help most appreciated.

Thanks,

Nick

[nemonoman]

The php manual contains several code snippets that provide for walking through a directory tree structure. See notes to [man]opendir[/man] for example. It should relatively easy to adapt one to address the database input you require

[mrchuckles]

Cheers thats the sort of response I wanted.

I have shall have a fiddle about then let you know if I can sort it out.

Thanks.