餐饮管理系统需要的菜品表、订单表、顾客表写出代码
时间: 2023-03-24 14:01:41 浏览: 85
对于餐饮管理系统,需要以下表格和代
码:
1. 菜品表(Dishes Table):该表用于存储所有菜品的信息,包括菜品名称、菜品编号、菜品价格、菜品描述、制作方法等等。
CREATE TABLE dishes (
dish_id INT PRIMARY KEY,
dish_name VARCHAR(50),
dish_price DECIMAL(5,2),
dish_description TEXT,
dish_recipe TEXT
);
2. 订单表(Order Table):该表用于存储客户下单的信息,包括订单编号、客户编号、下单时间、订单状态、订单金额等等。
CREATE TABLE orders (
order_id INT PRIMARY KEY,
customer_id INT,
order_time DATETIME,
order_status VARCHAR(20),
order_amount DECIMAL(5,2)
);
3. 客户表(Customer Table):该表用于存储客户的信息,包括客户姓名、客户电话、客户地址等等。
CREATE TABLE customers (
customer_id INT PRIMARY KEY,
customer_name VARCHAR(50),
customer_phone VARCHAR(20),
customer_address TEXT
);
4. 顾客反馈表(Customer Feedback Table):该表用于存储顾客的反馈信息,包括顾客编号、反馈内容、反馈时间等等。
CREATE TABLE customer_feedback (
feedback_id INT PRIMARY KEY,
customer_id INT,
feedback_content TEXT,
feedback_time DATETIME
);
5. 代 码(Code):以下是一个简单的PHP代码示例,用于从菜品表中获取所有菜品的信息:
<?php
$conn = mysqli_connect("localhost", "username", "password", "database_name");
$sql = "SELECT * FROM dishes";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
echo "Dish Name: " . $row["dish_name"] . "<br>";
echo "Dish Price: " . $row["dish_price"] . "<br>";
echo "Dish Description: " . $row["dish_description"] . "<br>";
echo "Dish Recipe: " . $row["dish_recipe"] . "<br><br>";
}
mysqli_close($conn);
?>