PHP を使用して在庫管理システムの顧客管理機能コードを記述する方法

CREATE TABLE customers (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100) NOT NULL,
  contact VARCHAR(100) NOT NULL,
  address VARCHAR(200) NOT NULL
);

class Customer {
  private $conn;

  public function __construct($conn) {
    $this->conn = $conn;
  }

  public function addCustomer($name, $contact, $address) {
    $sql = "INSERT INTO customers (name, contact, address) VALUES (?, ?, ?)";
    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param("sss", $name, $contact, $address);
    $stmt->execute();
  }
}

class Customer {
  // 省略之前的代码...

  public function deleteCustomer($id) {
    $sql = "DELETE FROM customers WHERE id = ?";
    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param("i", $id);
    $stmt->execute();
  }

  public function getCustomerList() {
    $sql = "SELECT * FROM customers";
    $result = $this->conn->query($sql);
    $customers = [];
    while ($row = $result->fetch_assoc()) {
      $customers[] = $row;
    }
    return $customers;
  }
}

// 创建数据库连接
$conn = new mysqli("localhost", "username", "password", "database_name");

// 创建Customer实例
$customer = new Customer($conn);

// 添加客户
$customer->addCustomer("张三", "13888888888", "北京市东城区");

// 获取客户列表
$customers = $customer->getCustomerList();

// 输出客户列表
foreach ($customers as $c) {
  echo $c["name"] . " " . $c["contact"] . " " . $c["address"] . "
";
}

// 删除指定id的客户
$customer->deleteCustomer(1);

// 关闭数据库连接
$conn->close();