SQL XML: Generate XML documents from MySQL query results

This class can be used to generate XML documents from MySQL query results.

The class executes a given MySQL query. It may restrict the range of extracted rows to a given page on which a configurable limit number of rows is returned.

The generated XML documents are defined by row and column tags that contain the values of each query result row and column.

The XML documents also include tags that export the total number of rows, number of results per page, total number of pages and the current page number.

The class uses the PHP DOM XML to generate the XML documents.