PHP网页操作MySQL数据库，实现增删查功能并美化页面

<!DOCTYPE html>
<html>
<head>
    <meta charset='utf-8'>
    <title>操作MySQL数据库</title>
    <style>
        body {
            margin: 0;
            padding: 20px;
            font-family: Arial, sans-serif;
            background-color: #f2f2f2;
        }
        h1 {
            color: #333333;
        }
        table {
            width: 100%;
            border-collapse: collapse;
        }
        table th, table td {
            padding: 10px;
            border: 1px solid #cccccc;
        }
        table th {
            background-color: #dddddd;
        }
        .add-form {
            margin-bottom: 10px;
        }
        .add-form input[type='text'] {
            padding: 5px;
            width: 200px;
        }
        .add-form input[type='submit'] {
            padding: 5px 10px;
            background-color: #4caf50;
            color: white;
            border: none;
            cursor: pointer;
        }
        .delete-btn {
            padding: 5px 10px;
            background-color: #f44336;
            color: white;
            border: none;
            cursor: pointer;
            text-decoration: none;
        }
        @media (max-width: 768px) {
            table {
                font-size: 14px;
            }
        }
    </style>
</head>
<body>
    <h1>操作MySQL数据库</h1>
<pre><code>&lt;?php
// 数据库配置
$host = '43.143.25.74';
$port = 3306;
$user = 'tuisong';
$passwd = 'xX300400';
$db = 'tuisong';
$charset = 'utf8';

// 创建数据库连接
$conn = new mysqli($host, $user, $passwd, $db, $port);
if ($conn-&gt;connect_error) {
    die('数据库连接失败: ' . $conn-&gt;connect_error);
}

// 处理删除请求
if (isset($_POST['delete'])) {
    $id = $_POST['delete'];
    $sql = &quot;DELETE FROM zhidemaikey WHERE id = $id&quot;;
    if ($conn-&gt;query($sql) === TRUE) {
        header(&quot;Location: {$_SERVER['PHP_SELF']}&quot;);
        exit;
    } else {
        echo &quot;删除失败: &quot; . $conn-&gt;error;
    }
}

// 处理添加请求
if (isset($_POST['add'])) {
    $zdmkey = $_POST['zdmkey'];
    $sql = &quot;INSERT INTO zhidemaikey (zdmkey) VALUES ('$zdmkey')&quot;;
    if ($conn-&gt;query($sql) === TRUE) {
        header(&quot;Location: {$_SERVER['PHP_SELF']}&quot;);
        exit;
    } else {
        echo &quot;添加失败: &quot; . $conn-&gt;error;
    }
}

// 查询所有内容
$sql = &quot;SELECT * FROM zhidemaikey&quot;;
$result = $conn-&gt;query($sql);
?&gt;

&lt;form class='add-form' method='post'&gt;
    &lt;input type='text' name='zdmkey' placeholder='请输入内容' required&gt;
    &lt;input type='submit' name='add' value='添加'&gt;
&lt;/form&gt;

&lt;table&gt;
    &lt;tr&gt;
        &lt;th&gt;ID&lt;/th&gt;
        &lt;th&gt;内容&lt;/th&gt;
        &lt;th&gt;操作&lt;/th&gt;
    &lt;/tr&gt;
    &lt;?php
    if ($result-&gt;num_rows &gt; 0) {
        while ($row = $result-&gt;fetch_assoc()) {
            echo &quot;&lt;tr&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row[&quot;id&quot;] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row[&quot;zdmkey&quot;] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&lt;a class='delete-btn' href='{$_SERVER['PHP_SELF']}?delete=&quot; . $row[&quot;id&quot;] . &quot;'&gt;删除&lt;/a&gt;&lt;/td&gt;&quot;;
            echo &quot;&lt;/tr&gt;&quot;;
        }
    } else {
        echo &quot;&lt;tr&gt;&lt;td colspan='3'&gt;暂无数据&lt;/td&gt;&lt;/tr&gt;&quot;;
    }
    ?&gt;
&lt;/table&gt;

&lt;?php
// 关闭数据库连接
$conn-&gt;close();
?&gt;
</code></pre>
</body>
</html>