从预准备语句函数PHP返回变量

// 连接数据库
$dsn = "mysql:host=localhost;dbname=mydatabase";
$username = "username";
$password = "password";
$dbh = new PDO($dsn, $username, $password);

// 准备预准备语句
$stmt = $dbh->prepare("SELECT * FROM mytable WHERE id = :id");

// 绑定参数
$id = 1;
$stmt->bindParam(':id', $id);

// 执行查询
$stmt->execute();

// 获取结果
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "mydatabase";
$conn = new mysqli($servername, $username, $password, $dbname);

// 准备预准备语句
$stmt = $conn->prepare("SELECT * FROM mytable WHERE id = ?");

// 绑定参数
$id = 1;
$stmt->bind_param("i", $id);

// 执行查询
$stmt->execute();

// 获取结果
$result = $stmt->get_result();
$data = $result->fetch_all(MYSQLI_ASSOC);