Need help PHP - XML

[hansverst]

Hello,
I hope some one can help me with this.
I need to output xml data from a remote server into a pulldown menu.

This is what i already done.

<?

$url = "https://secure.virtuelekassa.nl/api/xml/ideal.asp";

$page = "/ideal.asp";



$request_xml = "<?xml version=\"1.0\" ?>\n";

$request_xml .= "<request>\n";

$request_xml .= "<test>true</test>\n";

$request_xml .= "<type>banklist</type>\n";

$request_xml .= "</request>\n";



$post_string = $request_xml;



$header = "POST ".$url." HTTP/1.0 \r\n";

$header .= "MIME-Version: 1.0 \r\n";

$header .= "Content-type: application/PTI26 \r\n";

$header .= "Content-length: ".strlen($post_string)." \r\n";

$header .= "Content-transfer-encoding: text \r\n";

$header .= "Request-number: 1 \r\n";

$header .= "Document-type: Request \r\n";

$header .= "Interface-Version: Test 1.4 \r\n";

$header .= "Connection: close \r\n\r\n";

$header .= $post_string;



$ch = curl_init();

curl_setopt($ch, CURLOPT_URL, $url);

curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

curl_setopt($ch, CURLOPT_TIMEOUT, 4);

curl_setopt($ch, CURLOPT_CUSTOMREQUEST, $header);

curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);


$data = curl_exec($ch);

if (curl_errno($ch)) {

print curl_error($ch);

} else {

// just for testing
print ("$data");


curl_close($ch);

}

?>

When i run the file i get this.

<?xml version="1.0" encoding="UTF-8"?>
<response>
<type>banklist</type>
<bank>
<bankid>0031</bankid>
<bankname>ABN Amro</bankname>
</bank>
<bank>
<bankid>0081</bankid>
<bankname>Fortis</bankname>
</bank>
<bank>
<bankid>0721</bankid>
<bankname>Postbank</bankname>
</bank>
<bank>
<bankid>0021</bankid>
<bankname>Rabobank</bankname>
</bank>
<bank>
<bankid>0751</bankid>
<bankname>SNS Bank</bankname>
</bank>
</response>


This works fine, but how can i put this $data into a pulldown menu.?
Please if you can help me with a working sample you make me real happy.
Thank you

Hans

[pedalpete]

Hey Hank,

I do something very similar with an xml file and php.

I use preg_match_all and preg_match loops.

Not sure if you are making the xml locally or if it comes from the remote server,
to get the xml, i use this, but the content is already in xml on the remote server
I use this to get my xml page

// Get the xml page
$url = "address where xml is located";
$data = implode("", file($url));
 

but once you have the xml in a variable (as above) you can use the below
I think you would want something like this

 
 
echo "<select name=\"banks\">";
// Get each bank
 preg_match_all ("/<bank>([^`]*?)<\/bank>/", $data, $matches);
 
// then go through each to get the bank details from the xml
 
foreach ($matches[0] as $match) {
 
// get bankid
preg_match ("/<bankid>([^`]*?)<\/bankid>/", $match, $temp);
    $bankid = $temp['1'];
 
// get bankname
preg_match ("/<bankname>([^`]*?)<\/bankname>/", $match, $temp);
    $bankname = $temp['1'];
 
    echo "<option value=\"$bankid\">$bankname</option";
}
 

[hansverst]

Thank you for repllying,
this is what i was looking for, it works great!
The xml file is recived from a remote server.
Gr. Hans