Pasted

// *Note Download SimpleExcel : http://faisalman.github.com/simple-excel-php/
// *twitter.com/quocvuongdn
 
use SimpleExcel\SimpleExcel;
 
require '../lib/SimpleExcel/SimpleExcel.php';
 
public function exportToXml($results,$fileName){ //$result is ResultSet from query DB, $fileName is name of xml file.
        //Export to xml, can see it on excel office.
        $rowHead = array();
        foreach ($results[0] as $key => $value) {
            array_push($rowHead, $key);
        }
 
        $rowData = array();
        array_push($rowData, $rowHead); //Put column name to [0] position array.
 
        foreach ($results as $key => $value) {
            array_push($rowData, $value); //Put data to array.
        }
 
        $this->excel->writer->setData($rowData); //Set array to data of xml file.
        $this->excel->writer->saveFile($fileName); //Set name file.
    }