HEX

File: C:/xampp/htdocs/FograCT1/setok2.php
<?php
// Start the session
session_start();
$_SESSION["favcolor"] = "green";
?>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Spot Check</title>
</head>
<?php
//error_reporting(0);
//$file= ("upload/".$_GET['file']);
$filename=$_GET['f321'];
//$newfile= $_GET['newfile'];
$company= $_GET['company'];
$po= $_GET['po'];
//$jobid= $_POST['jobid'];

$TL=$_POST['cTL'];
$Ta=$_POST['cTa'];
$Tb=$_POST['cTb'];
$sNo=$_GET['sNo'];
$TRGB=$_GET['TRGB'];


	
echo "trgb:".$TRGB;


echo "目標設定完成";

 $servername = "127.0.0.1";
$username = "root";
$password = "fredsql";
$DBNAME = "tvicheck-st";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
//echo "Connected successfully";


if( !mysqli_select_db($conn, $DBNAME)) {
  die ("無法選擇資料庫");
}
mysqli_query( $conn, "SET NAMES 'utf8'");

		$query = "INSERT INTO processde(job,company, spotO, spot, fileT, TL, Ta, Tb, TRGB, ddate) VALUES('$po','$company', '1','1', '$filename', '$TL', '$Ta','$Tb','$TRGB',NOW() )";
		$results =  mysqli_query($conn, $query);
				//echo $query;
/*
$query = "update processde set TL='$TL',spotO='1', spot='1', TRGB='$TRGB', Ta='$Ta', Tb='$Tb' where job='$po' and fileT='$filename'";
	
		echo $query; 
		$results =  mysqli_query($conn, $query);
		*/
 mysqli_close($conn);


$_SESSION["filename"]=$filename;
$_SESSION["TL"] = "$TL";
$_SESSION["Ta"] = "$Ta";
$_SESSION["Tb"] = "$Tb";




?>