[Resolved] Retrieve variables from a remote location

[datona]

I am attempting to retrieve some exchange rates from WorldPay.com.
The URL looks like (ssl):
https://select.worldpay.com/wcc/info?op=rates&instId=12345&infoPW=mypass

This will return a text file as shown below:

#Exchange rates for installation 12345
#Mon Aug 16 18:04:09 GMT+00:00 2004
USD_EUR=0.8464257299615312
rateDateString=2004-08-16
USD_USD=1.0
allRatesCurrent=true
rateDateMillis=1092614400000
USD_CAD=1.3709886615622777

What I need to do is be able to parse this information out so that I can write it to a MySQL database like this:

Could anyone provide me with any guidance on how to accomplish this.
Thanks in avdance for any help given!

[devinemke]

how bout something like this:

$string = '#Exchange rates for installation 52328
#Mon Aug 16 18:04:09 GMT+00:00 2004
USD_EUR=0.8464257299615312
rateDateString=2004-08-16
USD_USD=1.0
allRatesCurrent=true
rateDateMillis=1092614400000
USD_CAD=1.3709886615622777';

$array = explode("\n", $string);
foreach ($array as $value)
{
	if ($value{0} != '#')
	{
		$explode = explode('=', trim($value));
		$sql_array[] = $explode[0] . " = '" . $explode[1] . "'";
	}
}

$sql = 'INSERT INTO table SET ' . implode(', ', $sql_array);
echo $sql;

[datona]

Thank you VERY much for that part of code.
What I really needed was how to GET that string in the first place.
When I go to the URL in a browser, it outputs that data on the screen but as a text file (no html tags)
I have tried fsockopen but as I am at a loss on how to actually do this, that is why I have turned to the briliant minds of this forum!

Thanks

[Drakla]

If your php install allows it you can just use

$data = file_get_contents($url);

to grab the page

[datona]

Thanks ALLOT your guys.
Between the two of you, I now have a working function!!!