I am new to PHP/MYSQL. I’ve set up a simple content management system which stores a little info about, and URLs to, pdf files in directories. Now I want to do a one-time bulk update where I don’t have to enter the info for each file through the CMS. I would appreciate any help or a recommendation for a good php bulletin board where I can post my question.
Basically, I want to loop through a home directory which has a number of subdirectories, loop through the file names within each subdirectory and load those base file names into an existing database. I think I use the readdr function to get the file names, but I’m not sure about the basic mechanics.
(Then I will parse out the file names into other fields using mysql. The file names include a date, such as 20090515, so I think I can inject that pretty easily into my date field and create the URLs at the same time.)
Again, any help or a referral would be great!