php 多表单

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $username = $_POST['username'];
    $email = $_POST['email'];

    if (empty($username) || empty($email)) {
        echo "用户名和邮箱不能为空";
        return;
    }

    if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
        echo "邮箱格式不正确";
        return;
    }

    // 数据库操作...
}
?>

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // 处理表单数据...

    header("Location: success.php");
    exit();
}
?>

<?php
try {
    $pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
    $pdo->beginTransaction();

    // 插入数据到表1
    $stmt1 = $pdo->prepare("INSERT INTO table1 (column1) VALUES (:value1)");
    $stmt1->bindParam(':value1', $value1);
    $stmt1->execute();

    // 获取插入的数据ID
    $lastId = $pdo->lastInsertId();

    // 插入数据到表2，关联表1的数据
    $stmt2 = $pdo->prepare("INSERT INTO table2 (column2, table1_id) VALUES (:value2, :table1_id)");
    $stmt2->bindParam(':value2', $value2);
    $stmt2->bindParam(':table1_id', $lastId);
    $stmt2->execute();

    $pdo->commit();
} catch (Exception $e) {
    $pdo->rollBack();
    echo "Error: " . $e->getMessage();
}
?>