StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POZend Framework export Doctrine query results to XML file
text
Body
copied!<p>I have a need to export certain queries to xml files. I have this working in that the file is created and the data are exported, however I'm receiving the following error on screen as the file is being exported and not displayed.</p> <pre><code>This page contains the following errors: error on line 3 at column 1: Extra content at the end of the document </code></pre> <p>I'll admit that I'm new to this as most of you are aware but is there a way I can export and just display a confirmation message to the user that the report has been saved, or am I going about this the wrong way completely?</p> <p>My code is below</p> <p>My controller</p> <pre><code>public function init() { // allow certain reports to be exported to xml // initialize context switch helper $contextSwitch = $this->_helper->getHelper('contextSwitch'); $contextSwitch->addActionContext('newsletterexport', 'xml') ->initContext(); </code></pre> <p>}</p> <pre><code>public function newsletterexportAction() { $q = Doctrine_Query::create() ->select('c.firstname,c.lastname,c.address1,c.address2,c.address3,t.county') ->from('PetManager_Model_Clients c') ->leftJoin('c.PetManager_Model_Counties t') ->where('c.consentToNews=1'); $result = $q->fetchArray(); if (count($result) >= 1) { $this -> view -> records = $result; } } </code></pre> <p>EDIT</p> <p>Ok I tried moving the code from the xml.phtml into my controller as suggested and tried to save the document with save, but now I get the start of the xml document as shown below but no records are saved to the document.</p> <pre><code><?xml version="1.0" encoding="utf-8"?> <petmanager:document xmlns:petmanager="http://petmanager"><petmanager:records/></petmanager:document> </code></pre> <p>My controller code as of this edit</p> <pre><code> public function newsletterexportAction() { $q = Doctrine_Query::create() ->select('c.firstname,c.lastname,c.address1,c.address2,c.address3,t.county') ->from('PetManager_Model_Clients c') ->leftJoin('c.PetManager_Model_Counties t') ->where('c.consentToNews=1'); $result = $q->fetchArray(); if (count($result) >= 1) { //$this -> view -> records = $result; $docpref="newsletterexport"; $docDate=date('y-m-d'); $ext=".xml"; $docname=$docpref.$docDate.$ext; // create XML document $dom = new DOMDocument('1.0', 'utf-8'); // create root element $root = $dom->createElementNS('http://petmanager','petmanager:document'); $dom->appendChild($root); // convert to SimpleXML $xml = simplexml_import_dom($dom); // add resultset elements $records = $xml->addChild('records'); foreach($this->$result as $r){ $record = $records->addChild('record'); $record->addChild('firstName',$this->escape($r['firstName'])); $record->addChild('lastName',$this->escape($r['lastName'])); $record->addChild('address1',$this->escape($r['address1'])); $record->addChild('address2',$this->escape($r['address2'])); $record->addChild('address3',$this->escape($r['address3'])); $record->addChild('county',$this->escape($r['PetManager_Model_Counties']['county'])); }//end of foreach // saave document $xml->saveXML(); $dom->save('D:/reports/exports/'.$docname.''); } </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