What is the best way to list each unique product in a table along with the number of entries for each product in PHP/MySQL?

To list each unique product in a table along with the number of entries for each product in PHP/MySQL, you can use a SQL query to group the products and count the number of entries for each product. Then, you can fetch the results and display them in a table format in your PHP code. 

<?php

// Connect to the database
$host = 'localhost';
$username = 'username';
$password = 'password';
$database = 'database';
$connection = new mysqli($host, $username, $password, $database);

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

// SQL query to count entries for each product
$sql = "SELECT product, COUNT(*) AS entry_count FROM products_table GROUP BY product";

// Execute the query
$result = $connection->query($sql);

// Display the results in a table
echo "<table>";
echo "<tr><th>Product</th><th>Entry Count</th></tr>";
while ($row = $result->fetch_assoc()) {
    echo "<tr><td>" . $row['product'] . "</td><td>" . $row['entry_count'] . "</td></tr>";
}
echo "</table>";

// Close the connection
$connection->close();

?>

Keywords

PHP MySQL unique product table entries

Related Questions