function ExcelOutput($query = "")
{
//connect mysql database
mysql_select_db($this->db_name, $this->db_link);
//get result
$result = mysql_query($query);
$numoffields = mysql_num_fields($result);
// now we could construct Excel output
$fieldstype = array();
for ($i = 0; $i < $numoffields; $i++) {
$fieldstype[] = mysql_field_type($result, $i);
}
// for($i=0;...) END
//create new instance of ExcelGen() class
$excel = new ExcelGen("Sql2Excel");
//initiate a counter for excel "ROW" counter
$rowscounter = 0;
//write fields to excel
for ($i = 0; $i < $numoffields; $i++) {
$fld = mysql_fetch_field($result, $i);
$fldname = $fld->name;
$excel->WriteText($rowscounter, $i, $fldname);
}
// for($i=0;...) END
$rowscounter++;
while ($row = mysql_fetch_array($result)) {
//fetch each Cell($rowscounter,$colscounter) into Excel output stream
for ($colscounter = 0; $colscounter < $numoffields; $colscounter++) {
//identify field type to descide how to write excel cell
if (eregi("(int)", $fieldstype[$colscounter])) {
$excel->WriteNumber($rowscounter, $colscounter, $row[$colscounter]);
} else {
$excel->WriteText($rowscounter, $colscounter, $row[$colscounter]);
}
}
//for($colscounter..) END
$rowscounter++;
}
// while($row=mysql..) END
$excel->SendFile();
return;
}
$excel->WriteText($row, $col, $language[$tab['type']]);
$col++;
}
if ($_SESSION['network']['dlist']['col'][4]) {
$excel->WriteText($row, $col, $tab['host']);
$col++;
}
if ($_SESSION['network']['dlist']['col'][5]) {
$excel->WriteText($row, $col, $tab['port']);
$col++;
}
if ($_SESSION['network']['dlist']['col'][6]) {
$excel->WriteText($row, $col, $tab['username']);
$col++;
}
if ($_SESSION['network']['dlist']['col'][8]) {
$excel->WriteText($row, $col, $tab['db_name']);
$col++;
}
if ($_SESSION['network']['dlist']['col'][12]) {
$excel->WriteText($row, $col, $tab['enctype']);
$col++;
}
if ($_SESSION['network']['dlist']['col'][13]) {
$excel->WriteText($row, $col, $tab['ldap_base']);
$col++;
}
}
//stream Excel for user to download or show on browser
$excel->SendFile();
}
