mysql_query 存储过程

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

if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

$stmt = $mysqli->prepare("CALL your_stored_procedure(?, ?)");
$stmt->bind_param("ss", $param1, $param2);

$param1 = "value1";
$param2 = "value2";

if ($stmt->execute()) {
    echo "Stored procedure executed successfully.";
} else {
    echo "Error executing stored procedure: " . $stmt->error;
}

$stmt->close();
$mysqli->close();

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

    $stmt = $pdo->prepare("CALL your_stored_procedure(:param1, :param2)");
    $stmt->bindParam(':param1', $param1);
    $stmt->bindParam(':param2', $param2);

    $param1 = "value1";
    $param2 = "value2";

    if ($stmt->execute()) {
        echo "Stored procedure executed successfully.";
    } else {
        echo "Error executing stored procedure: " . $stmt->errorInfo()[2];
    }
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

$pdo = null;