add_record.php 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  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. <link rel="stylesheet" type="text/css" href="css/styles.css">
  26. <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.4/css/all.min.css">
  27. </head>
  28. <body>
  29. <div class="container">
  30. <h1>新增还款记录</h1>
  31. <form method="POST">
  32. <label>
  33. <span>姓名:</span>
  34. <input type="text" name="debtorName" required placeholder="请输入姓名">
  35. </label>
  36. <label>
  37. <span>还款日期:</span>
  38. <input type="date" name="repaymentDate" required>
  39. </label>
  40. <label>
  41. <span>还款方式:</span>
  42. <input type="text" name="repaymentMethod" value="微信" placeholder="请输入还款方式">
  43. </label>
  44. <label>
  45. <span>还款金额:</span>
  46. <input type="number" step="0.01" name="repaymentAmount" required placeholder="请输入金额">
  47. </label>
  48. <label>
  49. <span>备注:</span>
  50. <input type="text" name="comments" placeholder="可选">
  51. </label>
  52. <div class="form-buttons">
  53. <button type="submit">完成</button>
  54. <a href="index.php" class="button">返回主页</a>
  55. </div>
  56. </form>
  57. </div>
  58. </body>
  59. </html>