What are some best practices for adding up values from a database column in PHP?

When adding up values from a database column in PHP, it is best practice to use SQL queries to fetch the data and perform the calculation directly in the query rather than fetching all the data and summing it in PHP code. This approach is more efficient and reduces the amount of data transferred between the database and the PHP script. 

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

// Query to sum values from a column
$sql = "SELECT SUM(column_name) AS total FROM table_name";

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

if ($result->num_rows > 0) {
    // Output the total sum
    $row = $result->fetch_assoc();
    echo "Total sum: " . $row["total"];
} else {
    echo "0 results";
}

$conn->close();
?>

Keywords

SQL database aggregation PHP sum

Related Questions