如何使用php添加具有匹配合作伙伴名称的值

$partner_name = $_POST['partner_name'];

// 连接到数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

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

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 创建一个用于存储合作伙伴名称的表
$sql = "CREATE TABLE partners (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    partner_name VARCHAR(30) NOT NULL
)";

if ($conn->query($sql) === TRUE) {
    echo "表 partners 创建成功";
} else {
    echo "创建表错误: " . $conn->error;
}

// 将合作伙伴名称的值插入到表中
$sql = "INSERT INTO partners (partner_name) VALUES ('$partner_name')";

if ($conn->query($sql) === TRUE) {
    echo "合作伙伴名称的值已成功添加到数据库";
} else {
    echo "添加值错误: " . $conn->error;
}

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

<form action="add_partner_value.php" method="post">
    <label for="partner_name">合作伙伴名称:</label>
    <input type="text" id="partner_name" name="partner_name">
    <input type="submit" value="提交">
</form>