高手帮忙--打印问题！

"一个表"?是表结构、数据、还是一起？你可以参考phpMyAdmin

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

有人说可以将数据导入word 或excel中，在利用其打印功能，但怎样实现？？？
<html>
<body>
<?

$valstring=$sele;
if ($valstring =="1")//-------------------------------数量分析表
{
set_time_limit(3600);
// $conn=sql_connect("localhost","root","");
// $select=sql_select_db("aps",$conn1);
$sql="select start_date,finish_qty,lose_qty,rework_qty from a810 order by start_date desc";
$query=sql_query($sql,$link);
$col=sql_num_rows($query);
if ($col>=30) //=============︽计30
{$col=30;}
for($m_i=0;$m_i<$col;$m_i++)
{
    for($m_j=0;$m_j<4;$m_j++)
    {
        $value=sql_result($query,$m_i,$m_j);
    $m_array[$m_i][$m_j]=$value;
    }
} $workbook="c:\myweb\eng1.xls";
$sheet = "Sheet1";
$ex = new COM("Excel.sheet") or Die ("连不上！！！");
$book = $ex->application->Workbooks->Open($workbook) or Die ("打不开！！！");
$sheets = $book->Worksheets($sheet);
$sheets->activate; for($m_i=0;$m_i<$col;$m_i++)
{
    for($m_j=0;$m_j<4;$m_j++)
    {
       $cell=$sheets->Cells($m_i+2,$m_j+1);
$cell->activate;
   $cell->value=$m_array[$m_i][$m_j];
   }
}
$ex->Application->ActiveWorkbook->SaveAs("c:\e1.xls");
$ex->Application->ActiveWorkbook->Close("False");
unset ($ex);
echo("the excelbook in c:\e1.xls");
}
elseif ($valstring=="2")
{
set_time_limit(4000);
//$conn=mysql_connect("localhost","root","");
//$select=mysql_select_db("aps",$conn);
$sql="select end_date,finish_modul,rework_modul,lose_modul,efficiency from a810 order by start_date desc";
$query=sql_query($sql,$link);
$col=sql_num_rows($query); if ($col>=30) //=============︽计30
{$col=30;}
for($m_i=0;$m_i<$col;$m_i++)
{
    for($m_j=0;$m_j<5;$m_j++)
    {
        $value=mysql_result($query,$m_i,$m_j);
    $m_array[$m_i][$m_j]=$value;
    }
}
/*写进excel表格*/
$workbook="c:\myweb\eng2.xls";
$sheet = "Sheet1";
$ex = new COM("Excel.sheet") or Die ("连不上！！！");
$book = $ex->application->Workbooks->Open($workbook) or Die ("打不开！！！");
$sheets = $book->Worksheets($sheet);
$sheets->activate; for($m_i=0;$m_i<$col;$m_i++)
{
    for($m_j=0;$m_j<5;$m_j++)
    {
       $cell=$sheets->Cells($m_i+2,$m_j+1);
   $cell->activate;
   $cell->value=$m_array[$m_i][$m_j];
    }
}
$ex->Application->ActiveWorkbook->SaveAs("c:\e2.xls");
$ex->Application->ActiveWorkbook->Close("False");
unset ($ex);
echo("the excelbook in c:\e2.xls");
}
?>
<table width="75%" border="0">
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td> </td>
  </tr>
  <tr>
    <td> </td>
    <td> </td>
    <td><form name="form1" method="post" action="">
        <div align="right">
          <input type="button" name="Button" value="go back" onClick="location.href='exc1_a810.php?m_program_id=<?php echo $m_program_id;?>'">
        </div>
      </form></td>
  </tr>
</table>
<p> </p>
</body>
</html>
这里是读取一个表的记录到EXCEL