Insert record into MYSQL by using script

[Anon]

Hi there,

I don't know if it's possible, here is what I want to do:

I want to grab a file from the local file (/home/user/johndoe/file_name) system and insert the file name(s) into mysql all through scripting only. The script will be run at a certain time by using cron. I need to know how to interact with mysql without human intervention. (PHP was complied as a module, not cgi).

The whole process should be automatic. Does anyone know how to do this in bash or PHP? I don't know anything about perl but quite comfortable with PHP and bash.

Any advice is appreciated.

[Anon]

I think I find a solution from here http://www.phpbuilder.com/columns/darrell20000319.php3?page=1

Thank you all.