Each night I have a series of 6 .php files that I run. These files total well over 1000 lines and do a variety of SQL statements, updating, deleting, adding records to my MYSQL database, as well as looping, if statements...all that crap.
Obviously, I would like to automate this, but the best solution I know of is to make a CRON job that references the .php files. But I don't consider this to be a good solution since I don't want those 6 php files to reside on my webserver all the time. (People might by some weird chance type in the url that executes one of those 6 php files.)
So what is the best way to handle this? Is this what CGI is for? I am open to any solution & am willing to try anything...but I'm looking for the "most professional" solution.
Thanks for your time.