PHP DOM XML - creating multiple namespace attributes?

Question

I am working on some PHP to create XML from a database using the DOM extension.

Basically, I need to create NameSpace and add 3 attributes to it:

<NameSpaceName xmlns="uri:xxx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="uri:xxx"> 

The full code I wrote is below:

 include_once("includes/connect.php"); $sql = ("SELECT * FROM tableName"); $query = mysql_query($sql) or die("Error: " . mysql_error()); // create a new XML document $doc = new DomDocument('1.0', 'UTF-8'); // create root node $root = $doc->createElementNS('uri:xxx', 'PayerRecords'); $root = $doc->appendChild($root); $root->setAttributeNS('http://www.w3.org/2000/xmlns/' ,'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance'); $root->setAttributeNS('http://www.w3.org/2000/xmlns/' ,'xsi:schemaLocation', 'uri:xxx'); // process one row at a time while($row = mysql_fetch_assoc($query)) { // add node for each row $occ = $doc->createElement('Content'); $occ = $root->appendChild($occ); // add a child node for each field foreach ($row as $fieldname => $fieldvalue) { $child = $doc->createElement($fieldname); $child = $occ->appendChild($child); $value = $doc->createTextNode($fieldvalue); $value = $child->appendChild($value); } // foreach } // while // get completed xml document $xml_string = $doc->saveXML(); echo $xml_string; 

But when I do the above, I get this error:

Fatal error: exception for exception 'DOMException' with message 'Namespace Error in xml.php: 21 Stack trace: # 0 xml.php (21): DOMElement-> setAttributeNS (' http: //www.w3.o ... ',' xsi: schemaLocat ... ',' uri: xxx ... ') # 1 {main} throw in xml.php on line 21

Line 21 is the second line of setAttributeNS.

Can anyone see where I'm wrong?

Answer 1

schemaLocation is not declared in the namespace http://www.w3.org/2000/xmlns/ , but in http://www.w3.org/2001/XMLSchema-instance

 <?php // create a new XML document $doc = new DomDocument('1.0', 'UTF-8'); // create root node $root = $doc->createElementNS('http://xxx', 'PayerRecords'); $root = $doc->appendChild($root); $root->setAttributeNS('http://www.w3.org/2000/xmlns/' ,'xmlns:xsi', 'http://www.w3.org/2001/XMLSchema-instance'); $root->setAttributeNS('http://www.w3.org/2001/XMLSchema-instance', 'schemaLocation', 'http://xxx'); echo $doc->savexml(); 

prints

 <?xml version="1.0" encoding="UTF-8"?> <PayerRecords xmlns="http://xxx" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xxx"/> 

Answer 2

I did not quite understand this for the first time, so I am posting my answer in more detail. Maybe someone will find this helpful.

 // create DOM document $xml = new DomDocument('1.0', 'UTF-8'); // create root element $el = $xml->createElementNS('http://namespaceA/url/here/', 'rootelement'); // to be able to add new namespaces we must first add namespace 'xsi' // third parameter is important (use your main namespace with .xsd) $root->setAttributeNS( 'http://www.w3.org/2001/XMLSchema-instance', 'xsi:schemaLocation', 'http://namespaceA/url/here/ http://namespaceA/xsdfile/here.xsd'); // add new namespace $el->setAttributeNS( 'http://www.w3.org/2000/xmlns/', 'xmlns:namespaceB', 'http://namespaceB/url/here/'); // add root element to DOM $xml->appendChild($el); 

This post archive message was very useful: http://www.mail-archive.com/[e-mail]/msg135362.html .

Answer 3

replace line 21 with

 $root->setAttributeNS( 'http://www.w3.org/2001/XMLSchema-instance', 'xsi:schemaLocation', 'http://xxx http://xxx/xxx.xsd' ); 

xsi:schemaLocation not defined in http://www.w3.org/2000/xmlns/ or your namespace, but in xsi . therefore you should use the (full) xsi namespace uri as the first parameter.

and: you do not need to call setAttributeNS() twice: one line above generates the xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" attributes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" and xsi:schemaLocation="http://xxx http://xxx/xxx.xsd" .