How can the error in the code snippet be resolved to prevent the warning related to mysql_fetch_array()?

The warning related to mysql_fetch_array() can be resolved by switching to the mysqli extension, as mysql functions are deprecated in newer versions of PHP. By using the mysqli extension, we can fetch rows from a result set using the mysqli_fetch_array() function instead. This will prevent the warning and ensure compatibility with newer PHP versions. 

// Connect to the database using mysqli
$mysqli = new mysqli("localhost", "username", "password", "database");

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

// Query the database
$result = $mysqli->query("SELECT * FROM table");

// Fetch rows using mysqli_fetch_array
while ($row = $result->fetch_array()) {
    // Process each row
}

// Close the connection
$mysqli->close();

Keywords

PHP mysql_fetch_array mysqli database warning

Related Questions