What is the best way to count the occurrences of a specific value in multiple columns in a MySQL database using PHP?

To count the occurrences of a specific value in multiple columns in a MySQL database using PHP, you can use a SQL query with the COUNT function and WHERE clause to filter the specific value. You can then execute the query using PHP's mysqli or PDO extension to fetch the count result. 

<?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);
}

// Define the specific value to count
$value = "specific_value";

// SQL query to count occurrences of the specific value in multiple columns
$sql = "SELECT COUNT(*) AS count FROM table_name WHERE column1 = '$value' OR column2 = '$value' OR column3 = '$value'";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output the count result
    $row = $result->fetch_assoc();
    echo "Count of $value: " . $row["count"];
} else {
    echo "0 results";
}

$conn->close();

?>

Keywords

PHP MySQL count occurrences multiple columns

Related Questions