简化PHP代码并添加SQL增删改查操作

请修改以下php代码，已知SQL中ID是自增的，PIC是int型整数，简化代码，使用中文写代码备注，并添加对sql的增删改查操作<?php // 引入数据库连接文件 include 'db.php';

// 处理搜索请求 if ($_SERVER["REQUEST_METHOD"] == "POST") { $search = $_POST['search']; $sql = "SELECT id, time, IP, info, WXDJ, GSD, PIC, AQSB, up_time, beizhu FROM black_list WHERE id LIKE '%$search%' OR time LIKE '%$search%' OR IP LIKE '%$search%' OR info LIKE '%$search%' OR WXDJ LIKE '%$search%' OR GSD LIKE '%$search%' OR PIC LIKE '%$search%' OR AQSB LIKE '%$search%' OR up_time LIKE '%$search%' OR beizhu LIKE '%$search%'"; $result = $conn->query($sql);

// 检查查询结果
if ($result->num_rows > 0) {
    // 输出表格头部
    echo '<table class="table table-bordered">';
    echo '<thead>';
    echo '<tr>';
    echo '<th>序号</th>';
    echo '<th>设备发现时间</th>';
    echo '<th>风险IP</th>';
    echo '<th>封禁原因</th>';
    echo '<th

<?php
// 引入数据库连接文件
include 'db.php';

// 处理搜索请求
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $search = $_POST['search'];
    $sql = "SELECT id, time, IP, info, WXDJ, GSD, PIC, AQSB, up_time, beizhu FROM black_list WHERE 
            id LIKE '%$search%' OR 
            time LIKE '%$search%' OR 
            IP LIKE '%$search%' OR 
            info LIKE '%$search%' OR 
            WXDJ LIKE '%$search%' OR 
            GSD LIKE '%$search%' OR 
            PIC LIKE '%$search%' OR 
            AQSB LIKE '%$search%' OR 
            up_time LIKE '%$search%' OR 
            beizhu LIKE '%$search%'";
    $result = $conn->query($sql);

    // 检查查询结果
    if ($result->num_rows > 0) {
        // 输出表格头部
        echo '<table class="table table-bordered">';
        echo '<thead>';
        echo '<tr>';
        echo '<th>序号</th>';
        echo '<th>设备发现时间</th>';
        echo '<th>风险IP</th>';
        echo '<th>封禁原因</th>';
        echo '<th>危险等级</th>';
        echo '<th>公司</th>';
        echo '<th>图片</th>';
        echo '<th>安全设备</th>';
        echo '<th>更新时间</th>';
        echo '<th>备注</th>';
        echo '</tr>';
        echo '</thead>';
        echo '<tbody>';

        // 输出查询结果
        while ($row = $result->fetch_assoc()) {
            echo '<tr>';
            echo '<td>' . $row['id'] . '</td>';
            echo '<td>' . $row['time'] . '</td>';
            echo '<td>' . $row['IP'] . '</td>';
            echo '<td>' . $row['info'] . '</td>';
            echo '<td>' . $row['WXDJ'] . '</td>';
            echo '<td>' . $row['GSD'] . '</td>';
            echo '<td>' . $row['PIC'] . '</td>';
            echo '<td>' . $row['AQSB'] . '</td>';
            echo '<td>' . $row['up_time'] . '</td>';
            echo '<td>' . $row['beizhu'] . '</td>';
            echo '</tr>';
        }
        echo '</tbody>';
        echo '</table>';
    } else {
        echo '没有找到相关记录';
    }
}

// 增加记录
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['add'])) {
    $time = $_POST['time'];
    $IP = $_POST['IP'];
    $info = $_POST['info'];
    $WXDJ = $_POST['WXDJ'];
    $GSD = $_POST['GSD'];
    $PIC = $_POST['PIC'];
    $AQSB = $_POST['AQSB'];
    $up_time = $_POST['up_time'];
    $beizhu = $_POST['beizhu'];

    $sql = "INSERT INTO black_list (time, IP, info, WXDJ, GSD, PIC, AQSB, up_time, beizhu) VALUES 
            ('$time', '$IP', '$info', '$WXDJ', '$GSD', $PIC, '$AQSB', '$up_time', '$beizhu')";
    if ($conn->query($sql) === TRUE) {
        echo "记录添加成功";
    } else {
        echo "添加记录时出错: " . $conn->error;
    }
}

// 删除记录
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['delete'])) {
    $id = $_POST['id'];
    $sql = "DELETE FROM black_list WHERE id=$id";
    if ($conn->query($sql) === TRUE) {
        echo "记录删除成功";
    } else {
        echo "删除记录时出错: " . $conn->error;
    }
}

// 更新记录
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['update'])) {
    $id = $_POST['id'];
    $time = $_POST['time'];
    $IP = $_POST['IP'];
    $info = $_POST['info'];
    $WXDJ = $_POST['WXDJ'];
    $GSD = $_POST['GSD'];
    $PIC = $_POST['PIC'];
    $AQSB = $_POST['AQSB'];
    $up_time = $_POST['up_time'];
    $beizhu = $_POST['beizhu'];

    $sql = "UPDATE black_list SET time='$time', IP='$IP', info='$info', WXDJ='$WXDJ', GSD='$GSD', PIC=$PIC, AQSB='$AQSB', up_time='$up_time', beizhu='$beizhu' WHERE id=$id";
    if ($conn->query($sql) === TRUE) {
        echo "记录更新成功";
    } else {
        echo "更新记录时出错: " . $conn->error;
    }
}

// 查询所有记录
$sql = "SELECT id, time, IP, info, WXDJ, GSD, PIC, AQSB, up_time, beizhu FROM black_list";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    echo '<table class="table table-bordered">';
    echo '<thead>';
    echo '<tr>';
    echo '<th>序号</th>';
    echo '<th>设备发现时间</th>';
    echo '<th>风险IP</th>';
    echo '<th>封禁原因</th>';
    echo '<th>危险等级</th>';
    echo '<th>公司</th>';
    echo '<th>图片</th>';
    echo '<th>安全设备</th>';
    echo '<th>更新时间</th>';
    echo '<th>备注</th>';
    echo '</tr>';
    echo '</thead>';
    echo '<tbody>';

    while ($row = $result->fetch_assoc()) {
        echo '<tr>';
        echo '<td>' . $row['id'] . '</td>';
        echo '<td>' . $row['time'] . '</td>';
        echo '<td>' . $row['IP'] . '</td>';
        echo '<td>' . $row['info'] . '</td>';
        echo '<td>' . $row['WXDJ'] . '</td>';
        echo '<td>' . $row['GSD'] . '</td>';
        echo '<td>' . $row['PIC'] . '</td>';
        echo '<td>' . $row['AQSB'] . '</td>';
        echo '<td>' . $row['up_time'] . '</td>';
        echo '<td>' . $row['beizhu'] . '</td>';
        echo '</tr>';
    }
    echo '</tbody>';
    echo '</table>';
} else {
    echo '没有找到相关记录';
}

$conn->close();
?>