prepare($sql); $stmt->execute(array($bpid)); if ($row = $stmt->fetchObject()) { $itemname=$row->typename; $itemid=$row->typeid; } else { $itemname="bad item"; $itemid=0; exit; } use EveBlueprint\EveBlueprint; $blueprint= new EveBlueprint($dbh, $itemid); $returnarray=array(); $returnarray['blueprintDetails']=$blueprint->blueprintDetails(); $returnarray['activityMaterials']=$blueprint->activityMaterials(); $xml = new SimpleXMLElement(''); foreach ($returnarray['activityMaterials'] as $activity => $details) { $activityXml=$xml->addChild('activity'); $activityXml->addAttribute('activity', $activity); $materialXml=$activityXml->addChild('materials'); if (isset($_GET['type']) and ($_GET['type']=='attribute')) { $add="addAttribute"; } else { $add="addChild"; } foreach ($details as $material) { $mat=$materialXml->addChild('material'); $mat->$add('name', $material['name']); $mat->$add('typeid', $material['typeid']); $mat->$add('quantity', $material['quantity']); $mat->$add('consume', 1); $mat->$add( 'condensed', $material['name'].";".$material['typeid'].";".$material['quantity'].";1" ); } } print $xml->asXML();