What is the difference between using "sum()" and "count()" functions in SQL queries within a PHP script?

When using SQL queries within a PHP script, the "sum()" function is used to calculate the total sum of a specific column, typically a numeric column, while the "count()" function is used to count the number of rows that meet a certain condition. To use the "sum()" function in a SQL query within a PHP script, you would include it in your SELECT statement and specify the column you want to sum. For example, "SELECT SUM(column_name) FROM table_name WHERE condition;" To use the "count()" function in a SQL query within a PHP script, you would include it in your SELECT statement and specify the column you want to count. For example, "SELECT COUNT(column_name) FROM table_name WHERE condition;" Here is an example PHP code snippet that demonstrates the use of both functions: 

<?php
// Connect to 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);
}

// Using sum() function
$sql_sum = "SELECT SUM(price) AS total_price FROM products WHERE category = 'Electronics'";
$result_sum = $conn->query($sql_sum);
$row_sum = $result_sum->fetch_assoc();
echo "Total price of Electronics: $" . $row_sum['total_price'] . "<br>";

// Using count() function
$sql_count = "SELECT COUNT(*) AS total_products FROM products WHERE category = 'Electronics'";
$result_count = $conn->query($sql_count);
$row_count = $result_count->fetch_assoc();
echo "Total number of Electronics products: " . $row_count['total_products'];

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

Keywords

PHP SQL queries sum() count() difference

Related Questions