What is the best way to display the number of entries in a specific category from a database in a dropdown menu using PHP?

To display the number of entries in a specific category from a database in a dropdown menu using PHP, you can first query the database to count the number of entries in that category. Then, you can populate the dropdown menu with the category name and the corresponding count using a loop. 

<?php
// Connect to the 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 get the count of entries in a specific category
$category = "category_name";
$sql = "SELECT COUNT(*) as count FROM your_table WHERE category = '$category'";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$count = $row['count'];

// Display the dropdown menu
echo "<select>";
echo "<option value=''>$category ($count)</option>";
echo "</select>";

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

Keywords

PHP database dropdown menu category entries

Related Questions