如何将两个值从html导入到我的SQL表中

<form action="insert.php" method="POST">
  <label for="value1">Value 1:</label>
  <input type="text" id="value1" name="value1"><br><br>
  <label for="value2">Value 2:</label>
  <input type="text" id="value2" name="value2"><br><br>
  <input type="submit" value="Submit">
</form>

<?php
// 连接到数据库
$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名称";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接数据库失败: " . $conn->connect_error);
}

// 获取从HTML表单传递过来的值
$value1 = $_POST['value1'];
$value2 = $_POST['value2'];

// 执行SQL插入语句
$sql = "INSERT INTO 表名 (列1, 列2) VALUES ('$value1', '$value2')";
if ($conn->query($sql) === TRUE) {
    echo "数据插入成功";
} else {
    echo "数据插入失败: " . $conn->error;
}

// 关闭数据库连接
$conn->close();
?>