MySQL 实现点餐系统的员工管理功能

CREATE DATABASE employee_management_system;

CREATE TABLE `employee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `passWord` varchar(100) NOT NULL,
  `position` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO employee (name, password, position) VALUES
('alice', '123456', 'manager'),
('bob', '123456', 'waiter'),
('cathy', '123456', 'chef');

<?PHP
  $username = $_POST['username'];
  $password = $_POST['password'];

  $result = mysqli_query($con,"SELECT * FROM employee WHERE name='$username' and password='$password'");
  $count = mysqli_num_rows($result);

  if($count == 1) {
    // 登录成功，执行相关操作
  } else {
    // 登录失败，返回错误信息
  }
?>

<?php
  $id = $_POST['id'];
  $name = $_POST['name'];
  $password = $_POST['password'];
  $position = $_POST['position'];

  $sql = "UPDATE employee SET name='$name', password='$password', position='$position' WHERE id='$id'";

  if(mysqli_query($con, $sql)) {
    // 更新成功，执行相关操作
  } else {
    // 更新失败，返回错误信息
  }
?>

<?php
  $result = mysqli_query($con,"SELECT * FROM employee");
  while($row = mysqli_fetch_array($result)) {
    echo "<tr>";
    echo "<td>" . $row['id'] . "</td>";
    echo "<td>" . $row['name'] . "</td>";
    echo "<td>" . $row['position'] . "</td>";
    echo "</tr>";
  }
?>

<?php
  $id = $_GET['id'];

  $sql = "DELETE FROM employee WHERE id='$id'";

  if(mysqli_query($con, $sql)) {
    // 删除成功，执行相关操作
  } else {
    // 删除失败，返回错误信息
  }
?>