使用SET变量statment查询Mysqli(即多个查询)

// 创建数据库连接
$mysqli = new mysqli("localhost", "username", "password", "database");

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

// 定义SQL查询
$sql = "SET @sql = 'SELECT * FROM table1 WHERE column1 = 'value1''; PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;";

// 执行多个查询
if ($mysqli->multi_query($sql)) {
    do {
        // 存储结果
        if ($result = $mysqli->store_result()) {
            // 处理结果
            while ($row = $result->fetch_assoc()) {
                echo "结果: " . $row["column_name"] . "<br>";
            }
            // 释放结果集
            $result->free();
        }
        // 检查是否有更多结果
    } while ($mysqli->more_results() && $mysqli->next_result());
}

// 关闭连接
$mysqli->close();