What are the advantages and disadvantages of using the old mysql query method versus more modern approaches in PHP?

When using the old MySQL query method in PHP, the main advantage is that it is simple and straightforward to use. However, it is deprecated and not recommended for use in modern PHP applications. More modern approaches, such as using PDO or MySQLi, offer better security features, support for prepared statements, and overall better performance. 

// Using PDO to query the database
try {
    $pdo = new PDO("mysql:host=localhost;dbname=mydatabase", "username", "password");
    $stmt = $pdo->prepare("SELECT * FROM mytable WHERE column = :value");
    $stmt->bindParam(':value', $value);
    $stmt->execute();
    $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
    foreach ($results as $row) {
        // process the results
    }
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}

Keywords

mysql_query mysqli PDO SQL injection performance

Related Questions