What is the correct syntax for counting the number of matches in a MySQL table using PHP?

To count the number of matches in a MySQL table using PHP, you can use the following SQL query: "SELECT COUNT(*) FROM table_name WHERE condition". This query will return the number of rows that match the specified condition in the table. You can then fetch this result in your PHP code to get the count. 

<?php
// Connect to MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

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

// Query to count number of matches
$sql = "SELECT COUNT(*) AS count FROM table_name WHERE condition";
$result = $conn->query($sql);

// Fetch the result
if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $count = $row['count'];
    echo "Number of matches: " . $count;
} else {
    echo "No matches found";
}

// Close connection
$conn->close();
?>

Keywords

PHP MySQL syntax counting matches

Related Questions