fishbones/core/DB.php
/**
	 * execute a sql and return an string with xml data
	 *
	 * @param	string $sql	sql query
	 *
	 * @return	DOMDocument	XML structured:
	 *					<data>
	 *					    <line>
	 *					        <value1>abc</value1>
	 *					        <value2>def</value2>
	 *					    </line>
	 *						...
	 *					    ...
	 *					</data>
	 * 				"data" (the root node)) and "line" nodes always use these names.
	 *				one "line" node is added for each returned row.
	 *				the value1, value2 are the cellnames as returned by the SQL query.
	 * 				boolean false on error
	 *				on query error, return a DOMDocument with fishbones standard
	 *				XML error document (data node, with one error node, containing the text description of the error).
	 *
	 */
execute a sql and return an string with xml data

@param       string $sql     sql query

@return      DOMDocument     XML structured:


abc
def


"data" (the root node)) and "line" nodes always use these names.
one "line" node is added for each returned row.
the value1, value2 are the cellnames as returned by the SQL query.
boolean false on error
on query error, return a DOMDocument with fishbones standard
XML error document (data node, with one error node, containing the text description of the error).
execute a sql and return an string with xml data @param string $sql sql query @return DOMDocument XML structured : abc def " data " ( the root node )) and " line " nodes always use these names . one " line " node is added for each returned row . the value1 value2 are the cellnames as returned by the SQL query . boolean false on error on query error return a DOMDocument with fishbones standard XML error document ( data node with one error node containing the text description of the error ) .
public function queryAsXmlDom( $sql ) {
		$result = $arrayResul = $this->queryAsArray( $sql );
		if ( is_array( $result) ) {	
			$xml = $this->arrayResultAsXml( $arrayResul );			
		} else {
			$xml = $this->makeErrorXml( $this->error );
		}
		return $xml;
	}
public function queryAsXmlDom ( $ sql ) { $ result = $ arrayResul = $ this -> queryAsArray ( $ sql ) ; if ( is_array ( $ result ) ) { $ xml = $ this -> arrayResultAsXml ( $ arrayResul ) ; } else { $ xml = $ this -> makeErrorXml ( $ this -> error ) ; } return $ xml ; }
execute a sql and return an string with xml data
execute a sql and return an string with xml data
//$xml = $this->arrayResultAsXml( Array() );	