Problem trying to import data into the database from a XML source

[chr0nik]

Hi,

I have a problem trying to import data from an XML source, I have parsed the xml into a php and when I try to import it into the db, it gives me a "XML parsing error - Invalid document structure. Line NUmber: 3 Column Number 1".

What I'm trying to do is to import the subscribers list onto the db from CampaignMonitor and then send it back to the webservice if it has been uploaded.

The php code I'm trying to use is the following:

<?php

$api = 'Subscribers.GetUnsubscribed?ListID="changedit"&Date=2008-02-18';

////////////////////////////////////////////////////////////////////////////////////////////

$apiKey = "Changed it";

$doc = new DOMDocument();

$xml = file_get_contents("http://api.createsend.com/api/api.asmx/$api&ApiKey=$apiKey");

$doc->loadXML($xml);

//echo ''.

$doc->saveXML() . ''; $xpath = new DOMXPath( $doc );

$emails = $xpath->query('*/*'); ?>

<?php foreach($emails as $email) ?>

<?php echo $email->nodeName . ': ' . $email->nodeValue ?>

<?php endforeach ?>

Can anyone help me please? I'm pretty newbie when it comes to programming.

Thank you

Edited February 22, 2009 by Guest