PHP中数据库插入错误

1
2
3
4
5
6

$sql = "INSERT INTO SensorData (id, sensor, coords, value1, value2, value3) VALUES ('$id','$sensor', '$coords', '$value1', '$value2', '$value3')";
if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}