I want to write a php or shell script(better to run it through command line), so that I can index all files and put the info(info only, not the real file) in mysql db.
1. your script should let me define where is the starting point e.g. /home/user/docs/files
2. your script will index all files staring from the starting point (including all files under sub folders or symbolic links)
3. put the info into mysql e.g. file location:/home/user/docs/files/disk1/[login to view URL] your script should put /files/disk1/[login to view URL] into mysql.
I already have a php function class for the tree portion, which can be adapted for your purpose. I can make it run from shell as requested, as a php app.
Do you already have a mysql database created to insert the data into?