What is the best way to calculate an average in real-time using PHP and MySQL?

To calculate an average in real-time using PHP and MySQL, you can continuously update the average value as new data is added to the database. This can be achieved by keeping track of the total sum and count of values, and then dividing the sum by the count to get the average. 

// Connect to MySQL database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Retrieve existing sum and count from database
$sql = "SELECT SUM(value) AS total_sum, COUNT(value) AS total_count FROM table";
$result = $conn->query($sql);
$row = $result->fetch_assoc();
$total_sum = $row['total_sum'];
$total_count = $row['total_count'];

// Add new value to database
$new_value = 10;
$sql = "INSERT INTO table (value) VALUES ($new_value)";
$conn->query($sql);

// Update sum and count
$total_sum += $new_value;
$total_count++;

// Calculate average
$average = $total_sum / $total_count;

echo "Average: " . $average;

Keywords

PHP MySQL real-time average calculation performance.

Related Questions