高手帮忙--打印问题! "一个表"?是表结构、数据、还是一起?你可以参考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 PHP串口密码键盘开发安全 只有PHP最适合做网站吗? php读取大文件的一点疑问 php 能实现 飞信功能吗 关于在linux环境下执行PHP相关命令的问题 删除前弹框确认,怎么实现? 最近状态很糟糕!心情很郁闷! 利用静态变量实现表单连续输出问题 寻深圳PHP+Mysql高级程序员兼职 菜鸟学习PHP,请教留言本 php结合js的问题 求救:用php连接mysql
<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