File: C:/xampp/htdocs/Fogra112T51S/TVI-parsingCTOKXT.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 TVI 997R 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>
<body class="oneColElsCtr">
<?php
//rename("/upload/881.csv", "target.csv");
echo $rtarget."<p>";
$fileT = $rtarget;
$newfileT = 'target.csv';
if (!isset($OK))
{
?>
<table cellspacing="5" cellpadding="5">
<form action="<?php echo $PHP_SELF; ?>" method="POST">
<tr>
<td valign="top"><b><font size="-1">印件編號: </font></b></td>
<td><input size="30" maxlength="35" type="text" name="jobid" <SCRIPT LANGUAGE="JavaScript">
document.all.jobid.focus(); </SCRIPT></td>
<td><input size="30" maxlength="35" type="hidden" name="file" value="<?php echo $fileT;?>"> </td>
<td><input size="30" maxlength="35" type="hidden" name="newfile" value="<?php echo $newfileT;?>"> </td>
</tr>
<tr>
<td colspan=2> <input type="Submit" name="OK" value="送出"></td>
</tr>
</form>
</table>
<?php
}
else
{
$fileOK= substr($file,7,45);
$okPool='C:/xampp/htdocs/FWOK/'.$jobid.".csv";
echo $okPool."<p>";
if (!copy($file, $newfile)) {
echo "failed to copy $file...\n";
}
else {
copy($file, $okPool);
echo "OK sheet 設定完成";
}
$connection = mysql_connect("127.0.0.1", "root", "fredsql") 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 fogra123 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>