PHP MySQL Connect

<?php
$host   = "localhost";
$user   = "root";
$pass   = "secret";
$dbname = "myapp";

// Create connection
$conn = mysqli_connect($host, $user, $pass, $dbname);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

echo "Connected successfully";

// Close connection
mysqli_close($conn);
?>

<?php
$host   = "localhost";
$user   = "root";
$pass   = "secret";
$dbname = "myapp";

// OOP style
$mysqli = new mysqli($host, $user, $pass, $dbname);

// Check connection
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

echo "Connected. Server info: " . $mysqli->server_info;

// Set charset (important for UTF-8)
$mysqli->set_charset("utf8mb4");

// Close
$mysqli->close();
?>

<?php
$host   = "localhost";
$dbname = "myapp";
$user   = "root";
$pass   = "secret";
$charset = "utf8mb4";

$dsn = "mysql:host=$host;dbname=$dbname;charset=$charset";

$options = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];

try {
    $pdo = new PDO($dsn, $user, $pass, $options);
    echo "PDO connected successfully";
    echo "Driver: " . $pdo->getAttribute(PDO::ATTR_DRIVER_NAME);
} catch (\PDOException $e) {
    // Never expose connection details in production
    error_log($e->getMessage());
    throw new \PDOException("Database connection failed", (int)$e->getCode());
}

// PDO connection is closed by setting to null
$pdo = null;
?>