PHP E-commerce System Development Guide Customer Management

The customer management process in the e-commerce system involves database design, model class creation, controller processing, view generation and actual case execution. First, establish a database and design data tables; second, create model classes to interact with the database; then, the controller is responsible for business logic and data acquisition; the view is responsible for generating the user interface; finally, create, edit, delete customers and other operations are demonstrated through practical cases.

PHP E-commerce System Development Guide: Customer Management

Introduction
Customer management is any An important part of the e-commerce system. It enables businesses to track customer information, manage orders and provide support. In this blog post, we’ll walk you through the process of building a customer management system using PHP.

Database Design
First, let us create a database with the following columns:

CREATE TABLE customers (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  email VARCHAR(255) UNIQUE NOT NULL,
  password VARCHAR(255) NOT NULL
);

Model Class
In order to interact with the database To interact, let's create a model class:

class Customer {
  public $id;
  public $name;
  public $email;
  public $password;

  public static function find($id) {
    // 查询并返回具有指定 ID 的客户
  }

  public static function all() {
    // 查询并返回所有客户
  }

  public function save() {
    // 保存当前客户到数据库
  }

  public function delete() {
    // 从数据库中删除当前客户
  }
}

Controller
The controller is where the business logic resides in the customer management system. They handle user requests and get data from models. Let's create a client controller:

class CustomerController {
  public function index() {
    // 显示所有客户的列表
    $customers = Customer::all();
    include 'views/customers/index.php';
  }

  public function create() {
    // 显示创建新客户的表单
    include 'views/customers/create.php';
  }

  public function store() {
    // 创建并保存一个新客户
    $customer = new Customer;
    $customer->name = $_POST['name'];
    $customer->email = $_POST['email'];
    $customer->password = $_POST['password'];
    $customer->save();
    header('Location: /customers');
  }

  public function edit($id) {
    // 显示具有指定 ID 的客户的编辑表单
    $customer = Customer::find($id);
    include 'views/customers/edit.php';
  }

  public function update($id) {
    // 更新具有指定 ID 的客户
    $customer = Customer::find($id);
    $customer->name = $_POST['name'];
    $customer->email = $_POST['email'];
    $customer->password = $_POST['password'];
    $customer->save();
    header('Location: /customers');
  }

  public function destroy($id) {
    // 删除具有指定 ID 的客户
    $customer = Customer::find($id);
    $customer->delete();
    header('Location: /customers');
  }
}

View
The view is responsible for generating the user interface. Let’s create a view that displays a list of all customers:

<h3>所有客户</h3>
<ul>
<?php foreach ($customers as $customer): ?>
  <li>
    <?php echo $customer->name; ?> (
    <a href="/customers/<?php echo $customer->id; ?>/edit">编辑</a> |
    <a href="/customers/<?php echo $customer->id; ?>/destroy">删除</a>
    )
  </li>
<?php endforeach; ?>
</ul>

Practical Case
To demonstrate the customer management system, please follow the steps below:

1. Create a database named customers.
2. Include the Customer model, CustomerController controller, and customers view in your PHP application.
3. Create the public/index.php file and add the following content to it:

require 'vendor/autoload.php';

// 定义根 URL
define('URL', 'http://localhost/php-ecommerce-system/');

// 初始化路由
$router = new AltoRouter();
$router->setBasePath(URL);

// 定义路由
$router->map('GET', '/', 'CustomerController@index');
$router->map('GET', '/customers/create', 'CustomerController@create');
$router->map('POST', '/customers', 'CustomerController@store');
$router->map('GET', '/customers/[:id]/edit', 'CustomerController@edit');
$router->map('PUT', '/customers/[:id]', 'CustomerController@update');
$router->map('DELETE', '/customers/[:id]', 'CustomerController@destroy');

// 获取当前请求
$match = $router->match();

// 执行匹配的路由
if ($match) {
  [$controller, $method] = $match['target'];
  $controller = new $controller;
  $controller->$method($match['params']);
} else {
  die('404 Not Found');
}

4. Run your application and visit the following URL:

• http://localhost/php-ecommerce-system/：View all customers
• http://localhost/php -ecommerce-system/customers/create: Create a new customer
• http://localhost/php-ecommerce-system/customers/:id/edit: Edit an existing customer
• http://localhost/php-ecommerce-system/customers/:id: Delete existing customer

The above is the detailed content of PHP E-commerce System Development Guide Customer Management. For more information, please follow other related articles on the PHP Chinese website!