PHP를 사용하여 재무 관리 기능을 구현하는 전사적 자원 관리(ERP) 시스템 개발

CREATE TABLE finance (
  id INT(11) NOT NULL AUTO_INCREMENT,
  date DATE,
  description VARCHAR(255),
  amount FLOAT,
  PRIMARY KEY (id)
);

<?php
  // 连接数据库
  $conn = mysqli_connect('localhost', 'root', 'password', 'erp_database');
  if (!$conn) {
    die('连接数据库失败：' . mysqli_connect_error());
  }
  
  // 处理表单提交
  if (isset($_POST['submit'])) {
    $date = $_POST['date'];
    $description = $_POST['description'];
    $amount = $_POST['amount'];
    
    // 插入数据到数据库
    $query = "INSERT INTO finance (date, description, amount) VALUES ('$date', '$description', '$amount')";
    $result = mysqli_query($conn, $query);
    
    if ($result) {
      echo "财务数据插入成功！";
    } else {
      echo "财务数据插入失败：" . mysqli_error($conn);
    }
  }
?>

<form method="POST" action="">
  <label for="date">日期：</label>
  <input type="date" name="date" required><br>
  
  <label for="description">描述：</label>
  <input type="text" name="description" required><br>
  
  <label for="amount">金额：</label>
  <input type="number" name="amount" step="0.01" required><br>
  
  <input type="submit" name="submit" value="提交">
</form>

<?php
  // 连接数据库
  $conn = mysqli_connect('localhost', 'root', 'password', 'erp_database');
  if (!$conn) {
    die('连接数据库失败：' . mysqli_connect_error());
  }
  
  // 查询财务数据
  $query = "SELECT * FROM finance";
  $result = mysqli_query($conn, $query);
  
  if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
      echo "日期：" . $row['date'] . "<br>";
      echo "描述：" . $row['description'] . "<br>";
      echo "金额：$" . $row['amount'] . "<br><br>";
    }
  } else {
    echo "暂无财务数据！";
  }
?>