How can PHP developers migrate from using mysql_* functions to modern mysqli_query() or PDO methods for database queries?

The mysql_* functions in PHP are deprecated and no longer recommended for use due to security vulnerabilities and lack of support. To migrate from mysql_* functions to modern mysqli_query() or PDO methods for database queries, developers should update their code to use prepared statements, parameterized queries, and error handling to ensure secure and efficient database interactions. 

// Using mysqli_query() method for database queries
$mysqli = new mysqli("localhost", "username", "password", "database");

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

$sql = "SELECT * FROM users WHERE id = ?";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("i", $id);

$id = 1;
$stmt->execute();
$result = $stmt->get_result();

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

$stmt->close();
$mysqli->close();

Keywords

PHP mysql_ functions mysqli_query() PDO database queries

Related Questions