add_record.php 1.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. <?php
  2. require 'config.php';
  3. if ($_SERVER['REQUEST_METHOD'] === 'POST') {
  4. $debtorName = $_POST['debtorName'];
  5. $repaymentDate = $_POST['repaymentDate'];
  6. $repaymentMethod = $_POST['repaymentMethod'];
  7. $repaymentAmount = $_POST['repaymentAmount'];
  8. $comments = $_POST['comments'];
  9. $stmt = $pdo->prepare("INSERT INTO repayments (debtor_name, repayment_date, repayment_method, repayment_amount, comments) VALUES (:debtorName, :repaymentDate, :repaymentMethod, :repaymentAmount, :comments)");
  10. $stmt->execute([
  11. 'debtorName' => $debtorName,
  12. 'repaymentDate' => $repaymentDate,
  13. 'repaymentMethod' => $repaymentMethod,
  14. 'repaymentAmount' => $repaymentAmount,
  15. 'comments' => $comments
  16. ]);
  17. header('Location: index.php');
  18. exit;
  19. }
  20. ?>
  21. <!DOCTYPE html>
  22. <html>
  23. <head>
  24. <title>新增还款记录</title>
  25. </head>
  26. <body>
  27. <form method="POST">
  28. <label>姓名: <input type="text" name="debtorName" required></label><br>
  29. <label>还款日期: <input type="date" name="repaymentDate" required></label><br>
  30. <label>还款方式: <input type="text" name="repaymentMethod" value="微信"></label><br>
  31. <label>还款金额: <input type="number" step="0.01" name="repaymentAmount" required></label><br>
  32. <label>备注: <input type="text" name="comments"></label><br>
  33. <button type="submit">完成</button>
  34. </form>
  35. </body>
  36. </html>