query("INSERT INTO expenses (payer_name, amount, description) VALUES ('$p', '$a', '$d')"); // Refresh page to show new data header("Location: index.php"); } } // 2. FETCH TOTALS & LOGIC $target_total = 40000; // Your total experience cost $share_per_man = $target_total / 2; // 20,000 each $res = $conn->query("SELECT payer_name, SUM(amount) as total FROM expenses GROUP BY payer_name"); $paid = ['Man 1' => 0, 'Man 2' => 0]; if ($res) { while($row = $res->fetch_assoc()) { $paid[$row['payer_name']] = $row['total']; } } // Logic for Man 2's deposit $m2_owes = $share_per_man - $paid['Man 2']; ?> Expense Tracker

Expense Tracker

Target Total

₹

Man 1 Paid

₹

Man 2 Status

0) { echo "Deposit: ₹" . number_format($m2_owes); } else { echo "Settled/Overpaid"; } ?>

query("SELECT * FROM expenses ORDER BY id DESC"); while($row = $list->fetch_assoc()): ?>
Date Who Paid Description Amount
₹