How can the code be improved to avoid the warning message related to mysql_num_rows()?

The warning message related to mysql_num_rows() can be avoided by switching to the mysqli extension or PDO for database operations. These extensions provide safer and more secure ways to interact with databases compared to the deprecated mysql extension. By using mysqli or PDO, the warning message can be eliminated while ensuring compatibility with newer versions of PHP. 

// Improved code using mysqli extension
$mysqli = new mysqli("localhost", "username", "password", "database");

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

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

echo "Number of rows: " . $row_count;

$mysqli->close();

Keywords

PHP mysql_num_rows() mysqli error handling deprecated

Related Questions