php 会员积分清零,export_hwchange.php

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

原始数据

按行查看

历史