include 'inc/conn.php';
$p_new_lines = array("\r\n", "\n", "\r","\r\n", "
","
","","","
","
");
$p_change_line_in_excel_cell = '
';
header ("Content-type:application/vnd.ms-excel");
header ("Content-Disposition:filename=HW_Change_Table.xls");
echo "
echo "
HW变更记录表";echo "
";echo "
编号";echo "
主板名称";echo "
主板版号";echo "
变更原因";echo "
变更位置";echo "
变更日期";echo "
管控人员";echo "
增加时间";echo "
更新时间";echo "
备注说明";echo "
";$db = new mysql();
$sql = "select * from hw_change ORDER BY add_date DESC";
$db->query($sql);
$num = $db->db_num_rows();
if ($num == 0)
echo "No data was found!";
for($i=0; $i
$row = $db->fetch_assoc();
$j=$i+1;
echo "
$j".htmlspecialchars_decode($row['MB_NAME'])."
".htmlspecialchars_decode($row['MB_VER'])."
".str_replace($p_new_lines, $p_change_line_in_excel_cell, htmlspecialchars_decode($row['MB_REASON']))."
".str_replace($p_new_lines, $p_change_line_in_excel_cell, htmlspecialchars_decode($row['MB_LOCATION']))."
".substr(htmlspecialchars_decode($row['MB_CHANGEDATE']),0,10)."
".htmlspecialchars_decode($row['OWNER'])."
".substr(htmlspecialchars_decode($row['add_date']),0,10)."
".substr(htmlspecialchars_decode($row['up_date']),0,10)."
".str_replace($p_new_lines, $p_change_line_in_excel_cell, htmlspecialchars_decode($row['REMARK']))."
";}
echo "
";$db->close();
?>
一键复制
编辑
Web IDE
原始数据
按行查看
历史