基于PHP的餐厅管理系统APP设计与实现

<?php
// 连接数据库
$db = new PDO('mysql:host=localhost;dbname=restaurant_db;charset=utf8', 'username', 'password');

// 获取所有餐厅信息
function getAllRestaurants($db) {
    $stmt = $db->query('SELECT * FROM restaurants');
    $restaurants = $stmt->fetchAll(PDO::FETCH_ASSOC);
    return $restaurants;
}

// 创建新餐厅
function createRestaurant($db, $name, $location, $phone) {
    $stmt = $db->prepare("INSERT INTO restaurants (name, location, phone) VALUES (?, ?, ?)");
    $stmt->execute([$name, $location, $phone]);
}

// 更新餐厅信息
function updateRestaurant($db, $id, $name, $location, $phone) {
    $stmt = $db->prepare("UPDATE restaurants SET name = ?, location = ?, phone = ? WHERE id = ?");
    $stmt->execute([$name, $location, $phone, $id]);
}

// 删除餐厅
function deleteRestaurant($db, $id) {
    $stmt = $db->prepare("DELETE FROM restaurants WHERE id = ?");
    $stmt->execute([$id]);
}

// 示例用法
$restaurants = getAllRestaurants($db);
foreach ($restaurants as $restaurant) {
    echo $restaurant['name'] . ' - ' . $restaurant['location'] . '<br>';
}

// 创建新餐厅
createRestaurant($db, 'McDonalds', '123 Main St', '555-1234');

// 更新餐厅信息
updateRestaurant($db, 1, 'Wendy\'s', '456 Main St', '555-4321');

// 删除餐厅
deleteRestaurant($db, 1);