{"id":24361,"date":"2024-11-21T09:43:52","date_gmt":"2024-11-21T01:43:52","guid":{"rendered":"https:\/\/fwq.ai\/blog\/24361\/"},"modified":"2024-11-21T09:43:52","modified_gmt":"2024-11-21T01:43:52","slug":"%e8%bf%90%e7%94%a8webman%e6%8a%80%e6%9c%af%e6%9e%84%e5%bb%ba%e4%b8%93%e4%b8%9a%e7%9a%84%e9%9f%b3%e4%b9%90%e6%92%ad%e6%94%be%e5%b9%b3%e5%8f%b0","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/24361\/","title":{"rendered":"\u8fd0\u7528WebMan\u6280\u672f\u6784\u5efa\u4e13\u4e1a\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0"},"content":{"rendered":"

\"\u8fd0\u7528WebMan\u6280\u672f\u6784\u5efa\u4e13\u4e1a\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u63d2\u56fe\"<\/p>\n

\u6807\u9898\uff1a\u8fd0\u7528WebMan\u6280\u672f\u6784\u5efa\u4e13\u4e1a\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0<\/p>\n

\u524d\u8a00\uff1a
\u968f\u7740\u4e92\u8054\u7f51\u7684\u5feb\u901f\u53d1\u5c55\uff0c\u97f3\u4e50\u6210\u4e3a\u4eba\u4eec\u751f\u6d3b\u4e2d\u4e0d\u53ef\u6216\u7f3a\u7684\u4e00\u90e8\u5206\u3002\u56e0\u6b64\uff0c\u6784\u5efa\u4e00\u4e2a\u4e13\u4e1a\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u53d8\u5f97\u5c24\u4e3a\u91cd\u8981\u3002\u5728\u672c\u6587\u4e2d\uff0c\u6211\u4eec\u5c06\u4ecb\u7ecd\u5982\u4f55\u8fd0\u7528WebMan\u6280\u672f\u6765\u6784\u5efa\u4e00\u4e2a\u529f\u80fd\u5f3a\u5927\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\uff0c\u5e76\u9644\u4e0a\u76f8\u5e94\u7684\u4ee3\u7801\u793a\u4f8b\u3002<\/p>\n

\u4e00\u3001\u6280\u672f\u9009\u62e9\u4e0e\u51c6\u5907
\u5728\u6784\u5efa\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u4e4b\u524d\uff0c\u6211\u4eec\u9700\u8981\u9009\u62e9\u5408\u9002\u7684\u6280\u672f\u3002\u5728\u6b64\uff0c\u6211\u4eec\u9009\u62e9\u4f7f\u7528WebMan\u6280\u672f\uff0c\u56e0\u4e3a\u5b83\u662f\u4e00\u79cd\u975e\u5e38\u5f3a\u5927\u4e14\u7075\u6d3b\u7684\u6280\u672f\uff0c\u53ef\u4ee5\u5e2e\u52a9\u6211\u4eec\u5feb\u901f\u642d\u5efa\u4e00\u4e2a\u4e13\u4e1a\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u3002<\/p>\n

\u5728\u5f00\u59cb\u4e4b\u524d\uff0c\u6211\u4eec\u9700\u8981\u51c6\u5907\u4ee5\u4e0b\u5de5\u5177\u548c\u73af\u5883\uff1a<\/p>\n

    \n
  1. Web\u670d\u52a1\u5668\uff08\u5982Apache\u3001Nginx\u7b49\uff09<\/li>\n
  2. PHP\u7f16\u7a0b\u8bed\u8a00<\/li>\n
  3. MySQL\u6570\u636e\u5e93<\/li>\n
  4. HTML\u3001CSS\u548cJavaScript\u6280\u672f<\/li>\n<\/ol>\n

    \u4e8c\u3001\u6570\u636e\u5e93\u8bbe\u8ba1
    \u5728\u6784\u5efa\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u65f6\uff0c\u6838\u5fc3\u7684\u6570\u636e\u5b58\u50a8\u548c\u7ba1\u7406\u5de5\u4f5c\u7531\u6570\u636e\u5e93\u6765\u5b8c\u6210\u3002\u4e0b\u9762\u662f\u4e00\u4e2a\u7b80\u5355\u7684\u6570\u636e\u5e93\u8bbe\u8ba1\u793a\u4f8b\uff1a<\/p>\n

      \n
    1. \n

      \u8868\uff1a\u7528\u6237\u8868\uff08users\uff09
      \u5b57\u6bb5\uff1a<\/p>\n

        \n
      • id\uff08\u7528\u6237ID\uff09<\/li>\n
      • username\uff08\u7528\u6237\u540d\uff09<\/li>\n
      • password\uff08\u5bc6\u7801\uff09<\/li>\n
      • email\uff08\u7535\u5b50\u90ae\u7bb1\uff09<\/li>\n<\/ul>\n<\/li>\n
      • \n

        \u8868\uff1a\u6b4c\u66f2\u8868\uff08songs\uff09
        \u5b57\u6bb5\uff1a<\/p>\n

          \n
        • id\uff08\u6b4c\u66f2ID\uff09<\/li>\n
        • title\uff08\u6b4c\u66f2\u6807\u9898\uff09<\/li>\n
        • artist\uff08\u6b4c\u66f2\u827a\u672f\u5bb6\uff09<\/li>\n
        • album\uff08\u6b4c\u66f2\u6240\u5c5e\u4e13\u8f91\uff09<\/li>\n
        • file_path\uff08\u6b4c\u66f2\u6587\u4ef6\u8def\u5f84\uff09<\/li>\n<\/ul>\n<\/li>\n
        • \n

          \u8868\uff1a\u64ad\u653e\u5217\u8868\uff08playlists\uff09
          \u5b57\u6bb5\uff1a<\/p>\n

            \n
          • id\uff08\u64ad\u653e\u5217\u8868ID\uff09<\/li>\n
          • user_id\uff08\u7528\u6237ID\uff09<\/li>\n
          • name\uff08\u64ad\u653e\u5217\u8868\u540d\u79f0\uff09<\/li>\n<\/ul>\n<\/li>\n
          • \n

            \u8868\uff1a\u64ad\u653e\u5217\u8868\u6b4c\u66f2\uff08playlist_songs\uff09
            \u5b57\u6bb5\uff1a<\/p>\n

              \n
            • id\uff08\u64ad\u653e\u5217\u8868\u6b4c\u66f2ID\uff09<\/li>\n
            • playlist_id\uff08\u64ad\u653e\u5217\u8868ID\uff09<\/li>\n
            • song_id\uff08\u6b4c\u66f2ID\uff09<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n

              \u4e09\u3001\u642d\u5efa\u7528\u6237\u754c\u9762
              \u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u642d\u5efa\u4e00\u4e2a\u7528\u6237\u53cb\u597d\u7684\u524d\u7aef\u754c\u9762\u3002\u5728\u8fd9\u4e2a\u793a\u4f8b\u4e2d\uff0c\u6211\u4eec\u5c06\u4f7f\u7528HTML\u3001CSS\u548cJavaScript\u6765\u5b9e\u73b0\u3002<\/p>\n

              HTML\u4ee3\u7801\u793a\u4f8b\uff1a<\/p>\n

              \n\n\n    <meta charset=\"UTF-8\"><title>\u97f3\u4e50\u64ad\u653e\u5e73\u53f0<\/title><link rel=\"stylesheet\" href=\"style.css\"><h1>\u97f3\u4e50\u64ad\u653e\u5e73\u53f0<\/h1>\n    <div id=\"playlist\">\n        <h2>\u6211\u7684\u64ad\u653e\u5217\u8868<\/h2>\n        <ul id=\"playlist-items\"><!-- \u6b64\u5904\u586b\u5145\u64ad\u653e\u5217\u8868 --><\/ul>\n<\/div>\n    <div id=\"songs\">\n        <h2>\u6b4c\u66f2\u5217\u8868<\/h2>\n        <ul id=\"song-items\"><!-- \u6b64\u5904\u586b\u5145\u6b4c\u66f2\u5217\u8868 --><\/ul>\n<\/div>\n    <script src=\"script.js\"><\/script><\/pre>\n
                \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
              CSS\u4ee3\u7801\u793a\u4f8b\uff08style.css\uff09\uff1a<\/p>\n
              \/* \u6837\u5f0f\u8868\u793a\u4f8b *\/\n\nbody {\n    font-family: Arial, sans-serif;\n}\n\nh1, h2 {\n    color: #333;\n}\n\n#playlist, #songs {\n    margin-bottom: 20px;\n}\n\n#playlist-items li, #song-items li {\n    cursor: pointer;\n    margin-bottom: 10px;\n}<\/pre>\n
                \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
              JavaScript\u4ee3\u7801\u793a\u4f8b\uff08script.js\uff09\uff1a<\/p>\n
              \/\/ JavaScript\u4ee3\u7801\u793a\u4f8b\n\ndocument.addEventListener(\"DOMContentLoaded\", function() {\n    \/\/ \u83b7\u53d6\u5e76\u586b\u5145\u64ad\u653e\u5217\u8868\n    var playlistItems = document.getElementById(\"playlist-items\");\n    \/\/ TODO: \u901a\u8fc7Ajax\u8bf7\u6c42\u83b7\u53d6\u64ad\u653e\u5217\u8868\u6570\u636e\u5e76\u586b\u5145\n\n    \/\/ \u83b7\u53d6\u5e76\u586b\u5145\u6b4c\u66f2\u5217\u8868\n    var songItems = document.getElementById(\"song-items\");\n    \/\/ TODO: \u901a\u8fc7Ajax\u8bf7\u6c42\u83b7\u53d6\u6b4c\u66f2\u5217\u8868\u6570\u636e\u5e76\u586b\u5145\n\n    \/\/ \u6dfb\u52a0\u70b9\u51fb\u4e8b\u4ef6\u76d1\u542c\u5668\n    playlistItems.addEventListener(\"click\", function(e) {\n        \/\/ TODO: \u6839\u636e\u6240\u70b9\u51fb\u7684\u64ad\u653e\u5217\u8868\u9879\u6765\u5207\u6362\u6b4c\u66f2\u64ad\u653e\n    });\n\n    songItems.addEventListener(\"click\", function(e) {\n        \/\/ TODO: \u6839\u636e\u6240\u70b9\u51fb\u7684\u6b4c\u66f2\u9879\u6765\u6dfb\u52a0\u5230\u5f53\u524d\u64ad\u653e\u5217\u8868\n    });\n});<\/pre>\n
                \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
              \u56db\u3001\u6784\u5efa\u540e\u7aef\u903b\u8f91
              \u901a\u8fc7PHP\u7f16\u7a0b\u8bed\u8a00\u548cMySQL\u6570\u636e\u5e93\uff0c\u6211\u4eec\u53ef\u4ee5\u6784\u5efa\u51fa\u540e\u7aef\u7684\u903b\u8f91\u3002\u4ee5\u4e0b\u662f\u4e00\u4e2a\u7b80\u5355\u7684PHP\u4ee3\u7801\u793a\u4f8b\uff1a<\/p>\n
              <?php \/\/ \u6570\u636e\u5e93\u8fde\u63a5\u914d\u7f6e\n$host = \"localhost\";\n$username = \"root\";\n$password = \"password\";\n$dbname = \"music_platform\";\n\n$conn = new mysqli($host, $username, $password, $dbname);\n\nif ($conn->connect_error) {\n    die(\"\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25\uff1a\" . $conn-&gt;connect_error);\n}\n\n\/\/ \u83b7\u53d6\u64ad\u653e\u5217\u8868\u6570\u636e\n$playlists = [];\n$sql = \"SELECT id, name FROM playlists\";\n$result = $conn-&gt;query($sql);\n\nif ($result-&gt;num_rows &gt; 0) {\n    while($row = $result-&gt;fetch_assoc()) {\n        $playlists[] = $row;\n    }\n}\n\n\/\/ \u83b7\u53d6\u6b4c\u66f2\u5217\u8868\u6570\u636e\n$songs = [];\n$sql = \"SELECT id, title, artist, album, file_path FROM songs\";\n$result = $conn-&gt;query($sql);\n\nif ($result-&gt;num_rows &gt; 0) {\n    while($row = $result-&gt;fetch_assoc()) {\n        $songs[] = $row;\n    }\n}\n\n\/\/ \u8fd4\u56de\u6570\u636e\n$data = [\n    'playlists' =&gt; $playlists,\n    'songs' =&gt; $songs\n];\n\nheader('Content-Type: application\/json');\necho json_encode($data);\n?&gt;<\/pre>\n
                \u767b\u5f55\u540e\u590d\u5236   <\/p>\n
              \u4e94\u3001\u603b\u7ed3
              \u901a\u8fc7\u8fd0\u7528WebMan\u6280\u672f\uff0c\u6211\u4eec\u53ef\u4ee5\u8f7b\u677e\u5730\u6784\u5efa\u51fa\u4e00\u4e2a\u529f\u80fd\u5f3a\u5927\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u3002\u5728\u672c\u6587\u4e2d\uff0c\u6211\u4eec\u4ecb\u7ecd\u4e86\u6280\u672f\u9009\u62e9\u4e0e\u51c6\u5907\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\u3001\u7528\u6237\u754c\u9762\u642d\u5efa\u4ee5\u53ca\u540e\u7aef\u903b\u8f91\u6784\u5efa\u7684\u6b65\u9aa4\uff0c\u5e76\u63d0\u4f9b\u4e86\u76f8\u5173\u7684\u4ee3\u7801\u793a\u4f8b\u3002\u5e0c\u671b\u901a\u8fc7\u8fd9\u4e9b\u793a\u4f8b\u80fd\u591f\u5e2e\u52a9\u8bfb\u8005\u66f4\u597d\u5730\u7406\u89e3\u548c\u8fd0\u7528WebMan\u6280\u672f\u6765\u6784\u5efa\u4e13\u4e1a\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u3002<\/p>\n
              \u4ee5\u4e0a\u5c31\u662f\u8fd0\u7528WebMan\u6280\u672f\u6784\u5efa\u4e13\u4e1a\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
              \u6807\u9898\uff1a\u8fd0\u7528WebMan\u6280\u672f\u6784\u5efa\u4e13\u4e1a\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0 \u524d\u8a00\uff1a\u968f\u7740\u4e92\u8054\u7f51\u7684\u5feb\u901f\u53d1\u5c55\uff0c\u97f3\u4e50\u6210\u4e3a\u4eba\u4eec\u751f\u6d3b\u4e2d\u4e0d\u53ef\u6216\u7f3a\u7684\u4e00\u90e8\u5206\u3002\u56e0\u6b64\uff0c\u6784\u5efa\u4e00\u4e2a\u4e13\u4e1a\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u53d8\u5f97\u5c24\u4e3a\u91cd\u8981\u3002\u5728\u672c\u6587\u4e2d\uff0c\u6211\u4eec\u5c06\u4ecb\u7ecd\u5982\u4f55\u8fd0\u7528WebMan\u6280\u672f\u6765\u6784\u5efa\u4e00\u4e2a\u529f\u80fd\u5f3a\u5927\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\uff0c\u5e76\u9644\u4e0a\u76f8\u5e94\u7684\u4ee3\u7801\u793a\u4f8b\u3002 \u4e00\u3001\u6280\u672f\u9009\u62e9\u4e0e\u51c6\u5907\u5728\u6784\u5efa\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u4e4b\u524d\uff0c\u6211\u4eec\u9700\u8981\u9009\u62e9\u5408\u9002\u7684\u6280\u672f\u3002\u5728\u6b64\uff0c\u6211\u4eec\u9009\u62e9\u4f7f\u7528WebMan\u6280\u672f\uff0c\u56e0\u4e3a\u5b83\u662f\u4e00\u79cd\u975e\u5e38\u5f3a\u5927\u4e14\u7075\u6d3b\u7684\u6280\u672f\uff0c\u53ef\u4ee5\u5e2e\u52a9\u6211\u4eec\u5feb\u901f\u642d\u5efa\u4e00\u4e2a\u4e13\u4e1a\u7684\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u3002 \u5728\u5f00\u59cb\u4e4b\u524d\uff0c\u6211\u4eec\u9700\u8981\u51c6\u5907\u4ee5\u4e0b\u5de5\u5177\u548c\u73af\u5883\uff1a Web\u670d\u52a1\u5668\uff08\u5982Apache\u3001Nginx\u7b49\uff09 PHP\u7f16\u7a0b\u8bed\u8a00 MySQL\u6570\u636e\u5e93 HTML\u3001CSS\u548cJavaScript\u6280\u672f \u4e8c\u3001\u6570\u636e\u5e93\u8bbe\u8ba1\u5728\u6784\u5efa\u97f3\u4e50\u64ad\u653e\u5e73\u53f0\u65f6\uff0c\u6838\u5fc3\u7684\u6570\u636e\u5b58\u50a8\u548c\u7ba1\u7406\u5de5\u4f5c\u7531\u6570\u636e\u5e93\u6765\u5b8c\u6210\u3002\u4e0b\u9762\u662f\u4e00\u4e2a\u7b80\u5355\u7684\u6570\u636e\u5e93\u8bbe\u8ba1\u793a\u4f8b\uff1a \u8868\uff1a\u7528\u6237\u8868\uff08users\uff09\u5b57\u6bb5\uff1a id\uff08\u7528\u6237ID\uff09 username\uff08\u7528\u6237\u540d\uff09 password\uff08\u5bc6\u7801\uff09 email\uff08\u7535\u5b50\u90ae\u7bb1\uff09 \u8868\uff1a\u6b4c\u66f2\u8868\uff08songs\uff09\u5b57\u6bb5\uff1a id\uff08\u6b4c\u66f2ID\uff09 title\uff08\u6b4c\u66f2\u6807\u9898\uff09 artist\uff08\u6b4c\u66f2\u827a\u672f\u5bb6\uff09 album\uff08\u6b4c\u66f2\u6240\u5c5e\u4e13\u8f91\uff09 file_path\uff08\u6b4c\u66f2\u6587\u4ef6\u8def\u5f84\uff09 \u8868\uff1a\u64ad\u653e\u5217\u8868\uff08playlists\uff09\u5b57\u6bb5\uff1a id\uff08\u64ad\u653e\u5217\u8868ID\uff09 user_id\uff08\u7528\u6237ID\uff09 name\uff08\u64ad\u653e\u5217\u8868\u540d\u79f0\uff09 \u8868\uff1a\u64ad\u653e\u5217\u8868\u6b4c\u66f2\uff08playlist_songs\uff09\u5b57\u6bb5\uff1a id\uff08\u64ad\u653e\u5217\u8868\u6b4c\u66f2ID\uff09 playlist_id\uff08\u64ad\u653e\u5217\u8868ID\uff09 song_id\uff08\u6b4c\u66f2ID\uff09 \u4e09\u3001\u642d\u5efa\u7528\u6237\u754c\u9762\u63a5\u4e0b\u6765\uff0c\u6211\u4eec\u5c06\u642d\u5efa\u4e00\u4e2a\u7528\u6237\u53cb\u597d\u7684\u524d\u7aef\u754c\u9762\u3002\u5728\u8fd9\u4e2a\u793a\u4f8b\u4e2d\uff0c\u6211\u4eec\u5c06\u4f7f\u7528HTML\u3001CSS\u548cJavaScript\u6765\u5b9e\u73b0\u3002 HTML\u4ee3\u7801\u793a\u4f8b\uff1a <meta charset=”UTF-8″><title>\u97f3\u4e50\u64ad\u653e\u5e73\u53f0<\/title><link rel=”stylesheet” href=”style.css”><h1>\u97f3\u4e50\u64ad\u653e\u5e73\u53f0<\/h1> <div id=”playlist”> <h2>\u6211\u7684\u64ad\u653e\u5217\u8868<\/h2> <ul id=”playlist-items”><!– \u6b64\u5904\u586b\u5145\u64ad\u653e\u5217\u8868 –><\/ul> <\/div> <div id=”songs”> <h2>\u6b4c\u66f2\u5217\u8868<\/h2> <ul id=”song-items”><!– \u6b64\u5904\u586b\u5145\u6b4c\u66f2\u5217\u8868 –><\/ul> <\/div> <script src=”script.js”><\/script> \u767b\u5f55\u540e\u590d\u5236 CSS\u4ee3\u7801\u793a\u4f8b\uff08style.css\uff09\uff1a \/* […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-24361","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/24361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=24361"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/24361\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=24361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=24361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=24361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}