<?php
$servername ="163.44.198.63:3306";
$username ="cp329720";
$password =  "Siam1219!";
$dbname ="cp329720_siamatic";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

   $dev_sn= $_GET['dev_sn'];

    $sql = "SELECT * FROM devices WHERE dev_sn = '$dev_sn'" ;
    $result = $conn->query($sql);
    
    if ($result->num_rows > 0) {
      // output data of each row
      while($row = $result->fetch_assoc()) {
         $logs[] = $row;
      }
      
        echo json_encode($logs);
    
    } else {
      echo "0 results";
    }
$conn->close();
?>