Skip to content
PHP Logo

How can the mysql_num_rows() function be used to count results in PHP when checking for existing data in a database?

When checking for existing data in a database using PHP, you can use the mysql_num_rows() function to count the number of rows returned by a query. This function can be used after executing a SELECT query to determine if any results were found. If the count is greater than 0, it means the data exists in the database.

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

// Check for existing data
$query = "SELECT * FROM table_name WHERE condition";
$result = mysqli_query($conn, $query);

if(mysqli_num_rows($result) > 0) {
    // Data exists in the database
    echo "Data exists";
} else {
    // Data does not exist in the database
    echo "Data does not exist";
}

// Close the connection
mysqli_close($conn);