473,383 Members | 1,792 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

Auto Update XML->MySQL by using PHP

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
8 2786
ronverdonk
4,258 Expert 4TB
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
th1982
51
Thanks to yr reply
But can you tell me what the cron job ?
Thanks very much
Feb 26 '08 #3
ronverdonk
4,258 Expert 4TB
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
th1982
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
1,726 Expert 1GB
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
4,258 Expert 4TB
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
6,050 Expert 4TB
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
th1982
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

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

Similar topics

5
by: designsimply | last post by:
I am trying to http post some xml to to a remote server using php. When I try to submit xml using PEAR's HTTP_Client::post() to the remote server, I get back the following "Invalid Document Format"...
1
by: Andy | last post by:
I am having some trouble validating XML using the XmlValidatingReader. I have created some xml and used the visual studio to generate the schema. So I am confident that the xml and schema match. ...
2
by: Si | last post by:
Hi, I have a xml dataset I'd like to order, and save in that order. I've written an xsl to do the transformation, but because the xml file has a xsd namespace, it doesn't work. A cutdown...
4
by: Jim Hammond | last post by:
It would be udeful to be able to get the current on-screen values from a FormView that is databound to an ObjectDataSource by using a callback instead of a postback. For example: public void...
3
by: Goran Djuranovic | last post by:
Hi All, Does anyone know how to retreive deepest XPath value from XML document by using VB.NET? For example, if I had an XML file like this: <Root> <Customer> <Name>MyName</Name> </Customer>...
3
by: Rob | last post by:
I can't find the option to enable auto-using
4
by: whitemoss | last post by:
Hi, I've made some changes to my coding..but unfortunately, there were errors when compiling it..dunno how to solve it..hope anyone can help me...the errors: client.c: In function senddata:...
4
by: geof | last post by:
Hi ! this is my first post where is my error code in line 15 ($sql ) <html> <head><title> update MySQL Data </title></head> <body bgcolor="#FFFFFF"> <?
0
by: vaibhavk | last post by:
Hi, I am trying to transform a XML file into another XML using XSL (XSLT1.0): Original XML: <pfe-traffic-statistics> <pfe-input-packets>5678</pfe-input-packets>...
4
by: saritha2008 | last post by:
Hi, Iam working on converting one of xml file to other form of xml using XSLT. As part of this, I need to count the no. of "component" nodes in the xml file given below. If there is only one...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.