How to make a connection with MySQL server using PHP (PDO & MySQLi)?
PHP connection code examples using both PDO (PHP Data Objects) and MySQLi procedural/OOP.
SQL Query Statement
<?php
// Method 1: PDO Connection (Recommended)
try {
$dsn = "mysql:host=localhost;dbname=company_db;charset=utf8mb4";
$pdo = new PDO($dsn, "root", "password", [
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
]);
echo "PDO: Connected successfully!\n";
} catch (PDOException $e) {
die("PDO Connection Failed: " . $e->getMessage());
}
// Method 2: MySQLi Connection
$mysqli = new mysqli("localhost", "root", "password", "company_db");
if ($mysqli->connect_error) {
die("MySQLi Error: " . $mysqli->connect_error);
}
echo "MySQLi: Connected successfully!";
?>Expected Result / Output
PDO: Connected successfully! MySQLi: Connected successfully!