PHP REST API在物联网领域的应用潜力

// 界说传感器数据模子
class SensorData {
    public $id;
    public $sensor_id;
    public $value;
    public $timestamp;
}

// 创立数据库联接
$conn = new <a style='color:#f60; text-decoration:underline;' href="https://www.php.cn/zt/15713.html" target="_blank">mysql</a>i($db_host, $db_user, $db_pass, $db_name);

// 创立一个 RESTful API 路由
$api_router = new Router();

// 加添路由以猎取一切传感器数据
$api_router->get('/sensors', function () use ($conn) {
    $sql = "SELECT * FROM sensor_data";
    $result = $conn->query($sql);
    if ($result) {
        $sensors = [];
        while ($row = $result->fetch_assoc()) {
            $sensors[] = new SensorData($row);
        }
        return $sensors;
    } else {
        return ['error' => 'Error fetching sensors'];
    }
});

// 加添路由以建立新传感器数据
$api_router->post('/sensors', function () use ($conn) {
    $sensor_id = $_POST['sensor_id'];
    $value = $_POST['value'];
    $timestamp = time();

    $sql = "INSERT INTO sensor_data (sensor_id, value, timestamp) VALUES (必修, 选修, 必修)";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param('isi', $sensor_id, $value, $timestamp);
    if ($stmt->execute()) {
        return ['success' => 'New sensor data created'];
    } else {
        return ['error' => 'Error creating new sensor data'];
    }
});

// 封动 RESTful API 供职
$api_router->run();