What alternative functions or methods can be used instead of the deprecated mysql_ functions in PHP?

The mysql_ functions in PHP have been deprecated since PHP 5.5 and removed in PHP 7. Instead of using these functions, it is recommended to use either MySQLi (MySQL Improved) or PDO (PHP Data Objects) extensions to interact with a MySQL database. These extensions offer improved security, performance, and flexibility compared to the old mysql_ functions. 

// Using MySQLi extension
$mysqli = new mysqli('localhost', 'username', 'password', 'database_name');
if ($mysqli->connect_error) {
    die('Connection failed: ' . $mysqli->connect_error);
}

// Using PDO extension
try {
    $pdo = new PDO('mysql:host=localhost;dbname=database_name', 'username', 'password');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    die('Connection failed: ' . $e->getMessage());
}

Keywords

mysqli PDO database migration security

Related Questions