Print total of a variable inside while loop outside of the loop

To
accumulate values from a MySQL query inside a while loop and then
calculate the total value outside the loop, you can use a variable to
store the total value while iterating through the records. Here’s an
example in PHP:

<?php
// Your database connection parameters
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$database = "your_database";

// Create a connection to the MySQL database
$conn = new mysqli($servername, $username, $password, $database);

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

$totalValue = 0; // Initialize total value

// Your SQL query
$sql = "SELECT value_column FROM your_table_name WHERE your_conditions";

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

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        // Access value column and accumulate the values
        $value = $row['value_column'];
        $totalValue += $value;
        
        // You can also store values in an array if needed
        // $valuesArray[] = $value;
    }
    
    echo "Total value: $totalValue"; // Print total value
    // If you stored values in an array, you can print or manipulate the array here
    // print_r($valuesArray);
} else {
    echo "No records found.";
}

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

This PHP script fetches records
from the database, accumulates the values from a specific column
(value_column), and calculates the total value by adding up these values
inside the while loop. After the loop, it prints the total value
obtained. If you need to store these values in an array for further
processing, you can uncomment and modify the $valuesArray[] = $value;
line accordingly.