What are alternative methods to the deprecated mysql_* functions for database operations in PHP?

The deprecated mysql_* functions in PHP have been replaced by MySQLi (MySQL Improved) and PDO (PHP Data Objects) extensions for database operations. These alternatives provide improved security, support for prepared statements, and are more versatile for working with different database systems. 

// Using MySQLi for database operations
$mysqli = new mysqli("localhost", "username", "password", "database");

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

// Perform a query
$result = $mysqli->query("SELECT * FROM table");

// Fetch data
while ($row = $result->fetch_assoc()) {
    // Process data
}

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

Keywords

mysqli PDO database operations PHP functions deprecated

Related Questions