add_record.php 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  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. // 清除该用户的缓存
  18. $redis->del("debt_info:" . $debtorName);
  19. header('Location: index.php');
  20. exit;
  21. }
  22. ?>
  23. <!DOCTYPE html>
  24. <html>
  25. <head>
  26. <title>新增还款记录</title>
  27. <link rel="stylesheet" type="text/css" href="css/styles.css">
  28. <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
  29. </head>
  30. <body>
  31. <div class="container">
  32. <h1>新增还款记录</h1>
  33. <form method="POST">
  34. <label>
  35. <span>姓名:</span>
  36. <input type="text" name="debtorName" required placeholder="请输入姓名">
  37. </label>
  38. <label>
  39. <span>还款日期:</span>
  40. <input type="date" name="repaymentDate" required>
  41. </label>
  42. <label>
  43. <span>还款方式:</span>
  44. <input type="text" name="repaymentMethod" value="微信" placeholder="请输入还款方式">
  45. </label>
  46. <label>
  47. <span>还款金额:</span>
  48. <input type="number" step="0.01" name="repaymentAmount" required placeholder="请输入金额">
  49. </label>
  50. <label>
  51. <span>备注:</span>
  52. <input type="text" name="comments" placeholder="可选">
  53. </label>
  54. <div class="form-buttons">
  55. <button type="submit">完成</button>
  56. <a href="index.php" class="button">返回主页</a>
  57. </div>
  58. </form>
  59. </div>
  60. </body>
  61. </html>