$expense = array_pop($expenses); $expense->delete(); } for ($ii = 0; $ii < $numExpenseEntries; $ii++) { if ($ii <= $numExpenseUpdates - 1) { // update existing expense entry if it has changed $expense = $expenses[$ii]; if ($expenseEntries[$ii]["desc"] !== $expense->description || intval($expenseEntries[$ii]["typeID"]) !== intval($expense->typeID) || floatval($expenseEntries[$ii]["amount"]) !== floatval($expense->amount)) { $expense->description = $expenseEntries[$ii]["desc"]; $expense->amount = Expense::formatAmount($expenseEntries[$ii]["amount"]); $expense->typeID = $expenseEntries[$ii]["typeID"]; $expense->save(array("amount", "description", "typeID")); } } else { // insert new expense entry $expense = new Expense(); $expense->userID = $user->id; $expense->amount = Expense::formatAmount($expenseEntries[$ii]["amount"]); $expense->date = $mySqlFormatedDate; $expense->description = $expenseEntries[$ii]["desc"]; $expense->typeID = $expenseEntries[$ii]["typeID"]; $expense->save(); } } // redirect back to the same day after processing the form header("Location: " . BASE_URL . "main/?month={$selectedMonth}&day={$selectedDay}&year={$selectedYear}"); exit; } // Update $incomes and $expenses so that they contain the modified entries $incomes = Income::findBySql('SELECT * FROM incomes WHERE userID = "' . $user->id . '" AND date = "' . $mySqlFormatedDate . '" ORDER BY id'); $expenses = Expense::findBySql('SELECT * FROM expenses WHERE userID = "' . $user->id . '" AND date = "' . $mySqlFormatedDate . '"ORDER BY id');