What are the advantages of using mysqli or PDO over the mysql extension in PHP for database connectivity?

The mysql extension in PHP is deprecated and has been removed in PHP 7. Instead, it is recommended to use either the mysqli extension or PDO for database connectivity in PHP. Both mysqli and PDO offer advantages such as support for prepared statements, transactions, and multiple database drivers, making them more secure and flexible options for interacting with databases. 

// Using PDO for database connectivity
$dsn = 'mysql:host=localhost;dbname=mydatabase';
$username = 'username';
$password = 'password';

try {
    $pdo = new PDO($dsn, $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

// Using mysqli for database connectivity
$mysqli = new mysqli('localhost', 'username', 'password', 'mydatabase');
if ($mysqli->connect_error) {
    die('Connection failed: ' . $mysqli->connect_error);
}

Keywords

mysqli PDO mysql extension database connectivity advantages

Related Questions