Web Service

Restful  Get

http://3.114.197.59/18B20/ss18B20_into.php?ID_No=X5wcKwL9&Temp=25.7

18B20.sql

<?php

$servername = "127.0.0.1";

$username = "root";

$password = "txxx2012";

$dbname = "dxxxxu";

date_default_timezone_set("Asia/Taipei");

$ID_No = $_GET['ID_No'];

$Temp = $_GET['Temp'];       

if (empty($_GET['state'])) {

    $state = "-9999";

}else{

    $state = $_GET['state'];

}

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);

} 

$lock = "LOCK TABLES 18B20 WRITE";

$conn->query($lock);

$date = date_create();

$dte = date_timestamp_get($date)+28800;

echo $dte;

$sql = "INSERT INTO 18B20(datetime, ID_No, Temp , state, create_time)

VALUES ( $dte , '$ID_No', $Temp, $state, NOW())";

$unlock = "UNLOCK TABLES spacesensor WRITE";

$conn->query($lock);

$conn->close();

?>

http://3.114.197.59/sw/SW_into.php?ID_No=UmAHFEBg&state=1    data input

http://3.114.197.59/sw/trendchart_sw.php?interval=1&sampling=1&ID_No=UmAHFEBg   trend display

restful get   http://3.114.197.59/18B20/ss18B20_into.php?ID_No=X5wcKwL9&Temp=25.7

display http://3.114.197.59/18b20/trendchart_t2.php?interval=3&sampling=1&ID_No=X5wcKwL9

call ios 捷徑 mqtt 語音發音  http://3.114.197.59/MQTT/publish.php?topic=jjiot&value=%E6%88%91%E6%98%AF%E7%B0%A1%E6%96%87%E5%B1%B1%E6%95%99%E6%8E%88&MQTT=54.248.165.66