我在PHP表单中添加了新的输入字段，但它不再将数据发送到SQL server。

<!-- 示例表单 -->
<form method="post" action="submit.php">
    <input type="text" name="new_field" />
    <!-- 其他字段 -->
    <input type="submit" value="Submit" />
</form>

<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $newFieldValue = $_POST['new_field']; // 确保字段名匹配
    // 其他处理逻辑
}
?>

<?php
$servername = "your_server";
$username = "your_username";
$password = "your_password";
$dbname = "your_dbname";

try {
    $conn = new PDO("sqlsrv:Server=$servername;Database=$dbname", $username, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $stmt = $conn->prepare("INSERT INTO your_table (column1, column2, new_column) VALUES (:col1, :col2, :new_col)");
    $stmt->bindParam(':col1', $value1);
    $stmt->bindParam(':col2', $value2);
    $stmt->bindParam(':new_col', $newFieldValue); // 绑定新字段

    $stmt->execute();
} catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
$conn = null;
?>

ALTER TABLE your_table ADD new_column VARCHAR(255); -- 根据需要调整数据类型和长度