I have a question :
I m using window host and i dont have either cronjob function and schedule task (i asked host provider ,they said they donnot have it)
So have any scripts(php,javascript....) to do this work(running a file on server with specific time)?
Thanks so much.
8 1302 TheServant 1,168
Recognized Expert Top Contributor
In a word no. You see, php, javascript, html etc are all only "run" when they are called. So when a user goes there is one of two ways it can be called. The second way is if a server automatically runs it. This is usually done with cronjobs and is really what you need.
May I ask which provider you're with?
What does the file do that you want to run in a cronjob? Maybe there is a way around it?
Thanks TS!!! they are my local provider,i m sure you dont know them.
I want to run a script to import data from xml file to mysql.it will be run everyday at specific time.
are any solutions for it?
Thanks
dlite922 1,584
Recognized Expert Top Contributor
Thanks TS!!! they are my local provider,i m sure you dont know them.
I want to run a script to import data from xml file to mysql.it will be run everyday at specific time.
are any solutions for it?
Thanks
yes there is.
from a computer that has internet access around the time you want to run it, and do a scheduled task/cron job that calls a PHP file that does exactly that.
Good luck.
TheServant 1,168
Recognized Expert Top Contributor
I think that's what we're talking about? But yeah, if your provider doesn't offer it, you will need to schedule it on your own computer and so it has to be on. If it is only once a day, this isn't too big a task. A lot of mine (will) run every 10mins, so it's really impossible for me to use that option.
Actually, I have thought of another way. It's a little fiddley, but it should work. What you is you have a small bit of code at login (or a common page) that checks the time against when the last time your file was run. So you need to have another MySQL table which just stores the last time it was run.
When the user (anyone) goes to your site and logs in, a bit of code will run and check if the current time is over 24 hours from the last run time. If it is, it will execute that file and do what you want. If not, it will continue as normal.
I know it's probably been done before, but I've never heard of it, so for the next 5mins we will pretend that I am a genius ;)
Markus 6,050
Recognized Expert Expert
I think that's what we're talking about? But yeah, if your provider doesn't offer it, you will need to schedule it on your own computer and so it has to be on. If it is only once a day, this isn't too big a task. A lot of mine (will) run every 10mins, so it's really impossible for me to use that option.
Actually, I have thought of another way. It's a little fiddley, but it should work. What you is you have a small bit of code at login (or a common page) that checks the time against when the last time your file was run. So you need to have another MySQL table which just stores the last time it was run.
When the user (anyone) goes to your site and logs in, a bit of code will run and check if the current time is over 24 hours from the last run time. If it is, it will execute that file and do what you want. If not, it will continue as normal.
I know it's probably been done before, but I've never heard of it, so for the next 5mins we will pretend that I am a genius ;)
What if noone visits the page for months?
OR EVEN YEARS?!
I don't believe it's too hard to, on your own pc, use windows schedule task manager.
Regards.
Thanks so much!!!
but when i use schedule task ,i can only see the applications on my computer.How can i set to run a php file on server ?sorry,i m first time using this task .
Thanks
best regards
Hi!
In your schedule you'll need to specify an application or a script that does the task of calling your remote script url.
You could for example call a web browser with the url as argument. A more elegant alternative would be to write a VB script to call the url. An example VB script can be as follows: - 'scriptfile.vbs
-
Call LogEntry()
-
Sub LogEntry()
-
On Error Resume Next
-
Dim objRequest
-
Dim URL
-
Set objRequest = CreateObject("Microsoft.XMLHTTP")
-
URL = "http://YOUR-URL"
-
objRequest.open "POST", URL , false
-
objRequest.Send
-
Set objRequest = Nothing
-
End Sub
Hope this could be of help.
Markus 6,050
Recognized Expert Expert
Thanks so much!!!
but when i use schedule task ,i can only see the applications on my computer.How can i set to run a php file on server ?sorry,i m first time using this task .
Thanks
best regards
Just open your task scheduler, then select your internet browser as the action (giving the url of your script as an extra argument).
Regards.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: sherryonline |
last post by:
i have a page and i need that page to be called every day at 12:00
that page is going to connect to the database fetch some emails and
will start mailing them how i am goning to do this.
|
by: vagrantbrad |
last post by:
I'm using python 2.4 running on Fedora Core 4. I have written a python
program called ipscan.py that checks the external ip address of my
cable internet connection, and on change, will update the...
|
by: the.natalie |
last post by:
Hi.
I am a newbie to mysql, cron, and shell scripting, so please bear with
me. I have a script that is used for updating an image directory based
on contents in a database. The script does the...
|
by: Cameron Simpson |
last post by:
On 17Aug2008 21:25, John Nagle <nagle@animats.comwrote:
Because $HOSTNAME is a bash specific variable, set by bash but NOT
EXPORTED! Like $0 and a bunch of other "private" variables, subprocesses...
|
by: Karthik Gurusamy |
last post by:
Hi,
I'm working on a cron like functionality for my application.
The outer loops runs continuously waking every x seconds (say x=180,
300, ..).
It needs to know what events in cron has expired...
| |
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |