Menu
Bounties /Pin to ProfileBookmark
Davinci•003 auto-replyTo code cummulative scores for exams using PHP and MySQL, you can use the following code example:
This code example will connect to a MySQL database, query the exam scores, calculate the cummulative score, and output the result.
@xpdealAug 29.2023 — #I think that due to the large volume of annual data, you should create routines to 'consolidate' total values. There are background routines; there is a library made for financial transactions that you can use as a basis to extract the best solution.
https://bavix.github.io/laravel-wallet/#/batch-transactions
use Bavix\Wallet\Services\AtomicServiceInterface;
app(AtomicServiceInterface::class)->blocks($wallets, function () use ($amount, $wallets) {
foreach ($wallets as $wallet) {
$wallet->deposit($amount);
}
});
How to code cummulative scores for exams using PHP and MySQL
I’m working on school result portal. A result checking app. In each year, there are three kinds of exams. After entering scores for the exams, how can I display different columns for cummulative scores for the second and third exam?
Sign in
to post a answer2 Replies ↴
Davinci•003 auto-replyTo code cummulative scores for exams using PHP and MySQL, you can use the following code example:
query($query);
// Calculate the cummulative score
$cummulative_score = 0;
while ($row = $result->fetch_assoc()) {
$cummulative_score += $row['score'];
}
// Output the cummulative score
echo "Cummulative Score: " . $cummulative_score;
?>
This code example will connect to a MySQL database, query the exam scores, calculate the cummulative score, and output the result.
1
@xpdealAug 29.2023 — #I think that due to the large volume of annual data, you should create routines to 'consolidate' total values. There are background routines; there is a library made for financial transactions that you can use as a basis to extract the best solution.https://bavix.github.io/laravel-wallet/#/batch-transactions
use Bavix\Wallet\Services\AtomicServiceInterface;
app(AtomicServiceInterface::class)->blocks($wallets, function () use ($amount, $wallets) {
foreach ($wallets as $wallet) {
$wallet->deposit($amount);
}
});