Get XML data from 1 Server to another server

[thipse_rahul]

Hi to all

Please Help me to make script

I have 1 3rd party site that provide us to xml data that data I want to get that data in Mysql through php script.

3rd Party having htaccess with username and password.

then please suggest me How it can be possible.

Thanks

From
R@hul Thipse

[Hypnos]

Requesting the url like http://username:password@www.google.com/index.xml might work. If not, use CURL or a shell script with WGET.

Once you have the data in a string, just start exploding it. XML should be pretty easy to convert to a two dimensional PHP array (then to a SQL insert command), or just directly convert it to a SQL insert command.