当前位置：首页 > PHP

php实现报修

2026-03-12 20:30:16PHP

PHP 报修系统实现

核心功能模块

用户提交报修单
管理员处理报修请求
状态跟踪与通知

数据库设计 创建报修表结构示例：

CREATE TABLE repair_orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    title VARCHAR(100) NOT NULL,
    description TEXT NOT NULL,
    location VARCHAR(100) NOT NULL,
    status ENUM('pending', 'processing', 'completed') DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

用户提交表单 构建HTML报修表单：

<form action="submit_repair.php" method="post">
    <input type="text" name="title" placeholder="故障标题" required>
    <textarea name="description" placeholder="详细描述" required></textarea>
    <input type="text" name="location" placeholder="故障位置" required>
    <button type="submit">提交报修</button>
</form>

处理提交逻辑 submit_repair.php 示例代码：

<?php
session_start();
require 'db_connection.php';

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $title = $_POST['title'];
    $description = $_POST['description'];
    $location = $_POST['location'];
    $userId = $_SESSION['user_id'];

    $stmt = $conn->prepare("INSERT INTO repair_orders (user_id, title, description, location) VALUES (?, ?, ?, ?)");
    $stmt->bind_param("isss", $userId, $title, $description, $location);

    if ($stmt->execute()) {
        header("Location: repair_list.php?success=1");
    } else {
        header("Location: submit_repair.php?error=1");
    }
}
?>

状态管理界面 管理员处理页面示例：

<?php
// 获取待处理报修单
$stmt = $conn->prepare("SELECT * FROM repair_orders WHERE status = 'pending'");
$stmt->execute();
$result = $stmt->get_result();
?>

<table>
    <tr>
        <th>报修单ID</th>
        <th>标题</th>
        <th>操作</th>
    </tr>
    <?php while ($row = $result->fetch_assoc()): ?>
    <tr>
        <td><?= $row['id'] ?></td>
        <td><?= $row['title'] ?></td>
        <td>
            <a href="process_repair.php?id=<?= $row['id'] ?>&action=accept">受理</a>
        </td>
    </tr>
    <?php endwhile; ?>
</table>

状态更新处理 process_repair.php 示例：

<?php
require 'db_connection.php';

$repairId = $_GET['id'];
$action = $_GET['action'];

if ($action === 'accept') {
    $status = 'processing';
} elseif ($action === 'complete') {
    $status = 'completed';
}

$stmt = $conn->prepare("UPDATE repair_orders SET status = ? WHERE id = ?");
$stmt->bind_param("si", $status, $repairId);
$stmt->execute();

header("Location: admin_dashboard.php");
?>

通知功能实现 使用邮件通知示例：

function sendNotification($userId, $repairId) {
    // 获取用户邮箱
    $stmt = $conn->prepare("SELECT email FROM users WHERE id = ?");
    $stmt->bind_param("i", $userId);
    $stmt->execute();
    $user = $stmt->get_result()->fetch_assoc();

    $to = $user['email'];
    $subject = "报修状态更新";
    $message = "您的报修单 #$repairId 状态已更新";
    $headers = "From: noreply@repair-system.com";

    mail($to, $subject, $message, $headers);
}

安全增强措施