<?php
/**
* MS-Excel stream handler
* Excel export example
* @author Ignatius Teo <
[email protected]>
* @copyright (C)2004 act28.com <http://act28.com>
* @date 21 Oct 2004
*/
include ("../../coneion.php");
require_once "excel.php";
$export_file = "xlsfile://tmp/example.xls";
$fp = fopen($export_file, "wb");
if (!is_resource($fp))
{
die("Cannot open $export_file");
}
$strSQL = "select * from tabla where campo='150'";
$res= mysql_query($strSQL);
while ($resultados= mysql_fetch_array ($res)){
$assoc[] = array("C0mentarios" => $resultados['Comentarios'], "Consecutivo" => $resultados[1], "Precio Unidad" => "$3167","Fecha" => $resultados[3]);
}
fwrite($fp, serialize($assoc));
fclose($fp);
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");
header ("Content-type: application/x-msexcel");
header ("Content-Disposition: attachment; filename=\"" . basename($export_file) . "\"" );
header ("Content-Description: PHP/INTERBASE Generated Data" );
readfile($export_file);
exit;
?>