使用PHP将一个简单的表单发布到两个表

// 数据库连接信息
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database_name";

// 建立数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

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

// 获取表单数据
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];

// 插入数据到表1
$sql1 = "INSERT INTO table1 (name, email, phone) VALUES ('$name', '$email', '$phone')";
if ($conn->query($sql1) === true) {
    echo "数据插入表1成功";
} else {
    echo "数据插入表1失败: " . $conn->error;
}

// 插入数据到表2
$sql2 = "INSERT INTO table2 (name, email, phone) VALUES ('$name', '$email', '$phone')";
if ($conn->query($sql2) === true) {
    echo "数据插入表2成功";
} else {
    echo "数据插入表2失败: " . $conn->error;
}

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