By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,614 Members | 1,680 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,614 IT Pros & Developers. It's quick & easy.

Auto Update XML->MySQL by using PHP

P: 51
I want to auto get data from xml file( daily updated) to mysql database every day at 11am and 5pm .Right now I know how to get it but i need to run 1 php file called "importxml.php".I want it automatically 2times per day.
Any solutions for it
Thanks very much
Feb 25 '08 #1
Share this Question
Share on Google+
8 Replies


ronverdonk
Expert 2.5K+
P: 4,258
You'll need a cron job to do that automatically. Ask your provider if you can run such a job or that he can automate/run that for you.

Ronald
Feb 25 '08 #2

P: 51
Thanks to yr reply
But can you tell me what the cron job ?
Thanks very much
Feb 26 '08 #3

ronverdonk
Expert 2.5K+
P: 4,258
Thanks to yr reply. But can you tell me what the cron job ?
Thanks very much
It would be sensible to first get some understanding of the CRON principle. Therefore this link to Wikipedia CRONTAB

There is a Cron Deamon PHP, running crons usually depends on the services of your server provider. You should contact him to inquire about the possibilities for you to run,or have run, a regular Cron job.

Ronald
Feb 26 '08 #4

P: 51
Thanks so much,now i understood
But poor for me , my hosting didnot support cron job.they said dont have this function.
do you have another way to do that
sorry for disturbing you so much
thanks
By the way can you take a look to this site:
http://www.purpleasia.com/clients/VFM_test/index.php
why is it not working in IE but working in firefox?thanks
Feb 27 '08 #5

code green
Expert 100+
P: 1,726
But poor for me , my hosting didnot support cron job.they said dont have this function.
do you have another way to do that
I got around this problem by setting a scheduled task on a Windows machine
to open a browser that ran the URL of the script I wished to run.
I am guessing that a cron can do the same thing.
why is it not working in IE but working in firefox?thanks
It is probably incorrect HTML syntax.
Firefox seems to be stricter about such things
Feb 27 '08 #6

ronverdonk
Expert 2.5K+
P: 4,258
By the way can you take a look to this site:
http://www.purpleasia.com/clients/VFM_test/index.php
why is it not working in IE but working in firefox?thanks
It is probably incorrect HTML syntax.
Firefox seems to be stricter about such things
Funny thing, usually things that work in IE do not work in FF. But here it is the other way around.

I advise you to go to the JavaScript/DHTML forum with your problem. Easier than branching off this thread.

Good luck

Ronald
Feb 27 '08 #7

Markus
Expert 5K+
P: 6,050
Thanks so much,now i understood
By the way can you take a look to this site:
http://www.purpleasia.com/clients/VFM_test/index.php
why is it not working in IE but working in firefox?thanks
Your doctype is incorrect
and when corrected, you have hundreds of validation errors.
validate here
Feb 27 '08 #8

P: 51
I m so happy with all yr helps.
thank you so much. I will try to fix all these problems.
About auto update that I need to run it on server, but our host has no crontab.so i need the script to auto run it.
Thanks
Feb 28 '08 #9

Post your reply

Sign in to post your reply or Sign up for a free account.