File: C:/xampp/htdocs/PBNCT9/TVI-ok.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Fogra OK Check</title>
<style type="text/css">
<!--
body {
font: 100% Verdana, Arial, Helvetica, sans-serif;
background: #ffffff;
margin: 0; /* 比較好的做法是將 Body 元素的邊界與欄位間隔調整為零，以處理不同的瀏覽器預設值 */
padding: 0;
text-align: center; /* 這樣會讓容器在 IE 5* 瀏覽器內置中對齊。然後，文字會在 #container 選取器中設定為靠左對齊預設值 */
color: #000000;
}
.oneColElsCtr #container {
width: 46em;
background: #FFFFFF;
margin: 0 auto; /* 自動邊界 (搭配寬度) 會讓頁面置中對齊 */
border: 0px solid #000000;
text-align: left; /* 這樣做會覆寫 Body 元素上的 text-align: center。 */
}
.oneColElsCtr #mainContent {
padding: 0 20px; /* 請記住，欄位間隔就是 Div 方塊內部的空間，而邊界就是 Div 方塊外部的空間 */
}
-->
</style></head>
<?php
$fileOK=$_GET["okfile"];
$file=$_POST["file"];
$newfile=$_POST["newfile"];
$jobid=$_POST["jobid"];
$fileOK= substr($file,7,45);
$okPool='../FWOK/'.$jobid.".txt";
echo $okPool."<p>";
if (!copy($file, $newfile)) {
echo "failed to copy $file...\n";
}
else {
copy($file, $okPool);
$filename=$file;
//header("Content-type: application/octet-stream");
header("Content-disposition: attachment;filename=$jobid".".txt");
readfile($filename);
echo "OK sheet 設定完成";
}
$connection = mysql_connect("127.0.0.1", "root", "hpwebadmin") or die ("Unable to connect!");
mysql_query("SET NAMES 'utf8'");
$db = "tvicheck-st";
// select database
mysql_select_db($db) or die ("Unable to select database!");
// generate and execute query
$query = "update ProductionPBN set setOK='1' where filename = '$fileOK'";
echo $query;
//echo $query;
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
mysql_close($connection);
?>
</html>