Link to home
Create AccountLog in
Avatar of Lightwalker
Lightwalker

asked on

Creating CRON Job that needs to use PHP and HTML and even Javascipt

Dear Experts,

I want to use the cron functionality to run a tasks every hour, but from reading a few articles here I understand that cron can not execute HTML as it is not like viewing the page in a web browser. Because one of my scripts is updating multiple mysql rows, I need to use html and a submit button which can not be excecuted by CRON. I have looked at this article about using CGI bin to store the scripts that I can use CRON to execute the script in the CGI bin. Here is the link

Any help with this I would be very grateful. I need to include a submit button in the script file that will submit automatically when the page loads. Now I can achieve this with javascript but I do not think this will work as Javascript is not a server side language. ( can CGI execute javascript) or is there a way to have the html or php automatically submit the form once the page has loaded.

Again any suggestion that could help would be really helpful as I have almost no knowledge of CGI bin's capabilities or how to submit a form automatically once the page loads without using javascript.

many thanks as always for your help
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

You don't need HTML.  PHP can probably do all of it.  If you can read the information, the script can update your MySQL without a form on a page.
You can also work client side and use cron to start a client request with the wget program (usually available on linux distributions), simulating what you would do by hand with the browser, the only difficulty here is to reconstruct the exact query string that is passed to the server, especially if you use a POST method, you may find this information by looking at the webserver log, or reconstruct by looking at the HTML form. The command to be launched by cron would look more or less like this:

wget "http://myserver.com/myscript.php" --post-data="key1=data1&key2=data2"

wget allows also to pass authentication information or cookies, with some additional effort.
Avatar of adeelshahid
adeelshahid

try using wget inside your cron job,

and in the php script use a iframe to call the file where you want the html, php to execute.
ASKER CERTIFIED SOLUTION
Avatar of palanee83
palanee83
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account