How to use PHP to write customer management function code in an inventory management system

How to use PHP to write customer management function code in the inventory management system

With the continuous expansion of the scale of the enterprise and the increasing market demand, the inventory management of the enterprise has become more and more important. Customer management is an important function in the inventory management system, which can help companies better manage customers and track customer needs and orders in real time. This article will introduce how to use PHP to write customer management function code in the inventory management system.

First, we need to create a customer table in the database to store customer related information, such as customer name, contact information, address, etc. You can use the following SQL statement to create a table named customers:

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

Next, we can create a class named Customer to encapsulate customer management related functions. First, we need to write a method to add customer information:

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();
  }
}

In the above code, we first pass the database connection into the Customer class in the constructor. The addCustomer method receives the customer's name, contact information, and address as parameters, and then uses prepared statements to insert the customer information into the database.

In addition to adding customer information, we can also write other methods to implement customer management functions, such as deleting customers, updating customer information, and obtaining customer lists. The following is a sample code to delete a customer and obtain a customer list:

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;
  }
}

In the method of deleting a customer, we use a delete statement to delete the customer information of the specified id from the database. In the method of obtaining the customer list, we use the query statement to obtain all customer information from the database and store it in an array and return it.

Finally, we can use the following code to test the code of the customer management function:

// 创建数据库连接
$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();

With the above code, we can implement the customer management function code in the inventory management system. Of course, this is just a simple example, and the actual system may be more complex and require further development and optimization based on actual needs. I hope this article will be helpful to use PHP to write customer management function code in the inventory management system.

The above is the detailed content of How to use PHP to write customer management function code in an inventory management system. For more information, please follow other related articles on the PHP Chinese website!