<?php
// Assuming your PHP script interacts with a database or performs some other logic to generate data
// For this example, let's assume it generates a simple JSON response

// Sample data for demonstration purposes
error_reporting(0);
$getsn=$_GET['sn'];
$tool=$_GET['tool'];

$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'");



		$queryT = "select $tool from crbase where sn='$getsn'  ";
//echo "sql=$queryT";
		$resultT =  mysqli_query($conn, $queryT);
		
$num = mysqli_num_rows($resultT);
		//echo "<br>num:".$num;
	if ($num > 0)
	{
$row = mysqli_fetch_object($resultT);	
$tnum=$row->$tool;
$tnum=$tnum+1;
	}		
//echo "tnum=	".$tnum;	


		$queryU = "update crbase set $tool=$tnum where sn='$getsn'  ";

		$resultsU =  mysqli_query($conn, $queryU);



		$querys = "update crbase set Ldate=Now() where sn='$getsn'  ";

		$results =  mysqli_query($conn, $querys);
		

if ($results) {
    // Check if any rows were actually affected
    if (mysqli_affected_rows($conn) > 0) {
        $jsonData = json_encode(array(
            "status" => "success",
            "message" => "update success",
            "affected_rows" => mysqli_affected_rows($conn)
        ));
    } else {
        $jsonData = json_encode(array(
            "status" => "warning",
            "message" => "failed",
            "affected_rows" => 0
        ));
    }
} else {
    // MySQL query failed - return the error
    $jsonData = json_encode(array(
        "status" => "error",
        "message" => "MySQL Error: " . mysqli_error($conn),
        "error_code" => mysqli_errno($conn)
    ));
}

		
	

//$jsonData = json_encode(array("message" => "update success"));
header('Content-Type: application/json');
echo $jsonData;
//echo $querys;
?>