<?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
$getCo=$_GET['getCo'];


//echo "getCo:".$getCo."_".$getPo;
$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'");



		$querys = "select * from spotreport where company='$getCo' ORDER BY id DESC  ";
		//echo $querys;
		$result =  mysqli_query($conn, $querys);

$poArray = [];
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $poArray[] = $row["po"];
    }
}

$conn->close();

echo json_encode(["po" => $poArray]);
?>