What is the significance of the mysql_num_rows function in PHP MySQL queries?

The mysql_num_rows function in PHP is used to retrieve the number of rows returned by a SELECT query in MySQL. This function is significant because it allows you to determine the size of the result set and iterate over the rows accordingly. It is commonly used in conjunction with fetching rows from a query result to process the data. 

// Connect to the database
$conn = mysqli_connect("localhost", "username", "password", "database");

// Run a SELECT query
$result = mysqli_query($conn, "SELECT * FROM table");

// Get the number of rows returned
$num_rows = mysqli_num_rows($result);

// Process the rows
if($num_rows > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        // Process each row
    }
} else {
    echo "No rows found.";
}

// Free the result set
mysqli_free_result($result);

// Close the connection
mysqli_close($conn);

Keywords

PHP MySQL mysql_num_rows function queries

Related Questions