<?php
session_start();
$file=$_SESSION['file'];
$jobid=$_POST['jobid'];
$newfile=$_SESSION['newfile'];
//$jobid=_ssession[jobid];
//$file = $_GET['file'];

$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 fogra90T 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);

?>