public function getXMLFromResult(ResultInterface $query, array $params = []): string
	{
		// Set our default values
		foreach (['root' => 'root', 'element' => 'element', 'newline' => "\n", 'tab' => "\t"] as $key => $val)
		{
			if (! isset($params[$key]))
			{
				$params[$key] = $val;
			}
		}

		// Create variables for convenience
		extract($params);

		// Load the xml helper
		helper('xml');
		// Generate the result
		$xml = '<' . $root . '>' . $newline;
		while ($row = $query->getUnbufferedRow())
		{
			$xml .= $tab . '<' . $element . '>' . $newline;
			foreach ($row as $key => $val)
			{
				$val = (!empty($val)) ? xml_convert($val) : '';
				$xml .= $tab . $tab . '<' . $key . '>' . $val . '</' . $key . '>' . $newline;
			}
			$xml .= $tab . '</' . $element . '>' . $newline;
		}

		return $xml . '</' . $root . '>' . $newline;
	}
public function getXMLFromResult(ResultInterface $query, array $params = []): string
	{
		// Set our default values
		foreach (['root' => 'root', 'element' => 'element', 'newline' => "\n", 'tab' => "\t"] as $key => $val)
		{
			if (! isset($params[$key]))
			{
				$params[$key] = $val;
			}
		}

		// Create variables for convenience
		extract($params);

		// Load the xml helper
		helper('xml');
		// Generate the result
		$xml = '<' . $root . '>' . $newline;
		while ($row = $query->getUnbufferedRow())
		{
			$xml .= $tab . '<' . $element . '>' . $newline;
			foreach ($row as $key => $val)
			{
				$val = (!empty($val)) ? xml_convert($val) : '';
				$xml .= $tab . $tab . '<' . $key . '>' . $val . '</' . $key . '>' . $newline;
			}
			$xml .= $tab . '</' . $element . '>' . $newline;
		}

		return $xml . '</' . $root . '>' . $newline;
	}
public function getXMLFromResult ( ResultInterface $ query , array $ params = [ ] ) : string { // Set our default values foreach ( [ 'root' => 'root' , 'element' => 'element' , 'newline' => "\n" , 'tab' => "\t" ] as $ key => $ val ) { if ( ! isset ( $ params [ $ key ] ) ) { $ params [ $ key ] = $ val ; } } // Create variables for convenience extract ( $ params ) ; // Load the xml helper helper ( 'xml' ) ; // Generate the result $ xml = '<' . $ root . '>' . $ newline ; while ( $ row = $ query -> getUnbufferedRow ( ) ) { $ xml .= $ tab . '<' . $ element . '>' . $ newline ; foreach ( $ row as $ key => $ val ) { $ val = ( ! empty ( $ val ) ) ? xml_convert ( $ val ) : '' ; $ xml .= $ tab . $ tab . '<' . $ key . '>' . $ val . '</' . $ key . '>' . $ newline ; } $ xml .= $ tab . '</' . $ element . '>' . $ newline ; } return $ xml . '</' . $ root . '>' . $ newline ; }
Generate XML data from a query result object

@param ResultInterface $query  Query result object
@param array           $params Any preferences

@return string
Generate XML data from a query result object