What is the potential issue with using mysql_query() to retrieve data from a database in PHP?

The potential issue with using mysql_query() to retrieve data from a database in PHP is that it is deprecated as of PHP 5.5.0 and removed in PHP 7.0.0. It is recommended to use MySQLi or PDO extensions for database operations in PHP to ensure better security, performance, and support for newer MySQL features. 

// Using MySQLi extension to retrieve data from a database
$mysqli = new mysqli("localhost", "username", "password", "database");

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

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

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        // Process data
    }
} else {
    echo "0 results";
}

$mysqli->close();

Keywords

mysql_query database retrieval SQL injection deprecated function security vulnerability

Related Questions