<?php
$file= $_POST['file'];
$fileOK= substr($file,7,45);
$jobid=$_POST['file'];
$newfile=$_POST['newfile'];

$okPool='C:/xampp/htdocs/FWOK/'.$fileOK.".txt";
echo $okPool."<p>";
if (!copy($file, $newfile)) {
    echo "failed to copy $file...\n";
}
else {


copy($file, $okPool);

echo "OK sheet �]�w����";
}
  $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 production set setOK='1', okName='$jobid' where  filename = '$fileOK'";
		echo $query;
		//echo $query;
		$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
  
		mysql_close($connection);
?>