php执行多条mysql语句怎么写

<?php
$mysqli = new mysqli("localhost", "username", "password", "database");

if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect_error);
}

$sql = "SELECT * FROM table1; SELECT * FROM table2;";

if ($mysqli->multi_query($sql)) {
    do {
        if ($result = $mysqli->store_result()) {
            // 处理结果集
            while ($row = $result->fetch_assoc()) {
                // 处理每一行数据
            }
            $result->free();
        }
    } while ($mysqli->next_result());
}

$mysqli->close();
?>

<?php
try {
    $pdo = new PDO("mysql:host=localhost;dbname=database", "username", "password");
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 开始事务
    $pdo->beginTransaction();

    $sql1 = "UPDATE table1 SET column1 = 'value' WHERE condition";
    $sql2 = "INSERT INTO table2 (column1, column2) VALUES ('value1', 'value2')";

    $pdo->exec($sql1);
    $pdo->exec($sql2);

    // 提交事务
    $pdo->commit();
} catch (PDOException $e) {
    // 发生错误，回滚事务
    $pdo->rollBack();
    echo "数据库错误: " . $e->getMessage();
}

$pdo = null;
?>

<?php
$mysqli = new mysqli("localhost", "username", "password", "database");

if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect议rror);
}

$stmt1 = $mysqli->prepare("UPDATE table1 SET column1 = ? WHERE condition");
$stmt2 = $mysqli->prepare("INSERT INTO table2 (column1, column2) VALUES (?, ?)");

// 绑定参数并执行第一条语句
$stmt1->bind_param("s", $value1);
$stmt1->execute();

// 绑定参数并执行第二条语句
$stmt2->bind_param("ss", $value2, $value3);
$stmt2->execute();

$mysqli->close();
?>