StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP building XML files using DOMDocument in batches
text
Body
copied!<p>I have a problem when looping through data and creating XML files using DOMDocument. It all worked fine until I decided to run this script in batches. Now I have multiple <code>'<?xml version="1.0"?>'</code> starting tags in my XML files, looks like one for each batch. There are also more products nodes being generated than there are products. Can anyone help.</p> <pre><code>//get products $productsObj = new Products($db,$shopKeeperID); //find out how many products $countProds = $productsObj->countProducts(); $productBatchLimit = 3; //keep low for testing //create new file $file = 'products/'. $products . '.xml'; $fh = fopen($file, 'a'); //create XML document object model (DOM) $doc = new DOMDocument(); $doc->formatOutput = true; $counter = 1; $r = $doc->createElement( "products" ); $doc->appendChild( $r ); for ($i = 0; $i < $countProds; $i += $productBatchLimit) { $limit = $productBatchLimit*$counter; $products = $productsObj->getShopKeeperProducts($i, $limit); $prod = ''; //loop through each product to create well formed XML foreach( $products as $product ){ $prod = $doc->createElement( "offer" ); $offerID = $doc->createElement( "offerID" ); $offerID->appendChild($doc->createTextNode( $product['prod_id'] )); $prod->appendChild( $offerID ); $productName = $doc->createElement( "name" ); $productName->appendChild($doc->createTextNode( $product['productName'] )); $prod->appendChild( $productName ); $r->appendChild( $prod ); $strxml = $doc->saveXML(); } fwrite($fh, $strxml); $counter++; } fclose($fh); </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload