I have a web-based application written in PHP that stores archive information about stored CDs and DVDs on a MySQL database. Basic information like job name, description, etc is stored. It is also possible to upload a log file (created using a 'dir *.* /s > logfile.log' from the dos prompt) which will then be associated with that particular piece of media. In reality, I don't even store the log files, but I have a PHP script that parses them to find filename, size, etc, then stores them in my MySQL database to speed up the searching process. This enables, for example, the users to search for all media that has file 'fileName1.txt'.
My problem is that I would like to simplify the process of uploading the log file and give the user the option to simply choose the drive letter that their CD/DVD is in and have a script that will create a file listing of that CD and somehow interact with the server to enable me to insert these new files into my MySQL database.
I'm having some serious problems with this (I have no experience with file operations on a local drive) and I'm beginning to wonder if this is even possible, but I think it must be. Any help would be very much appreciated.
Thank you for your time.