setRecordset($Recordset1);
$xmlExportObj->addColumn("id", "id");
$xmlExportObj->addColumn("name", "name");
$xmlExportObj->addColumn("type", "type");
$xmlExportObj->addColumn("subtype", "subtype");
$xmlExportObj->addColumn("img_url", "img");
$xmlExportObj->addColumn("description_small", "description_small");
$xmlExportObj->addColumn("description_detail1", "description_detail1");
$xmlExportObj->addColumn("description_detail2", "description_detail2");
$xmlExportObj->addColumn("price", "price");
$xmlExportObj->addColumn("promo", "promo");
$xmlExportObj->addColumn("order", "order");
$xmlExportObj->setMaxRecords("ALL");
$xmlExportObj->setDBEncoding("UTF-8");
$xmlExportObj->setXMLEncoding("UTF-8");
$xmlExportObj->setXMLFormat("NODES");
$xmlExportObj->Execute();
// End XMLExport Recordset1
?>
Untitled Document
XMLExport.php
XMLExport Error.
File not found: %s. Please upload the includes/ folder to the testing server.';
$KT_XMLExport_uploadFileList = array('XMLExport.class.php');
for ($KT_XMLExport_i=0;$KT_XMLExport_i
XMLExport.class.php
maxRecords = 'ALL';
$this->xmlFormat = 'NODES';
$this->columns = array();
$this->rootNodeName = 'export';
$this->rowNodeName = 'row';
}
/**
* This is the setter for the recordset member variable.
*
* @param recordset The recordset from where to retrieve the data for the export.
*/
function setRecordset(&$recordset) {
$this->recordset = $recordset;
}
/**
* This is the setter for the maxRecords member variable specifying how may records should be exported.
*
* @param maxRecords The string 'ALL' or the number of records.
*/
function setMaxRecords($maxRecords) {
$this->maxRecords = trim($maxRecords);
}
/**
* This is the setter for the dbEncoding member variable.
*
* @param dbEncoding The encoding in which the data is stored in the database.
*/
function setDBEncoding($dbEncoding) {
$this->dbEncoding = trim($dbEncoding);
}
/**
* This is the setter for the xmlEncoding member variable.
*
* @param xmlEncoding The encoding that will be set for the XML.
*/
function setXMLEncoding($xmlEncoding) {
$this->xmlEncoding = trim($xmlEncoding);
}
/**
* This is the setter for the xmlFormat member variable.
*
* @param xmlFormat The format in which the XML file should export the data: "NODES" or "ATTRIBUTES".
*/
function setXMLFormat($xmlFormat) {
$this->xmlFormat = strtoupper(trim($xmlFormat));
if ($this->xmlFormat != 'ATTRIBUTES') {
$this->xmlFormat == 'NODES';
}
}
/**
* This is the setter for the rootNodeName member variable.
*
* @param rootNodeName The name of the root element in the resulting XML.
*/
function setRootNode($rootNodeName) {
$this->rootNodeName = trim($rootNodeName);
}
/**
* This is the setter for the rowNodeName member variable.
*
* @param rowNodeName The name of the row element in the resulting XML.
*/
function setRowNode($rowNodeName) {
$this->rowNodeName = trim($rowNodeName);
}
/**
* This method adds a column to the member variable columns which holds the columns that the XML file will have.
*
* @param column The name of the column as it appears in the recordset.
* @param label The label that will be used in the exported XML file to identify this field.
*/
function addColumn($column, $label = '') {
$this->columns[trim($column)] = array('label' => trim($label));
}
/**
* This method is the one that generates and exports the XML file.
*/
function Execute() {
if ( !isset($this->recordset) || !is_resource($this->recordset) ) {
die('XMLExport Error.
Passed argument is not a valid recordset.');
return;
}
if (count($this->columns) < 1) {
die('XMLExport Error.
No columns defined!');
return;
}
$document = '';
$document .= '<'.'?xml version="1.0" encoding="' . $this->xmlEncoding . '"?'.'>';
$document .= "\r\n";
$document .= '<' . $this->rootNodeName . '>';
$document .= "\r\n";
$numRow = 1;
if(mysql_num_rows($this->recordset) > 0) {
mysql_data_seek($this->recordset, 0);
}
while($row_recordset = mysql_fetch_assoc($this->recordset)) {
if ($this->maxRecords != 'ALL' && $this->maxRecords < $numRow) {
break;
}
$row = "\t";
$row .= '<' . $this->rowNodeName;
if ($this->xmlFormat != 'ATTRIBUTES') {
$row .= '>' . "\r\n";
}
foreach ($this->columns as $column => $details) {
$colName = $column;
if ($details['label'] != '') {
$colName = $details['label'];
}
$value = $row_recordset[$column];
if ($this->xmlEncoding != $this->dbEncoding) {
if (!function_exists('mb_convert_encoding')) {
die('XMLExport Error.
Could not perform characters conversion. Function mb_convert_encoding is not available! Please enable the mbstring extension!');
}
$value = mb_convert_encoding($value, $this->xmlEncoding, $this->dbEncoding);
}
$value = str_replace(array('&', '>', '<', '"'), array('&', '>', '<', '"'), $value);
if ($this->xmlFormat == 'ATTRIBUTES') {
$row .= ' ' . $colName . '="';
$row .= $value;
$row .= '"';
} else {
$row .= "\t\t";
$row .= '<' . $colName . '>';
$row .= $value;
$row .= '';
$row .= "\r\n";
}
}
if ($this->xmlFormat == 'ATTRIBUTES') {
$row .= ' />';
} else {
$row .= "\t" . 'rowNodeName . '>';
}
$document .= $row;
$document .= "\r\n";
$numRow++;
}
$document .= 'rootNodeName . '>';
$size = strlen($document);
$this->sendHeaders($size);
echo $document;
exit;
}
/**
* This method is used to send the appropriate headers.
*
* @param size The size of the XML being exported.
*/
function sendHeaders($size) {
if (headers_sent()) {
die('XMLExport Error.
Headers already sent! The XML cannot be exported');
}
header('Content-type: text/xml; charset=' . $this->xmlEncoding);
header('Pragma: public');
header('Cache-control: private');
header('Expires: -1');
header('Content-Length: ' . $size);
}
}
?>