PHP网页操作MySQL数据库 - 轻松管理zhidemaikey表 - 常规

<!DOCTYPE html>
<html>
<head>
    <title>操作MySQL数据库 - zhidemaikey表</title>
    <style>
        body{
            background-color: #f2f2f2;
            font-family: Arial, sans-serif;
        }
        .container{
            max-width: 800px;
            margin: 0 auto;
            padding: 20px;
            background-color: #fff;
            box-shadow: 0 0 5px rgba(0, 0, 0, 0.1);
        }
        h1{
            text-align: center;
            color: #333;
        }
        table{
            width: 100%;
            border-collapse: collapse;
        }
        table td, table th{
            padding: 10px;
            border: 1px solid #ccc;
        }
        .add-form{
            display: flex;
            justify-content: space-between;
            margin-bottom: 20px;
        }
        .add-form input{
            flex-grow: 1;
            padding: 5px;
            margin-right: 10px;
        }
        .add-form button{
            padding: 5px 10px;
            background-color: #4CAF50;
            color: #fff;
            border: none;
            cursor: pointer;
        }
        .delete-btn{
            padding: 5px 10px;
            background-color: #f44336;
            color: #fff;
            border: none;
            cursor: pointer;
        }
    </style>
</head>
<body>
    <div class='container'>
        <h1>操作MySQL数据库 - zhidemaikey表</h1>
<pre><code>    &lt;div class='add-form'&gt;
        &lt;input type='text' id='newItem' placeholder='输入要添加的内容'&gt;
        &lt;button onclick='addItem()'&gt;添加&lt;/button&gt;
    &lt;/div&gt;

    &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(&quot;连接数据库失败: &quot; . $conn-&gt;connect_error);
    }

    // 查询操作
    $sql = &quot;SELECT * FROM zhidemaikey&quot;;
    $result = $conn-&gt;query($sql);

    if ($result-&gt;num_rows &gt; 0) {
        echo &quot;&lt;table&gt;&quot;;
        echo &quot;&lt;tr&gt;&lt;th&gt;内容&lt;/th&gt;&lt;th&gt;操作&lt;/th&gt;&lt;/tr&gt;&quot;;

        while ($row = $result-&gt;fetch_assoc()) {
            $zdmkey = $row[&quot;zdmkey&quot;];
            $id = $row[&quot;id&quot;];

            echo &quot;&lt;tr&gt;&lt;td&gt;&quot; . $zdmkey . &quot;&lt;/td&gt;&lt;td&gt;&lt;button class='delete-btn' onclick='deleteItem(&quot;' . $zdmkey . '&quot;)'&gt;删除&lt;/button&gt;&lt;/td&gt;&lt;/tr&gt;&quot;;
        }

        echo &quot;&lt;/table&gt;&quot;;
    } else {
        echo &quot;暂无数据&quot;;
    }

    // 关闭数据库连接
    $conn-&gt;close();
    ?&gt;

    &lt;script&gt;
        // 删除操作
        function deleteItem(zdmkey){
            if (confirm(&quot;确定要删除吗？&quot;)) {
                window.location.href = &quot;delete.php?zdmkey=&quot; + zdmkey;
            }
        }

        // 添加操作
        function addItem(){
            var newItem = document.getElementById(&quot;newItem&quot;).value;
            if (newItem !== &quot;&quot;) {
                window.location.href = &quot;add.php?zdmkey=&quot; + newItem;
            }
        }
    &lt;/script&gt;
&lt;/div&gt;
</code></pre>
</body>
</html>