如何用PHP在MySQL表中新增数据条目

<?php
$dsn = "mysql:host=localhost;dbname=mydatabase;charset=utf8mb4";
$username = "myuser";
$password = "mypassword";

try {
    $pdo = new PDO($dsn, $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sql = "INSERT INTO users (username, email) VALUES (:username, :email)";
    $stmt = $pdo->prepare($sql);

    $username = $_POST['username']; // 从POST请求获取数据
    $email = $_POST['email'];       // 从POST请求获取数据

    $stmt->bindParam(':username', $username, PDO::PARAM_STR);
    $stmt->bindParam(':email', $email, PDO::PARAM_STR);

    $stmt->execute();

    echo "新记录创建成功";

} catch(PDOException $e) {
    echo "连接失败: " . $e->getMessage();
}
?>

<?php
// 假设你已经成功插入了一条记录
$lastId = $pdo->lastInsertId();
echo "最后插入的ID是: " . $lastId;
?>

<?php
try {
    $pdo->beginTransaction();

    $data = [
        ['username' => 'user1', 'email' => 'user1@example.com'],
        ['username' => 'user2', 'email' => 'user2@example.com'],
        ['username' => 'user3', 'email' => 'user3@example.com'],
    ];

    $sql = "INSERT INTO users (username, email) VALUES (:username, :email)";
    $stmt = $pdo->prepare($sql);

    foreach ($data as $row) {
        $stmt->bindParam(':username', $row['username'], PDO::PARAM_STR);
        $stmt->bindParam(':email', $row['email'], PDO::PARAM_STR);
        $stmt->execute();
    }

    $pdo->commit();
    echo "批量插入成功";

} catch (PDOException $e) {
    $pdo->rollBack();
    echo "批量插入失败: " . $e->getMessage();
}
?>

<?php
$date = date('Y-m-d'); // 获取当前日期，格式为YYYY-MM-DD
$dateTime = date('Y-m-d H:i:s'); // 获取当前日期和时间，格式为YYYY-MM-DD HH:MM:SS

$sql = "INSERT INTO events (event_date, event_datetime) VALUES (:event_date, :event_datetime)";
$stmt = $pdo->prepare($sql);
$stmt->bindParam(':event_date', $date, PDO::PARAM_STR);
$stmt->bindParam(':event_datetime', $dateTime, PDO::PARAM_STR);
$stmt->execute();
?>