File: C:/xampp/htdocs/FograCT1/setokOLD.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['file'];
$f321=$_GET['f321'];
$newfile= $_GET['newfile'];
$company= $_GET['company'];
$po= $_GET['po'];
$jobid= $_POST['jobid'];
$TL=$_GET['TL'];
$Ta=$_GET['Ta'];
$Tb=$_GET['Tb'];
$sNo=$_GET['sNo'];
$TRGB=$_GET['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, fileT, spotO,spot, TRGB, TL, Ta, Tb, ddate) VALUES('$po','$company', '$f321', '1', '1','$TRGB','$TL', '$Ta','$Tb',NOW() )";
//echo $query;
$results = mysqli_query($conn, $query);
mysqli_close($conn);
$_SESSION["TL"] = "$TL";
$_SESSION["Ta"] = "$Ta";
$_SESSION["Tb"] = "$Tb";
?>