php连接mysql推荐方式

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

    $stmt = $pdo->prepare('SELECT * FROM users WHERE id = :id');
    $stmt->bindParam(':id', $id, PDO::PARAM_INT);
    $id = 1;
    $stmt->execute();
    $user = $stmt->fetch(PDO::FETCH_ASSOC);

    echo 'User: ' . $user['name'];
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}
?>

<?php
$mysqli = new mysqli('localhost', 'username', 'password', 'testdb');

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

$stmt = $mysqli->prepare('SELECT * FROM users WHERE id = ?');
$stmt->bind_param('i', $id);
$id = 1;
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_assoc();

echo 'User: ' . $user['name'];

$mysqli->close();
?>