You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.
Course Of The Month
10 days, 6 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Creating CRON Job that needs to use PHP and HTML and even Javascipt
Posted on 2011-03-05
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4 Comments
Active today
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&ke
wget allows also to pass authentication information or cookies, with some additional effort.
wget "http://myserver.com/myscript.php" --post-data="key1=data1&ke
wget allows also to pass authentication information or cookies, with some additional effort.
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.
and in the php script use a iframe to call the file where you want the html, php to execute.
As far as i know, you can not execute the JS from server side using CRON.
If you want to submit the form using POST / GET method using PHP, You can do it uing CURL library. You can do this with few lines for code.
#Example for HTTP GET
http://www.php.net/manual/en/function.curl-exec.php
#Example for HTTP POST (Collect all the form variable and construct an associative array)
http://davidwalsh.name/execute-http-post-php-curl
Note; Before you use this library, make sure CURL is enabled on your web server. You can check this with the help of phpinfo() function.
If you want to submit the form using POST / GET method using PHP, You can do it uing CURL library. You can do this with few lines for code.
#Example for HTTP GET
http://www.php.net/manual/en/function.curl-exec.php
#Example for HTTP POST (Collect all the form variable and construct an associative array)
http://davidwalsh.name/execute-http-post-php-curl
Note; Before you use this library, make sure CURL is enabled on your web server. You can check this with the help of phpinfo() function.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Build an array called $myWeek which will hold the array elements Today, Yesterday and then builds up the rest of the week by the name of the day going back 1 week.
(CODE)
(CODE)
Then you just need to pass your date to the function.
If i…
The Windows functions GetTickCount and timeGetTime retrieve the number of milliseconds since the system was started. However, the value is stored in a DWORD, which means that it wraps around to zero every 49.7 days. This article shows how to solve t…
Learn the basics of lists in Python.
Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing.
Set up your basic HTML file. Open your form tag and set the method and action attributes.:
(CODE)
Set up your first few inputs one for the name and …
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 6 hours left to enroll
628 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.