What are the potential pitfalls of using outdated functions like mysql_db_query in PHP?

Using outdated functions like mysql_db_query in PHP can lead to security vulnerabilities and compatibility issues with newer versions of PHP. It is recommended to use modern functions like mysqli or PDO for interacting with databases in PHP. By updating your code to use these newer functions, you can ensure better security and compatibility with current and future versions of PHP. 

// Connect to MySQL using mysqli
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

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

// Perform a query using mysqli
$sql = "SELECT * FROM tablename";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["name"]. "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();

Keywords

mysql_db_query outdated functions security vulnerabilities deprecated SQL injection

Related Questions