What is the main issue with the mysql_query function in the PHP code provided?

The main issue with the mysql_query function in the provided PHP code is that it is deprecated and not recommended for use in modern PHP versions. To solve this issue, you should switch to using MySQLi or PDO extensions for database operations in PHP. 

// Fix using MySQLi extension
$connection = new mysqli("localhost", "username", "password", "database");

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

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

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

$connection->close();

Keywords

mysql_query deprecated SQL injection mysqli PDO

Related Questions