{"id":5376,"date":"2026-01-11T11:25:50","date_gmt":"2026-01-11T03:25:50","guid":{"rendered":"https:\/\/code.jishujc.com\/?p=5376"},"modified":"2026-01-11T11:25:50","modified_gmt":"2026-01-11T03:25:50","slug":"%e5%bd%b1%e8%a7%86%e9%87%87%e9%9b%86%e6%8e%a5%e5%8f%a3%e8%8e%b7%e5%8f%96-%e8%8b%b9%e6%9e%9c-cms-%e5%bd%b1%e8%a7%86%e9%87%87%e9%9b%86%e5%af%b9%e6%8e%a5%e5%ae%9e%e6%93%8d%e6%95%99%e7%a8%8b","status":"publish","type":"post","link":"https:\/\/www.qqjishu.com\/index.php\/2026\/01\/11\/%e5%bd%b1%e8%a7%86%e9%87%87%e9%9b%86%e6%8e%a5%e5%8f%a3%e8%8e%b7%e5%8f%96-%e8%8b%b9%e6%9e%9c-cms-%e5%bd%b1%e8%a7%86%e9%87%87%e9%9b%86%e5%af%b9%e6%8e%a5%e5%ae%9e%e6%93%8d%e6%95%99%e7%a8%8b\/","title":{"rendered":"\u5f71\u89c6\u91c7\u96c6\u63a5\u53e3\u83b7\u53d6 \u82f9\u679c cms \u5f71\u89c6\u91c7\u96c6\u5bf9\u63a5\u5b9e\u64cd\u6559\u7a0b"},"content":{"rendered":"<p class=\"ds-markdown-paragraph\">\u5f71\u89c6\u91c7\u96c6\u63a5\u53e3\u662f\u82f9\u679cCMS\u81ea\u52a8\u91c7\u96c6\u529f\u80fd\u7684\u6838\u5fc3\uff0c\u6b63\u786e\u83b7\u53d6\u548c\u914d\u7f6e\u63a5\u53e3\u76f4\u63a5\u5173\u7cfb\u5230\u91c7\u96c6\u6548\u679c\u3002\u672c\u6587\u5c06\u4ece\u63a5\u53e3\u83b7\u53d6\u3001\u914d\u7f6e\u5230\u4f18\u5316\uff0c\u63d0\u4f9b\u5b8c\u6574\u7684\u82f9\u679cCMS\u5f71\u89c6\u91c7\u96c6\u5bf9\u63a5\u5b9e\u64cd\u6559\u7a0b\uff0c\u5e2e\u52a9\u60a8\u5efa\u7acb\u7a33\u5b9a\u9ad8\u6548\u7684\u91c7\u96c6\u7cfb\u7edf\u3002<\/p>\n<h2>\u5f71\u89c6\u91c7\u96c6\u63a5\u53e3\u57fa\u7840\u8ba4\u77e5<\/h2>\n<h3>\u63a5\u53e3\u7c7b\u578b\u4e0e\u5de5\u4f5c\u539f\u7406<\/h3>\n<h4>\u4e3b\u8981\u63a5\u53e3\u683c\u5f0f<\/h4>\n<ol start=\"1\">\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>XML\u63a5\u53e3<\/strong>\uff1a\u4f20\u7edf\u683c\u5f0f\uff0c\u7ed3\u6784\u6e05\u6670\uff0c\u517c\u5bb9\u6027\u597d<\/p>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">xml<\/span><\/div>\n<div class=\"d2a24f03 _246a029\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>video<span class=\"token punctuation\">&gt;<\/span><\/span>\n  <span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>id<span class=\"token punctuation\">&gt;<\/span><\/span>12345<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>id<span class=\"token punctuation\">&gt;<\/span><\/span>\n  <span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>name<span class=\"token punctuation\">&gt;<\/span><\/span>\u7535\u5f71\u540d\u79f0<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>name<span class=\"token punctuation\">&gt;<\/span><\/span>\n  <span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>pic<span class=\"token punctuation\">&gt;<\/span><\/span>\u5c01\u9762\u5730\u5740<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>pic<span class=\"token punctuation\">&gt;<\/span><\/span>\n  <span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>url<span class=\"token punctuation\">&gt;<\/span><\/span>\u64ad\u653e\u5730\u5740<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>url<span class=\"token punctuation\">&gt;<\/span><\/span>\n<span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>video<span class=\"token punctuation\">&gt;<\/span><\/span><\/pre>\n<\/div>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>JSON\u63a5\u53e3<\/strong>\uff1a\u73b0\u4ee3\u683c\u5f0f\uff0c\u6570\u636e\u91cf\u5c0f\uff0c\u89e3\u6790\u5feb<\/p>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">json<\/span><\/div>\n<div class=\"d2a24f03 _246a029\">\n<div class=\"efa13877\">\n<div class=\"ds-focus-ring\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre><span class=\"token punctuation\">{<\/span>\n  <span class=\"token property\">\"id\"<\/span><span class=\"token operator\">:<\/span> <span class=\"token number\">12345<\/span><span class=\"token punctuation\">,<\/span>\n  <span class=\"token property\">\"name\"<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">\"\u7535\u5f71\u540d\u79f0\"<\/span><span class=\"token punctuation\">,<\/span>\n  <span class=\"token property\">\"pic\"<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">\"\u5c01\u9762\u5730\u5740\"<\/span><span class=\"token punctuation\">,<\/span>\n  <span class=\"token property\">\"url\"<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">\"\u64ad\u653e\u5730\u5740\"<\/span>\n<span class=\"token punctuation\">}<\/span><\/pre>\n<\/div>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u81ea\u5b9a\u4e49API\u63a5\u53e3<\/strong>\uff1a\u9700\u8981\u7279\u5b9a\u53c2\u6570\u548c\u8ba4\u8bc1<\/p>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">text<\/span><\/div>\n<div class=\"d2a24f03 _246a029\">\n<div class=\"efa13877\">\n<div class=\"ds-focus-ring\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre>https:\/\/api.example.com\/videos?token=xxx&amp;type=movies<\/pre>\n<\/div>\n<\/li>\n<\/ol>\n<h4>\u63a5\u53e3\u5de5\u4f5c\u6d41\u7a0b<\/h4>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">text<\/span><\/div>\n<div class=\"d2a24f03 _246a029\">\n<div class=\"efa13877\">\n<div class=\"ds-focus-ring\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre>\u8bf7\u6c42\u6d41\u7a0b\uff1a\n1. \u82f9\u679cCMS\u53d1\u9001\u91c7\u96c6\u8bf7\u6c42\n2. \u63a5\u53e3\u670d\u52a1\u5668\u54cd\u5e94\u6570\u636e\n3. \u89e3\u6790\u8fd4\u56de\u7684XML\/JSON\n4. \u6570\u636e\u6e05\u6d17\u548c\u683c\u5f0f\u5316\n5. \u5b58\u50a8\u5230\u672c\u5730\u6570\u636e\u5e93\n\n\u5b9a\u65f6\u4efb\u52a1\u89e6\u53d1 \u2192 \u63a5\u53e3\u8c03\u7528 \u2192 \u6570\u636e\u5904\u7406 \u2192 \u672c\u5730\u5b58\u50a8 \u2192 \u53d1\u5e03\u5c55\u793a<\/pre>\n<\/div>\n<h2>\u63a5\u53e3\u83b7\u53d6\u6e20\u9053\u4e0e\u65b9\u6cd5<\/h2>\n<h3>\u514d\u8d39\u63a5\u53e3\u83b7\u53d6\u9014\u5f84<\/h3>\n<h4>\u9014\u5f84\u4e00\uff1a\u516c\u5f00\u8d44\u6e90\u7ad9<\/h4>\n<ol start=\"1\">\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u5f71\u89c6\u8d44\u6e90\u8bba\u575b<\/strong>\uff1a\u4e13\u4e1a\u8bba\u575b\u5206\u4eab\u7684\u63a5\u53e3<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>GitHub\u5f00\u6e90\u9879\u76ee<\/strong>\uff1a\u5f00\u53d1\u8005\u5206\u4eab\u7684\u63a5\u53e3\u96c6\u5408<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u6280\u672f\u535a\u5ba2<\/strong>\uff1a\u535a\u4e3b\u6d4b\u8bd5\u53ef\u7528\u7684\u63a5\u53e3<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u6a21\u677f\u6c47\uff08<a href=\"https:\/\/www.qqjishu.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">www.qqjishu.com\/<\/a>\uff09<\/strong>\uff1a\u4e13\u4e1a\u8d44\u6e90\u5e73\u53f0\u63d0\u4f9b\u7684\u63a5\u53e3<\/p>\n<\/li>\n<\/ol>\n<h4>\u9014\u5f84\u4e8c\uff1a\u81ea\u884c\u53d1\u73b0<\/h4>\n<ol start=\"1\">\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u6d4f\u89c8\u5668\u5f00\u53d1\u8005\u5de5\u5177<\/strong>\uff1a\u5206\u6790\u7f51\u7ad9\u8bf7\u6c42<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u7f51\u7edc\u6293\u5305\u5de5\u5177<\/strong>\uff1aCharles\u3001Fiddler<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u79fb\u52a8\u7aef\u5206\u6790<\/strong>\uff1aApp\u7aef\u63a5\u53e3\u53ef\u80fd\u66f4\u5bbd\u677e<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u53cd\u5411\u5de5\u7a0b<\/strong>\uff1a\u5206\u6790\u73b0\u6709\u91c7\u96c6\u7ad9<\/p>\n<\/li>\n<\/ol>\n<h3>\u63a5\u53e3\u6709\u6548\u6027\u68c0\u6d4b<\/h3>\n<h4>\u68c0\u6d4b\u811a\u672c\u793a\u4f8b<\/h4>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">python<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre><span class=\"token keyword\">import<\/span> requests\n<span class=\"token keyword\">import<\/span> json\n<span class=\"token keyword\">import<\/span> xml<span class=\"token punctuation\">.<\/span>etree<span class=\"token punctuation\">.<\/span>ElementTree <span class=\"token keyword\">as<\/span> ET\n<span class=\"token keyword\">from<\/span> datetime <span class=\"token keyword\">import<\/span> datetime\n\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name\">InterfaceTester<\/span><span class=\"token punctuation\">:<\/span>\n    <span class=\"token keyword\">def<\/span> <span class=\"token function\">__init__<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n        self<span class=\"token punctuation\">.<\/span>session <span class=\"token operator\">=<\/span> requests<span class=\"token punctuation\">.<\/span>Session<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n        self<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>headers<span class=\"token punctuation\">.<\/span>update<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span>\n            <span class=\"token string\">'User-Agent'<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">'Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36'<\/span>\n        <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span>\n    \n    <span class=\"token keyword\">def<\/span> <span class=\"token function\">test_interface<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> url<span class=\"token punctuation\">,<\/span> interface_type<span class=\"token operator\">=<\/span><span class=\"token string\">'json'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n        <span class=\"token triple-quoted-string string\">\"\"\"\u6d4b\u8bd5\u63a5\u53e3\u6709\u6548\u6027\"\"\"<\/span>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"\u6d4b\u8bd5\u63a5\u53e3: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>url<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"\u63a5\u53e3\u7c7b\u578b: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>interface_type<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"-\"<\/span> <span class=\"token operator\">*<\/span> <span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span>\n        \n        <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span>\n            <span class=\"token comment\"># \u53d1\u9001\u8bf7\u6c42<\/span>\n            start_time <span class=\"token operator\">=<\/span> datetime<span class=\"token punctuation\">.<\/span>now<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n            response <span class=\"token operator\">=<\/span> self<span class=\"token punctuation\">.<\/span>session<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span>url<span class=\"token punctuation\">,<\/span> timeout<span class=\"token operator\">=<\/span><span class=\"token number\">15<\/span><span class=\"token punctuation\">)<\/span>\n            end_time <span class=\"token operator\">=<\/span> datetime<span class=\"token punctuation\">.<\/span>now<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n            \n            response_time <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">(<\/span>end_time <span class=\"token operator\">-<\/span> start_time<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>total_seconds<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n            \n            <span class=\"token comment\"># \u68c0\u67e5HTTP\u72b6\u6001<\/span>\n            <span class=\"token keyword\">if<\/span> response<span class=\"token punctuation\">.<\/span>status_code <span class=\"token operator\">!=<\/span> <span class=\"token number\">200<\/span><span class=\"token punctuation\">:<\/span>\n                <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"HTTP\u9519\u8bef: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>response<span class=\"token punctuation\">.<\/span>status_code<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n                <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">False<\/span>\n            \n            <span class=\"token comment\"># \u68c0\u67e5\u5185\u5bb9\u7c7b\u578b<\/span>\n            content_type <span class=\"token operator\">=<\/span> response<span class=\"token punctuation\">.<\/span>headers<span class=\"token punctuation\">.<\/span>get<span class=\"token punctuation\">(<\/span><span class=\"token string\">'Content-Type'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">''<\/span><span class=\"token punctuation\">)<\/span>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"\u54cd\u5e94\u7c7b\u578b: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>content_type<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"\u54cd\u5e94\u65f6\u95f4: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>response_time<span class=\"token punctuation\">:<\/span><span class=\"token format-spec\">.2f<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\u79d2\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n            \n            <span class=\"token comment\"># \u9a8c\u8bc1\u6570\u636e\u683c\u5f0f<\/span>\n            <span class=\"token keyword\">if<\/span> interface_type <span class=\"token operator\">==<\/span> <span class=\"token string\">'json'<\/span><span class=\"token punctuation\">:<\/span>\n                <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span>\n                    data <span class=\"token operator\">=<\/span> json<span class=\"token punctuation\">.<\/span>loads<span class=\"token punctuation\">(<\/span>response<span class=\"token punctuation\">.<\/span>text<span class=\"token punctuation\">)<\/span>\n                    self<span class=\"token punctuation\">.<\/span>analyze_json_data<span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">)<\/span>\n                    <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">True<\/span>\n                <span class=\"token keyword\">except<\/span> json<span class=\"token punctuation\">.<\/span>JSONDecodeError<span class=\"token punctuation\">:<\/span>\n                    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"JSON\u89e3\u6790\u5931\u8d25\"<\/span><span class=\"token punctuation\">)<\/span>\n                    <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">False<\/span>\n                    \n            <span class=\"token keyword\">elif<\/span> interface_type <span class=\"token operator\">==<\/span> <span class=\"token string\">'xml'<\/span><span class=\"token punctuation\">:<\/span>\n                <span class=\"token keyword\">try<\/span><span class=\"token punctuation\">:<\/span>\n                    root <span class=\"token operator\">=<\/span> ET<span class=\"token punctuation\">.<\/span>fromstring<span class=\"token punctuation\">(<\/span>response<span class=\"token punctuation\">.<\/span>text<span class=\"token punctuation\">)<\/span>\n                    self<span class=\"token punctuation\">.<\/span>analyze_xml_data<span class=\"token punctuation\">(<\/span>root<span class=\"token punctuation\">)<\/span>\n                    <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">True<\/span>\n                <span class=\"token keyword\">except<\/span> ET<span class=\"token punctuation\">.<\/span>ParseError<span class=\"token punctuation\">:<\/span>\n                    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"XML\u89e3\u6790\u5931\u8d25\"<\/span><span class=\"token punctuation\">)<\/span>\n                    <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">False<\/span>\n                    \n        <span class=\"token keyword\">except<\/span> requests<span class=\"token punctuation\">.<\/span>RequestException <span class=\"token keyword\">as<\/span> e<span class=\"token punctuation\">:<\/span>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"\u8bf7\u6c42\u5f02\u5e38: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>e<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n            <span class=\"token keyword\">return<\/span> <span class=\"token boolean\">False<\/span>\n    \n    <span class=\"token keyword\">def<\/span> <span class=\"token function\">analyze_json_data<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> data<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n        <span class=\"token triple-quoted-string string\">\"\"\"\u5206\u6790JSON\u6570\u636e\u7ed3\u6784\"\"\"<\/span>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"\u6570\u636e\u91cf: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">list<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">else<\/span> <span class=\"token string\">'\u5355\u6761'<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n        \n        <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">isinstance<\/span><span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">,<\/span> <span class=\"token builtin\">list<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">and<\/span> <span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>data<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span>\n            sample <span class=\"token operator\">=<\/span> data<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u6570\u636e\u7ed3\u6784\u793a\u4f8b:\"<\/span><span class=\"token punctuation\">)<\/span>\n            <span class=\"token keyword\">for<\/span> key<span class=\"token punctuation\">,<\/span> value <span class=\"token keyword\">in<\/span> sample<span class=\"token punctuation\">.<\/span>items<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n                <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"  <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>key<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">type<\/span><span class=\"token punctuation\">(<\/span>value<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span>__name__<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n                \n            <span class=\"token comment\"># \u68c0\u67e5\u5fc5\u8981\u5b57\u6bb5<\/span>\n            required_fields <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">'title'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'vod_pic'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'vod_url'<\/span><span class=\"token punctuation\">]<\/span>\n            missing <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>field <span class=\"token keyword\">for<\/span> field <span class=\"token keyword\">in<\/span> required_fields <span class=\"token keyword\">if<\/span> field <span class=\"token keyword\">not<\/span> <span class=\"token keyword\">in<\/span> sample<span class=\"token punctuation\">]<\/span>\n            <span class=\"token keyword\">if<\/span> missing<span class=\"token punctuation\">:<\/span>\n                <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"\u7f3a\u5c11\u5fc5\u8981\u5b57\u6bb5: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>missing<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n            <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span>\n                <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u5fc5\u8981\u5b57\u6bb5\u5b8c\u6574\"<\/span><span class=\"token punctuation\">)<\/span>\n    \n    <span class=\"token keyword\">def<\/span> <span class=\"token function\">analyze_xml_data<\/span><span class=\"token punctuation\">(<\/span>self<span class=\"token punctuation\">,<\/span> root<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">:<\/span>\n        <span class=\"token triple-quoted-string string\">\"\"\"\u5206\u6790XML\u6570\u636e\u7ed3\u6784\"\"\"<\/span>\n        items <span class=\"token operator\">=<\/span> root<span class=\"token punctuation\">.<\/span>findall<span class=\"token punctuation\">(<\/span><span class=\"token string\">'.\/\/video'<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">or<\/span> root<span class=\"token punctuation\">.<\/span>findall<span class=\"token punctuation\">(<\/span><span class=\"token string\">'.\/\/item'<\/span><span class=\"token punctuation\">)<\/span>\n        <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"\u6570\u636e\u91cf: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>items<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\u6761\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n        \n        <span class=\"token keyword\">if<\/span> <span class=\"token builtin\">len<\/span><span class=\"token punctuation\">(<\/span>items<span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">:<\/span>\n            sample <span class=\"token operator\">=<\/span> items<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span>\n            <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u6570\u636e\u7ed3\u6784\u793a\u4f8b:\"<\/span><span class=\"token punctuation\">)<\/span>\n            <span class=\"token keyword\">for<\/span> child <span class=\"token keyword\">in<\/span> sample<span class=\"token punctuation\">:<\/span>\n                <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"  <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>child<span class=\"token punctuation\">.<\/span>tag<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>child<span class=\"token punctuation\">.<\/span>text<span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">:<\/span><span class=\"token format-spec\">50] if child.text else '\u7a7a'<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n            \n            <span class=\"token comment\"># \u68c0\u67e5\u5fc5\u8981\u5b57\u6bb5<\/span>\n            required_tags <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">'title'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'pic'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'url'<\/span><span class=\"token punctuation\">]<\/span>\n            missing <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>tag <span class=\"token keyword\">for<\/span> tag <span class=\"token keyword\">in<\/span> required_tags \n                      <span class=\"token keyword\">if<\/span> sample<span class=\"token punctuation\">.<\/span>find<span class=\"token punctuation\">(<\/span>tag<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">is<\/span> <span class=\"token boolean\">None<\/span><span class=\"token punctuation\">]<\/span>\n            <span class=\"token keyword\">if<\/span> missing<span class=\"token punctuation\">:<\/span>\n                <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"\u7f3a\u5c11\u5fc5\u8981\u5b57\u6bb5: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span>missing<span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n            <span class=\"token keyword\">else<\/span><span class=\"token punctuation\">:<\/span>\n                <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"\u5fc5\u8981\u5b57\u6bb5\u5b8c\u6574\"<\/span><span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># \u4f7f\u7528\u793a\u4f8b<\/span>\ntester <span class=\"token operator\">=<\/span> InterfaceTester<span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n\n<span class=\"token comment\"># \u6d4b\u8bd5\u591a\u4e2a\u63a5\u53e3<\/span>\ninterfaces <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>\n    <span class=\"token punctuation\">{<\/span><span class=\"token string\">'url'<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">'https:\/\/api1.com\/videos.json'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'type'<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">'json'<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">{<\/span><span class=\"token string\">'url'<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">'https:\/\/api2.com\/videos.xml'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'type'<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">'xml'<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token punctuation\">{<\/span><span class=\"token string\">'url'<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">'https:\/\/api3.com\/api\/movies'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">'type'<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">'json'<\/span><span class=\"token punctuation\">}<\/span>\n<span class=\"token punctuation\">]<\/span>\n\n<span class=\"token keyword\">for<\/span> interface <span class=\"token keyword\">in<\/span> interfaces<span class=\"token punctuation\">:<\/span>\n    result <span class=\"token operator\">=<\/span> tester<span class=\"token punctuation\">.<\/span>test_interface<span class=\"token punctuation\">(<\/span>interface<span class=\"token punctuation\">[<\/span><span class=\"token string\">'url'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span> interface<span class=\"token punctuation\">[<\/span><span class=\"token string\">'type'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string-interpolation\"><span class=\"token string\">f\"\u6d4b\u8bd5\u7ed3\u679c: <\/span><span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token string\">'\u6210\u529f'<\/span> <span class=\"token keyword\">if<\/span> result <span class=\"token keyword\">else<\/span> <span class=\"token string\">'\u5931\u8d25'<\/span><span class=\"token punctuation\">}<\/span><\/span><span class=\"token string\">\"<\/span><\/span><span class=\"token punctuation\">)<\/span>\n    <span class=\"token keyword\">print<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">\"=\"<\/span> <span class=\"token operator\">*<\/span> <span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span><\/pre>\n<\/div>\n<h2>\u82f9\u679cCMS\u63a5\u53e3\u914d\u7f6e\u5b9e\u64cd<\/h2>\n<h3>\u540e\u53f0\u914d\u7f6e\u6b65\u9aa4\u8be6\u89e3<\/h3>\n<h4>\u6b65\u9aa4\u4e00\uff1a\u8fdb\u5165\u91c7\u96c6\u914d\u7f6e<\/h4>\n<ol start=\"1\">\n<li>\n<p class=\"ds-markdown-paragraph\">\u767b\u5f55\u82f9\u679cCMS\u540e\u53f0<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u5bfc\u822a\u5230\uff1a\u91c7\u96c6 \u2192 \u81ea\u5b9a\u4e49\u8d44\u6e90\u5e93<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u70b9\u51fb\u201c\u6dfb\u52a0\u8d44\u6e90\u5e93\u201d\u6309\u94ae<\/p>\n<\/li>\n<\/ol>\n<h4>\u6b65\u9aa4\u4e8c\uff1a\u586b\u5199\u63a5\u53e3\u4fe1\u606f<\/h4>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">text<\/span><\/div>\n<div class=\"d2a24f03 _246a029\">\n<div class=\"efa13877\">\n<div class=\"ds-focus-ring\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre>\u914d\u7f6e\u9879\u8be6\u89e3\uff1a\n\n1. \u8d44\u6e90\u5e93\u540d\u79f0\uff1a\u81ea\u5b9a\u4e49\u540d\u79f0\uff08\u5982\uff1a\u7535\u5f71\u8d44\u6e90\u5e93-01\uff09\n2. \u8d44\u6e90\u5e93\u5730\u5740\uff1a\u5b8c\u6574\u7684\u63a5\u53e3URL\n3. \u91c7\u96c6\u7c7b\u578b\uff1aXML\/JSON\n4. \u5206\u7c7b\u7ed1\u5b9a\uff1a\u9009\u62e9\u201c\u8fdb\u5165\u914d\u7f6e\u201d\n5. \u72b6\u6001\uff1a\u542f\u7528\n6. \u6392\u5e8f\uff1a\u6570\u5b57\u8d8a\u5c0f\u4f18\u5148\u7ea7\u8d8a\u9ad8\n7. \u91c7\u96c6\u95f4\u9694\uff1a\u5efa\u8bae300-600\u79d2\n8. \u91c7\u96c6\u9875\u6570\uff1a\u9996\u6b21\u53ef\u8bbe\u7f6e5-10\u9875<\/pre>\n<\/div>\n<h4>\u6b65\u9aa4\u4e09\uff1a\u5206\u7c7b\u7ed1\u5b9a\u914d\u7f6e<\/h4>\n<p class=\"ds-markdown-paragraph\">\u8fd9\u662f\u6700\u5173\u952e\u7684\u4e00\u6b65\uff0c\u786e\u4fdd\u6b63\u786e\u6620\u5c04\u5206\u7c7b\uff1a<\/p>\n<ol start=\"1\">\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u83b7\u53d6\u8fdc\u7a0b\u5206\u7c7b<\/strong>\uff1a\u70b9\u51fb\u201c\u83b7\u53d6\u5206\u7c7b\u201d\u6309\u94ae<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u5efa\u7acb\u5bf9\u5e94\u5173\u7cfb<\/strong>\uff1a\u5c06\u8fdc\u7a0b\u5206\u7c7b\u6620\u5c04\u5230\u672c\u7ad9\u5206\u7c7b<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u7279\u6b8a\u5904\u7406<\/strong>\uff1a\u591a\u7ea7\u5206\u7c7b\u7684\u6620\u5c04\u7b56\u7565<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\"><strong>\u4fdd\u5b58\u914d\u7f6e<\/strong>\uff1a\u5b8c\u6210\u6240\u6709\u5206\u7c7b\u6620\u5c04\u540e\u4fdd\u5b58<\/p>\n<\/li>\n<\/ol>\n<h4>\u6b65\u9aa4\u56db\uff1a\u9ad8\u7ea7\u53c2\u6570\u8bbe\u7f6e<\/h4>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">ini<\/span><\/div>\n<div class=\"d2a24f03 _246a029\">\n<div class=\"efa13877\">\n<div class=\"ds-focus-ring\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre><span class=\"token comment\"># \u63a8\u8350\u7684\u9ad8\u7ea7\u53c2\u6570\u914d\u7f6e<\/span>\n\u91c7\u96c6\u5ef6\u65f6\uff1a3\u79d2\n\u8d85\u65f6\u65f6\u95f4\uff1a30\u79d2\n\u56fe\u7247\u672c\u5730\u5316\uff1a\u5f00\u542f\n\u5185\u5bb9\u66ff\u6362\uff1a\u6839\u636e\u9700\u8981\u8bbe\u7f6e\n\u64ad\u653e\u5668\u5bf9\u5e94\uff1a\u914d\u7f6e\u64ad\u653e\u5668ID<\/pre>\n<\/div>\n<h3>\u914d\u7f6e\u5b9e\u4f8b\u6f14\u793a<\/h3>\n<h4>JSON\u63a5\u53e3\u914d\u7f6e\u5b9e\u4f8b<\/h4>\n<p class=\"ds-markdown-paragraph\">\u5047\u8bbe\u63a5\u53e3\u5730\u5740\u4e3a\uff1a<code>https:\/\/api.movie.com\/v1\/videos?page={page}<\/code><\/p>\n<p class=\"ds-markdown-paragraph\">\u540e\u53f0\u914d\u7f6e\uff1a<\/p>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">text<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre>\u8d44\u6e90\u5e93\u540d\u79f0\uff1aMovieAPI-2026\n\u8d44\u6e90\u5e93\u5730\u5740\uff1ahttps:\/\/api.movie.com\/v1\/videos?page={page}\n\u91c7\u96c6\u7c7b\u578b\uff1aJSON\n\u53c2\u6570\u8bbe\u7f6e\uff1apage=1&amp;limit=20\n\u5206\u7c7b\u7ed1\u5b9a\uff1a\u5f71\u89c6\/\u7535\u89c6\u5267\/\u52a8\u6f2b\n\u72b6\u6001\uff1a\u542f\u7528\n\u6392\u5e8f\uff1a1<\/pre>\n<\/div>\n<h4>XML\u63a5\u53e3\u914d\u7f6e\u5b9e\u4f8b<\/h4>\n<p class=\"ds-markdown-paragraph\">\u5047\u8bbe\u63a5\u53e3\u5730\u5740\u4e3a\uff1a<code>https:\/\/feed.video.com\/rss.xml<\/code><\/p>\n<p class=\"ds-markdown-paragraph\">\u540e\u53f0\u914d\u7f6e\uff1a<\/p>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">text<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre>\u8d44\u6e90\u5e93\u540d\u79f0\uff1aVideoFeed-RSS\n\u8d44\u6e90\u5e93\u5730\u5740\uff1ahttps:\/\/feed.video.com\/rss.xml\n\u91c7\u96c6\u7c7b\u578b\uff1aXML\n\u8282\u70b9\u8def\u5f84\uff1a\/rss\/channel\/item\n\u5206\u7c7b\u7ed1\u5b9a\uff1a\u81ea\u52a8\u8bc6\u522b\u6216\u624b\u52a8\u914d\u7f6e\n\u72b6\u6001\uff1a\u542f\u7528\n\u6392\u5e8f\uff1a2<\/pre>\n<\/div>\n<h2>\u81ea\u5b9a\u4e49\u63a5\u53e3\u5f00\u53d1\u6307\u5357<\/h2>\n<h3>\u7b80\u5355\u63a5\u53e3\u670d\u52a1\u5668\u642d\u5efa<\/h3>\n<h4>PHP\u63a5\u53e3\u793a\u4f8b<\/h4>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">php<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre><span class=\"token php language-php\"><span class=\"token delimiter important\">&lt;?php<\/span>\n<span class=\"token comment\">\/\/ api.php - \u82f9\u679cCMS\u91c7\u96c6\u63a5\u53e3<\/span>\n<span class=\"token function\">header<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'Content-Type: application\/json; charset=utf-8'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">\/\/ \u6570\u636e\u5e93\u914d\u7f6e<\/span>\n<span class=\"token variable\">$db_config<\/span> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>\n    <span class=\"token string single-quoted-string\">'host'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token string single-quoted-string\">'localhost'<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token string single-quoted-string\">'dbname'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token string single-quoted-string\">'video_library'<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token string single-quoted-string\">'username'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token string single-quoted-string\">'username'<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token string single-quoted-string\">'password'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token string single-quoted-string\">'password'<\/span>\n<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">\/\/ \u8fde\u63a5\u6570\u636e\u5e93<\/span>\n<span class=\"token keyword\">try<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token variable\">$pdo<\/span> <span class=\"token operator\">=<\/span> <span class=\"token keyword\">new<\/span> <span class=\"token class-name\">PDO<\/span><span class=\"token punctuation\">(<\/span>\n        <span class=\"token string double-quoted-string\">\"mysql:host=<span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token variable\">$db_config<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'host'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span>;dbname=<span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token variable\">$db_config<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'dbname'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">}<\/span><\/span>;charset=utf8mb4\"<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token variable\">$db_config<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'username'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token variable\">$db_config<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'password'<\/span><span class=\"token punctuation\">]<\/span>\n    <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token variable\">$pdo<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">setAttribute<\/span><span class=\"token punctuation\">(<\/span><span class=\"token class-name static-context\">PDO<\/span><span class=\"token operator\">::<\/span><span class=\"token constant\">ATTR_ERRMODE<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token class-name static-context\">PDO<\/span><span class=\"token operator\">::<\/span><span class=\"token constant\">ERRMODE_EXCEPTION<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">catch<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token class-name\">PDOException<\/span> <span class=\"token variable\">$e<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token keyword\">die<\/span><span class=\"token punctuation\">(<\/span><span class=\"token function\">json_encode<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'error'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token string single-quoted-string\">'\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token punctuation\">}<\/span>\n\n<span class=\"token comment\">\/\/ \u83b7\u53d6\u53c2\u6570<\/span>\n<span class=\"token variable\">$page<\/span> <span class=\"token operator\">=<\/span> <span class=\"token keyword\">isset<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$_GET<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'page'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">?<\/span> <span class=\"token function\">max<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token function\">intval<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$_GET<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'page'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token variable\">$limit<\/span> <span class=\"token operator\">=<\/span> <span class=\"token keyword\">isset<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$_GET<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'limit'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">?<\/span> <span class=\"token function\">min<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">100<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token function\">intval<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$_GET<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'limit'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">:<\/span> <span class=\"token number\">20<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token variable\">$category<\/span> <span class=\"token operator\">=<\/span> <span class=\"token keyword\">isset<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$_GET<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'cid'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">?<\/span> <span class=\"token function\">intval<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$_GET<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'cid'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">:<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token variable\">$start<\/span> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token variable\">$page<\/span> <span class=\"token operator\">-<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">*<\/span> <span class=\"token variable\">$limit<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">\/\/ \u6784\u5efa\u67e5\u8be2<\/span>\n<span class=\"token variable\">$where<\/span> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'status = 1'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token variable\">$params<\/span> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token variable\">$category<\/span> <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token variable\">$where<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token string single-quoted-string\">'category_id = ?'<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token variable\">$params<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token variable\">$category<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token punctuation\">}<\/span>\n\n<span class=\"token variable\">$where_sql<\/span> <span class=\"token operator\">=<\/span> <span class=\"token variable\">$where<\/span> <span class=\"token operator\">?<\/span> <span class=\"token string single-quoted-string\">'WHERE '<\/span> <span class=\"token operator\">.<\/span> <span class=\"token function\">implode<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">' AND '<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$where<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">:<\/span> <span class=\"token string single-quoted-string\">''<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">\/\/ \u67e5\u8be2\u6570\u636e<\/span>\n<span class=\"token variable\">$sql<\/span> <span class=\"token operator\">=<\/span> <span class=\"token string double-quoted-string\">\"SELECT * FROM videos <span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token variable\">$where_sql<\/span><span class=\"token punctuation\">}<\/span><\/span> ORDER BY update_time DESC LIMIT <span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token variable\">$start<\/span><span class=\"token punctuation\">}<\/span><\/span>, <span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token variable\">$limit<\/span><span class=\"token punctuation\">}<\/span><\/span>\"<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token variable\">$stmt<\/span> <span class=\"token operator\">=<\/span> <span class=\"token variable\">$pdo<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">prepare<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$sql<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token variable\">$stmt<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">execute<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$params<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token variable\">$videos<\/span> <span class=\"token operator\">=<\/span> <span class=\"token variable\">$stmt<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">fetchAll<\/span><span class=\"token punctuation\">(<\/span><span class=\"token class-name static-context\">PDO<\/span><span class=\"token operator\">::<\/span><span class=\"token constant\">FETCH_ASSOC<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">\/\/ \u683c\u5f0f\u5316\u6570\u636e\uff08\u82f9\u679cCMS\u6807\u51c6\u683c\u5f0f\uff09<\/span>\n<span class=\"token variable\">$result<\/span> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">foreach<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token variable\">$videos<\/span> <span class=\"token keyword\">as<\/span> <span class=\"token variable\">$video<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token variable\">$result<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>\n        <span class=\"token string single-quoted-string\">'vod_id'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$video<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'id'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'vod_name'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token function\">htmlspecialchars<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$video<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'title'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'vod_pic'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$video<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'cover_url'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'vod_content'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$video<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'description'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'vod_year'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$video<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'year'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'vod_area'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$video<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'region'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'vod_actor'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$video<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'actors'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'vod_director'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$video<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'director'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'vod_url'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">format_play_url<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$video<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'play_urls'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'vod_time'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token function\">date<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'Y-m-d H:i:s'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$video<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'update_time'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span>\n    <span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token punctuation\">}<\/span>\n\n<span class=\"token comment\">\/\/ \u8fd4\u56de\u7ed3\u679c<\/span>\n<span class=\"token variable\">$response<\/span> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>\n    <span class=\"token string single-quoted-string\">'code'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token string single-quoted-string\">'msg'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token string single-quoted-string\">'success'<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token string single-quoted-string\">'page'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$page<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token string single-quoted-string\">'pagecount'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token function\">ceil<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">get_total_count<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$pdo<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$where<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$params<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">\/<\/span> <span class=\"token variable\">$limit<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token string single-quoted-string\">'limit'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$limit<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token string single-quoted-string\">'total'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token function\">count<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$result<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token string single-quoted-string\">'list'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$result<\/span>\n<span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token keyword\">echo<\/span> <span class=\"token function\">json_encode<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$response<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token class-name\">JSON_UNESCAPED_UNICODE<\/span> <span class=\"token operator\">|<\/span> <span class=\"token class-name\">JSON_PRETTY_PRINT<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">\/\/ \u8f85\u52a9\u51fd\u6570<\/span>\n<span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">get_total_count<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$pdo<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$where<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$params<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token variable\">$where_sql<\/span> <span class=\"token operator\">=<\/span> <span class=\"token variable\">$where<\/span> <span class=\"token operator\">?<\/span> <span class=\"token string single-quoted-string\">'WHERE '<\/span> <span class=\"token operator\">.<\/span> <span class=\"token function\">implode<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">' AND '<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$where<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">:<\/span> <span class=\"token string single-quoted-string\">''<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token variable\">$sql<\/span> <span class=\"token operator\">=<\/span> <span class=\"token string double-quoted-string\">\"SELECT COUNT(*) as total FROM videos <span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token variable\">$where_sql<\/span><span class=\"token punctuation\">}<\/span><\/span>\"<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token variable\">$stmt<\/span> <span class=\"token operator\">=<\/span> <span class=\"token variable\">$pdo<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">prepare<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$sql<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token variable\">$stmt<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">execute<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$params<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token keyword\">return<\/span> <span class=\"token variable\">$stmt<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">fetch<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'total'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token punctuation\">}<\/span>\n\n<span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">format_play_url<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$play_urls<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token variable\">$urls<\/span> <span class=\"token operator\">=<\/span> <span class=\"token function\">json_decode<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$play_urls<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token constant boolean\">true<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token variable\">$formatted<\/span> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n    \n    <span class=\"token keyword\">foreach<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token variable\">$urls<\/span> <span class=\"token keyword\">as<\/span> <span class=\"token variable\">$index<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$url_info<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token variable\">$formatted<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token function\">sprintf<\/span><span class=\"token punctuation\">(<\/span>\n            <span class=\"token string double-quoted-string\">\"\u7b2c%s\u96c6$%s\"<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token variable\">$index<\/span> <span class=\"token operator\">+<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token variable\">$url_info<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'url'<\/span><span class=\"token punctuation\">]<\/span>\n        <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n    \n    <span class=\"token keyword\">return<\/span> <span class=\"token function\">implode<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'#'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$formatted<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token punctuation\">}<\/span>\n<span class=\"token delimiter important\">?&gt;<\/span><\/span><\/pre>\n<\/div>\n<h4>Node.js\u63a5\u53e3\u793a\u4f8b<\/h4>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">javascript<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre><span class=\"token comment\">\/\/ server.js - Node.js\u91c7\u96c6\u63a5\u53e3<\/span>\n<span class=\"token keyword\">const<\/span> express <span class=\"token operator\">=<\/span> <span class=\"token function\">require<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'express'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">const<\/span> mysql <span class=\"token operator\">=<\/span> <span class=\"token function\">require<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'mysql2\/promise'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">const<\/span> app <span class=\"token operator\">=<\/span> <span class=\"token function\">express<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">const<\/span> port <span class=\"token operator\">=<\/span> <span class=\"token number\">3000<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">\/\/ \u6570\u636e\u5e93\u8fde\u63a5\u6c60<\/span>\n<span class=\"token keyword\">const<\/span> pool <span class=\"token operator\">=<\/span> mysql<span class=\"token punctuation\">.<\/span><span class=\"token function\">createPool<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span>\n    <span class=\"token literal-property property\">host<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'localhost'<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token literal-property property\">user<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'username'<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token literal-property property\">password<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'password'<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token literal-property property\">database<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'video_library'<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token literal-property property\">waitForConnections<\/span><span class=\"token operator\">:<\/span> <span class=\"token boolean\">true<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token literal-property property\">connectionLimit<\/span><span class=\"token operator\">:<\/span> <span class=\"token number\">10<\/span><span class=\"token punctuation\">,<\/span>\n    <span class=\"token literal-property property\">queueLimit<\/span><span class=\"token operator\">:<\/span> <span class=\"token number\">0<\/span>\n<span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">\/\/ \u82f9\u679cCMS\u91c7\u96c6\u63a5\u53e3<\/span>\napp<span class=\"token punctuation\">.<\/span><span class=\"token function\">get<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'\/api\/videos'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">async<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token parameter\">req<span class=\"token punctuation\">,<\/span> res<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token keyword\">try<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token keyword\">const<\/span> <span class=\"token punctuation\">{<\/span>\n            page <span class=\"token operator\">=<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span>\n            limit <span class=\"token operator\">=<\/span> <span class=\"token number\">20<\/span><span class=\"token punctuation\">,<\/span>\n            cid <span class=\"token operator\">=<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span>\n            t <span class=\"token operator\">=<\/span> <span class=\"token string\">''<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token comment\">\/\/ \u5206\u7c7b\u6807\u8bc6<\/span>\n            h <span class=\"token operator\">=<\/span> <span class=\"token number\">24<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token comment\">\/\/ \u66f4\u65b0\u65f6\u95f4\u8303\u56f4\uff08\u5c0f\u65f6\uff09<\/span>\n            pg <span class=\"token operator\">=<\/span> <span class=\"token number\">1<\/span>  <span class=\"token comment\">\/\/ \u9875\u7801<\/span>\n        <span class=\"token punctuation\">}<\/span> <span class=\"token operator\">=<\/span> req<span class=\"token punctuation\">.<\/span>query<span class=\"token punctuation\">;<\/span>\n\n        <span class=\"token keyword\">const<\/span> currentPage <span class=\"token operator\">=<\/span> <span class=\"token function\">parseInt<\/span><span class=\"token punctuation\">(<\/span>pg <span class=\"token operator\">||<\/span> page<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword\">const<\/span> pageSize <span class=\"token operator\">=<\/span> <span class=\"token function\">parseInt<\/span><span class=\"token punctuation\">(<\/span>limit<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword\">const<\/span> offset <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">(<\/span>currentPage <span class=\"token operator\">-<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">*<\/span> pageSize<span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword\">const<\/span> categoryId <span class=\"token operator\">=<\/span> <span class=\"token function\">parseInt<\/span><span class=\"token punctuation\">(<\/span>cid<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword\">const<\/span> hours <span class=\"token operator\">=<\/span> <span class=\"token function\">parseInt<\/span><span class=\"token punctuation\">(<\/span>h<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n        <span class=\"token comment\">\/\/ \u6784\u5efa\u67e5\u8be2\u6761\u4ef6<\/span>\n        <span class=\"token keyword\">let<\/span> whereClause <span class=\"token operator\">=<\/span> <span class=\"token string\">'WHERE status = 1'<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword\">const<\/span> params <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n\n        <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span>categoryId <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n            whereClause <span class=\"token operator\">+=<\/span> <span class=\"token string\">' AND category_id = ?'<\/span><span class=\"token punctuation\">;<\/span>\n            params<span class=\"token punctuation\">.<\/span><span class=\"token function\">push<\/span><span class=\"token punctuation\">(<\/span>categoryId<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token punctuation\">}<\/span>\n\n        <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span>hours <span class=\"token operator\">&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n            whereClause <span class=\"token operator\">+=<\/span> <span class=\"token string\">' AND update_time &gt;= DATE_SUB(NOW(), INTERVAL ? HOUR)'<\/span><span class=\"token punctuation\">;<\/span>\n            params<span class=\"token punctuation\">.<\/span><span class=\"token function\">push<\/span><span class=\"token punctuation\">(<\/span>hours<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token punctuation\">}<\/span>\n\n        <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span>t<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n            whereClause <span class=\"token operator\">+=<\/span> <span class=\"token string\">' AND type = ?'<\/span><span class=\"token punctuation\">;<\/span>\n            params<span class=\"token punctuation\">.<\/span><span class=\"token function\">push<\/span><span class=\"token punctuation\">(<\/span>t<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token punctuation\">}<\/span>\n\n        <span class=\"token comment\">\/\/ \u67e5\u8be2\u603b\u6570<\/span>\n        <span class=\"token keyword\">const<\/span> <span class=\"token punctuation\">[<\/span>countRows<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token keyword\">await<\/span> pool<span class=\"token punctuation\">.<\/span><span class=\"token function\">execute<\/span><span class=\"token punctuation\">(<\/span>\n            <span class=\"token template-string\"><span class=\"token template-punctuation string\">`<\/span><span class=\"token string\">SELECT COUNT(*) as total FROM videos <\/span><span class=\"token interpolation\"><span class=\"token interpolation-punctuation punctuation\">${<\/span>whereClause<span class=\"token interpolation-punctuation punctuation\">}<\/span><\/span><span class=\"token template-punctuation string\">`<\/span><\/span><span class=\"token punctuation\">,<\/span>\n            params\n        <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword\">const<\/span> total <span class=\"token operator\">=<\/span> countRows<span class=\"token punctuation\">[<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">.<\/span>total<span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword\">const<\/span> pageCount <span class=\"token operator\">=<\/span> Math<span class=\"token punctuation\">.<\/span><span class=\"token function\">ceil<\/span><span class=\"token punctuation\">(<\/span>total <span class=\"token operator\">\/<\/span> pageSize<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n        <span class=\"token comment\">\/\/ \u67e5\u8be2\u6570\u636e<\/span>\n        <span class=\"token keyword\">const<\/span> <span class=\"token punctuation\">[<\/span>rows<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token keyword\">await<\/span> pool<span class=\"token punctuation\">.<\/span><span class=\"token function\">execute<\/span><span class=\"token punctuation\">(<\/span>\n            <span class=\"token template-string\"><span class=\"token template-punctuation string\">`<\/span><span class=\"token string\">SELECT * FROM videos <\/span><span class=\"token interpolation\"><span class=\"token interpolation-punctuation punctuation\">${<\/span>whereClause<span class=\"token interpolation-punctuation punctuation\">}<\/span><\/span><span class=\"token string\"> \n             ORDER BY update_time DESC \n             LIMIT ? OFFSET ?<\/span><span class=\"token template-punctuation string\">`<\/span><\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token punctuation\">[<\/span><span class=\"token operator\">...<\/span>params<span class=\"token punctuation\">,<\/span> pageSize<span class=\"token punctuation\">,<\/span> offset<span class=\"token punctuation\">]<\/span>\n        <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n        <span class=\"token comment\">\/\/ \u683c\u5f0f\u5316\u54cd\u5e94\u6570\u636e<\/span>\n        <span class=\"token keyword\">const<\/span> result <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">{<\/span>\n            <span class=\"token literal-property property\">code<\/span><span class=\"token operator\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token literal-property property\">msg<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'success'<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token literal-property property\">page<\/span><span class=\"token operator\">:<\/span> currentPage<span class=\"token punctuation\">,<\/span>\n            <span class=\"token literal-property property\">pagecount<\/span><span class=\"token operator\">:<\/span> pageCount<span class=\"token punctuation\">,<\/span>\n            <span class=\"token literal-property property\">limit<\/span><span class=\"token operator\">:<\/span> pageSize<span class=\"token punctuation\">,<\/span>\n            <span class=\"token literal-property property\">total<\/span><span class=\"token operator\">:<\/span> rows<span class=\"token punctuation\">.<\/span>length<span class=\"token punctuation\">,<\/span>\n            <span class=\"token literal-property property\">list<\/span><span class=\"token operator\">:<\/span> rows<span class=\"token punctuation\">.<\/span><span class=\"token function\">map<\/span><span class=\"token punctuation\">(<\/span><span class=\"token parameter\">video<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span>\n                <span class=\"token literal-property property\">vod_id<\/span><span class=\"token operator\">:<\/span> video<span class=\"token punctuation\">.<\/span>id<span class=\"token punctuation\">,<\/span>\n                <span class=\"token literal-property property\">vod_name<\/span><span class=\"token operator\">:<\/span> video<span class=\"token punctuation\">.<\/span>title<span class=\"token punctuation\">,<\/span>\n                <span class=\"token literal-property property\">vod_pic<\/span><span class=\"token operator\">:<\/span> video<span class=\"token punctuation\">.<\/span>cover_url<span class=\"token punctuation\">,<\/span>\n                <span class=\"token literal-property property\">vod_content<\/span><span class=\"token operator\">:<\/span> video<span class=\"token punctuation\">.<\/span>description<span class=\"token punctuation\">,<\/span>\n                <span class=\"token literal-property property\">vod_year<\/span><span class=\"token operator\">:<\/span> video<span class=\"token punctuation\">.<\/span>year<span class=\"token punctuation\">,<\/span>\n                <span class=\"token literal-property property\">vod_area<\/span><span class=\"token operator\">:<\/span> video<span class=\"token punctuation\">.<\/span>region<span class=\"token punctuation\">,<\/span>\n                <span class=\"token literal-property property\">vod_actor<\/span><span class=\"token operator\">:<\/span> video<span class=\"token punctuation\">.<\/span>actors<span class=\"token punctuation\">,<\/span>\n                <span class=\"token literal-property property\">vod_director<\/span><span class=\"token operator\">:<\/span> video<span class=\"token punctuation\">.<\/span>director<span class=\"token punctuation\">,<\/span>\n                <span class=\"token literal-property property\">vod_url<\/span><span class=\"token operator\">:<\/span> <span class=\"token function\">formatPlayUrl<\/span><span class=\"token punctuation\">(<\/span>video<span class=\"token punctuation\">.<\/span>play_urls<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span>\n                <span class=\"token literal-property property\">vod_time<\/span><span class=\"token operator\">:<\/span> video<span class=\"token punctuation\">.<\/span>update_time<span class=\"token punctuation\">.<\/span><span class=\"token function\">toISOString<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">replace<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'T'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">' '<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">substring<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">19<\/span><span class=\"token punctuation\">)<\/span>\n            <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n        <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">;<\/span>\n\n        <span class=\"token comment\">\/\/ \u8bbe\u7f6e\u54cd\u5e94\u5934<\/span>\n        res<span class=\"token punctuation\">.<\/span><span class=\"token function\">set<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span>\n            <span class=\"token string-property property\">'Content-Type'<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'application\/json; charset=utf-8'<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token string-property property\">'Access-Control-Allow-Origin'<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'*'<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token string-property property\">'Cache-Control'<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'public, max-age=300'<\/span>\n        <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n        res<span class=\"token punctuation\">.<\/span><span class=\"token function\">json<\/span><span class=\"token punctuation\">(<\/span>result<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n    <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">catch<\/span> <span class=\"token punctuation\">(<\/span>error<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        console<span class=\"token punctuation\">.<\/span><span class=\"token function\">error<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'\u63a5\u53e3\u9519\u8bef:'<\/span><span class=\"token punctuation\">,<\/span> error<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        res<span class=\"token punctuation\">.<\/span><span class=\"token function\">status<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">500<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">json<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span>\n            <span class=\"token literal-property property\">code<\/span><span class=\"token operator\">:<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token literal-property property\">msg<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'\u670d\u52a1\u5668\u5185\u90e8\u9519\u8bef'<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token literal-property property\">error<\/span><span class=\"token operator\">:<\/span> error<span class=\"token punctuation\">.<\/span>message\n        <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n<span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">\/\/ \u5206\u7c7b\u63a5\u53e3<\/span>\napp<span class=\"token punctuation\">.<\/span><span class=\"token function\">get<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'\/api\/categories'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">async<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token parameter\">req<span class=\"token punctuation\">,<\/span> res<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token keyword\">try<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token keyword\">const<\/span> <span class=\"token punctuation\">[<\/span>rows<span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token keyword\">await<\/span> pool<span class=\"token punctuation\">.<\/span><span class=\"token function\">execute<\/span><span class=\"token punctuation\">(<\/span>\n            <span class=\"token string\">'SELECT id, name, parent_id FROM categories WHERE status = 1 ORDER BY sort_order'<\/span>\n        <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n        <span class=\"token keyword\">const<\/span> result <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">{<\/span>\n            <span class=\"token literal-property property\">code<\/span><span class=\"token operator\">:<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token literal-property property\">msg<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'success'<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token keyword\">class<\/span><span class=\"token operator\">:<\/span> rows<span class=\"token punctuation\">.<\/span><span class=\"token function\">map<\/span><span class=\"token punctuation\">(<\/span><span class=\"token parameter\">cat<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span>\n                <span class=\"token literal-property property\">type_id<\/span><span class=\"token operator\">:<\/span> cat<span class=\"token punctuation\">.<\/span>id<span class=\"token punctuation\">,<\/span>\n                <span class=\"token literal-property property\">type_name<\/span><span class=\"token operator\">:<\/span> cat<span class=\"token punctuation\">.<\/span>name<span class=\"token punctuation\">,<\/span>\n                <span class=\"token literal-property property\">type_pid<\/span><span class=\"token operator\">:<\/span> cat<span class=\"token punctuation\">.<\/span>parent_id <span class=\"token operator\">||<\/span> <span class=\"token number\">0<\/span>\n            <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span>\n        <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">;<\/span>\n\n        res<span class=\"token punctuation\">.<\/span><span class=\"token function\">json<\/span><span class=\"token punctuation\">(<\/span>result<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">catch<\/span> <span class=\"token punctuation\">(<\/span>error<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        console<span class=\"token punctuation\">.<\/span><span class=\"token function\">error<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'\u5206\u7c7b\u63a5\u53e3\u9519\u8bef:'<\/span><span class=\"token punctuation\">,<\/span> error<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        res<span class=\"token punctuation\">.<\/span><span class=\"token function\">status<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">500<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">json<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span>\n            <span class=\"token literal-property property\">code<\/span><span class=\"token operator\">:<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token literal-property property\">msg<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'\u83b7\u53d6\u5206\u7c7b\u5931\u8d25'<\/span>\n        <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n<span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">\/\/ \u64ad\u653e\u5730\u5740\u683c\u5f0f\u5316\u51fd\u6570<\/span>\n<span class=\"token keyword\">function<\/span> <span class=\"token function\">formatPlayUrl<\/span><span class=\"token punctuation\">(<\/span><span class=\"token parameter\">playUrls<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token keyword\">try<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token keyword\">const<\/span> urls <span class=\"token operator\">=<\/span> <span class=\"token constant\">JSON<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">parse<\/span><span class=\"token punctuation\">(<\/span>playUrls<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword\">return<\/span> urls<span class=\"token punctuation\">.<\/span><span class=\"token function\">map<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">(<\/span><span class=\"token parameter\">urlInfo<span class=\"token punctuation\">,<\/span> index<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">=&gt;<\/span> \n            <span class=\"token template-string\"><span class=\"token template-punctuation string\">`<\/span><span class=\"token string\">\u7b2c<\/span><span class=\"token interpolation\"><span class=\"token interpolation-punctuation punctuation\">${<\/span>index <span class=\"token operator\">+<\/span> <span class=\"token number\">1<\/span><span class=\"token interpolation-punctuation punctuation\">}<\/span><\/span><span class=\"token string\">\u96c6$<\/span><span class=\"token interpolation\"><span class=\"token interpolation-punctuation punctuation\">${<\/span>urlInfo<span class=\"token punctuation\">.<\/span>url<span class=\"token interpolation-punctuation punctuation\">}<\/span><\/span><span class=\"token template-punctuation string\">`<\/span><\/span>\n        <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">join<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'#'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span> <span class=\"token keyword\">catch<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token keyword\">return<\/span> <span class=\"token string\">''<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n<span class=\"token punctuation\">}<\/span>\n\n<span class=\"token comment\">\/\/ \u542f\u52a8\u670d\u52a1\u5668<\/span>\napp<span class=\"token punctuation\">.<\/span><span class=\"token function\">listen<\/span><span class=\"token punctuation\">(<\/span>port<span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token punctuation\">{<\/span>\n    console<span class=\"token punctuation\">.<\/span><span class=\"token function\">log<\/span><span class=\"token punctuation\">(<\/span><span class=\"token template-string\"><span class=\"token template-punctuation string\">`<\/span><span class=\"token string\">\u91c7\u96c6\u63a5\u53e3\u670d\u52a1\u8fd0\u884c\u5728 http:\/\/localhost:<\/span><span class=\"token interpolation\"><span class=\"token interpolation-punctuation punctuation\">${<\/span>port<span class=\"token interpolation-punctuation punctuation\">}<\/span><\/span><span class=\"token template-punctuation string\">`<\/span><\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    console<span class=\"token punctuation\">.<\/span><span class=\"token function\">log<\/span><span class=\"token punctuation\">(<\/span><span class=\"token template-string\"><span class=\"token template-punctuation string\">`<\/span><span class=\"token string\">\u63a5\u53e3\u5730\u5740: http:\/\/localhost:<\/span><span class=\"token interpolation\"><span class=\"token interpolation-punctuation punctuation\">${<\/span>port<span class=\"token interpolation-punctuation punctuation\">}<\/span><\/span><span class=\"token string\">\/api\/videos<\/span><span class=\"token template-punctuation string\">`<\/span><\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    console<span class=\"token punctuation\">.<\/span><span class=\"token function\">log<\/span><span class=\"token punctuation\">(<\/span><span class=\"token template-string\"><span class=\"token template-punctuation string\">`<\/span><span class=\"token string\">\u5206\u7c7b\u63a5\u53e3: http:\/\/localhost:<\/span><span class=\"token interpolation\"><span class=\"token interpolation-punctuation punctuation\">${<\/span>port<span class=\"token interpolation-punctuation punctuation\">}<\/span><\/span><span class=\"token string\">\/api\/categories<\/span><span class=\"token template-punctuation string\">`<\/span><\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/pre>\n<\/div>\n<h2>\u63a5\u53e3\u4f18\u5316\u4e0e\u589e\u5f3a<\/h2>\n<h3>\u6027\u80fd\u4f18\u5316\u7b56\u7565<\/h3>\n<h4>\u6570\u636e\u5e93\u67e5\u8be2\u4f18\u5316<\/h4>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">sql<\/span><\/div>\n<div class=\"d2a24f03 _246a029\">\n<div class=\"efa13877\">\n<div class=\"ds-focus-ring\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre><span class=\"token comment\">-- \u521b\u5efa\u4f18\u5316\u7d22\u5f15<\/span>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_videos_status <span class=\"token keyword\">ON<\/span> videos<span class=\"token punctuation\">(<\/span><span class=\"token keyword\">status<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_videos_update <span class=\"token keyword\">ON<\/span> videos<span class=\"token punctuation\">(<\/span>update_time<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_videos_category <span class=\"token keyword\">ON<\/span> videos<span class=\"token punctuation\">(<\/span>category_id<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">INDEX<\/span> idx_videos_composite <span class=\"token keyword\">ON<\/span> videos<span class=\"token punctuation\">(<\/span><span class=\"token keyword\">status<\/span><span class=\"token punctuation\">,<\/span> category_id<span class=\"token punctuation\">,<\/span> update_time<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">-- \u4f7f\u7528\u8986\u76d6\u7d22\u5f15<\/span>\n<span class=\"token keyword\">EXPLAIN<\/span> <span class=\"token keyword\">SELECT<\/span> id<span class=\"token punctuation\">,<\/span> title<span class=\"token punctuation\">,<\/span> cover_url <span class=\"token keyword\">FROM<\/span> videos \n<span class=\"token keyword\">WHERE<\/span> <span class=\"token keyword\">status<\/span> <span class=\"token operator\">=<\/span> <span class=\"token number\">1<\/span> <span class=\"token operator\">AND<\/span> category_id <span class=\"token operator\">=<\/span> <span class=\"token number\">5<\/span> \n<span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> update_time <span class=\"token keyword\">DESC<\/span> <span class=\"token keyword\">LIMIT<\/span> <span class=\"token number\">20<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token comment\">-- \u5b9a\u671f\u4f18\u5316\u8868<\/span>\n<span class=\"token keyword\">OPTIMIZE<\/span> <span class=\"token keyword\">TABLE<\/span> videos<span class=\"token punctuation\">;<\/span>\n<span class=\"token keyword\">ANALYZE<\/span> <span class=\"token keyword\">TABLE<\/span> videos<span class=\"token punctuation\">;<\/span><\/pre>\n<\/div>\n<h4>\u7f13\u5b58\u7b56\u7565\u5b9e\u73b0<\/h4>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">php<\/span><\/div>\n<div class=\"d2a24f03 _246a029\">\n<div class=\"efa13877\">\n<div class=\"ds-focus-ring\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre><span class=\"token php language-php\"><span class=\"token delimiter important\">&lt;?php<\/span>\n<span class=\"token comment\">\/\/ \u5e26\u7f13\u5b58\u7684\u63a5\u53e3<\/span>\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name-definition class-name\">CachedVideoAPI<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token keyword\">private<\/span> <span class=\"token variable\">$cache_dir<\/span> <span class=\"token operator\">=<\/span> <span class=\"token constant\">__DIR__<\/span> <span class=\"token operator\">.<\/span> <span class=\"token string single-quoted-string\">'\/cache\/'<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token keyword\">private<\/span> <span class=\"token variable\">$cache_time<\/span> <span class=\"token operator\">=<\/span> <span class=\"token number\">300<\/span><span class=\"token punctuation\">;<\/span> <span class=\"token comment\">\/\/ 5\u5206\u949f<\/span>\n    \n    <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">get_videos<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$params<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token variable\">$cache_key<\/span> <span class=\"token operator\">=<\/span> <span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">generate_cache_key<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$params<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token variable\">$cache_file<\/span> <span class=\"token operator\">=<\/span> <span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token property\">cache_dir<\/span> <span class=\"token operator\">.<\/span> <span class=\"token variable\">$cache_key<\/span> <span class=\"token operator\">.<\/span> <span class=\"token string single-quoted-string\">'.json'<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token comment\">\/\/ \u68c0\u67e5\u7f13\u5b58<\/span>\n        <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token function\">file_exists<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$cache_file<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&amp;&amp;<\/span> \n            <span class=\"token punctuation\">(<\/span><span class=\"token function\">time<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">-<\/span> <span class=\"token function\">filemtime<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$cache_file<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">&lt;<\/span> <span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token property\">cache_time<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n            <span class=\"token keyword\">return<\/span> <span class=\"token function\">json_decode<\/span><span class=\"token punctuation\">(<\/span><span class=\"token function\">file_get_contents<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$cache_file<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token constant boolean\">true<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token punctuation\">}<\/span>\n        \n        <span class=\"token comment\">\/\/ \u67e5\u8be2\u6570\u636e\u5e93<\/span>\n        <span class=\"token variable\">$data<\/span> <span class=\"token operator\">=<\/span> <span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">query_database<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$params<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token comment\">\/\/ \u5199\u5165\u7f13\u5b58<\/span>\n        <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token operator\">!<\/span><span class=\"token function\">is_dir<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token property\">cache_dir<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n            <span class=\"token function\">mkdir<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token property\">cache_dir<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">0755<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token constant boolean\">true<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token punctuation\">}<\/span>\n        <span class=\"token function\">file_put_contents<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$cache_file<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token function\">json_encode<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$data<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token keyword\">return<\/span> <span class=\"token variable\">$data<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n    \n    <span class=\"token keyword\">private<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">generate_cache_key<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$params<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token function\">ksort<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$params<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword\">return<\/span> <span class=\"token function\">md5<\/span><span class=\"token punctuation\">(<\/span><span class=\"token function\">http_build_query<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$params<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n    \n    <span class=\"token keyword\">private<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">query_database<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$params<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token comment\">\/\/ \u6570\u636e\u5e93\u67e5\u8be2\u903b\u8f91<\/span>\n        <span class=\"token comment\">\/\/ ...<\/span>\n        <span class=\"token keyword\">return<\/span> <span class=\"token variable\">$result<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n<span class=\"token punctuation\">}<\/span>\n<span class=\"token delimiter important\">?&gt;<\/span><\/span><\/pre>\n<\/div>\n<h3>\u5b89\u5168\u589e\u5f3a\u63aa\u65bd<\/h3>\n<h4>API\u5bc6\u94a5\u9a8c\u8bc1<\/h4>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">php<\/span><\/div>\n<div class=\"d2a24f03 _246a029\">\n<div class=\"efa13877\">\n<div class=\"ds-focus-ring\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre><span class=\"token php language-php\"><span class=\"token delimiter important\">&lt;?php<\/span>\n<span class=\"token comment\">\/\/ API\u5bc6\u94a5\u9a8c\u8bc1<\/span>\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name-definition class-name\">SecureVideoAPI<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token keyword\">private<\/span> <span class=\"token variable\">$valid_keys<\/span> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>\n        <span class=\"token string single-quoted-string\">'app_key_1'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'rate_limit'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token number\">100<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string single-quoted-string\">'last_request'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">,<\/span>\n        <span class=\"token string single-quoted-string\">'app_key_2'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'rate_limit'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token number\">50<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string single-quoted-string\">'last_request'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token number\">0<\/span><span class=\"token punctuation\">]<\/span>\n    <span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n    \n    <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">handle_request<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token comment\">\/\/ \u9a8c\u8bc1API\u5bc6\u94a5<\/span>\n        <span class=\"token variable\">$api_key<\/span> <span class=\"token operator\">=<\/span> <span class=\"token variable\">$_GET<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'api_key'<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">??<\/span> <span class=\"token string single-quoted-string\">''<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token operator\">!<\/span><span class=\"token keyword\">isset<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token property\">valid_keys<\/span><span class=\"token punctuation\">[<\/span><span class=\"token variable\">$api_key<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n            <span class=\"token function\">http_response_code<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">401<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token keyword\">die<\/span><span class=\"token punctuation\">(<\/span><span class=\"token function\">json_encode<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'error'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token string single-quoted-string\">'\u65e0\u6548\u7684API\u5bc6\u94a5'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token punctuation\">}<\/span>\n        \n        <span class=\"token comment\">\/\/ \u9891\u7387\u9650\u5236\u68c0\u67e5<\/span>\n        <span class=\"token variable\">$client_info<\/span> <span class=\"token operator\">=<\/span> <span class=\"token operator\">&amp;<\/span><span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token property\">valid_keys<\/span><span class=\"token punctuation\">[<\/span><span class=\"token variable\">$api_key<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token variable\">$current_time<\/span> <span class=\"token operator\">=<\/span> <span class=\"token function\">time<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token variable\">$current_time<\/span> <span class=\"token operator\">-<\/span> <span class=\"token variable\">$client_info<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'last_request'<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">&lt;<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n            <span class=\"token function\">http_response_code<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">429<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n            <span class=\"token keyword\">die<\/span><span class=\"token punctuation\">(<\/span><span class=\"token function\">json_encode<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'error'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token string single-quoted-string\">'\u8bf7\u6c42\u8fc7\u4e8e\u9891\u7e41'<\/span><span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token punctuation\">}<\/span>\n        \n        <span class=\"token variable\">$client_info<\/span><span class=\"token punctuation\">[<\/span><span class=\"token string single-quoted-string\">'last_request'<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token variable\">$current_time<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token comment\">\/\/ \u7ee7\u7eed\u5904\u7406\u8bf7\u6c42<\/span>\n        <span class=\"token comment\">\/\/ ...<\/span>\n    <span class=\"token punctuation\">}<\/span>\n    \n    <span class=\"token comment\">\/\/ \u751f\u6210\u65b0\u7684API\u5bc6\u94a5<\/span>\n    <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">generate_api_key<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$name<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$rate_limit<\/span> <span class=\"token operator\">=<\/span> <span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token variable\">$key<\/span> <span class=\"token operator\">=<\/span> <span class=\"token string single-quoted-string\">'app_key_'<\/span> <span class=\"token operator\">.<\/span> <span class=\"token function\">bin2hex<\/span><span class=\"token punctuation\">(<\/span><span class=\"token function\">random_bytes<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">16<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token property\">valid_keys<\/span><span class=\"token punctuation\">[<\/span><span class=\"token variable\">$key<\/span><span class=\"token punctuation\">]<\/span> <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">[<\/span>\n            <span class=\"token string single-quoted-string\">'name'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$name<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token string single-quoted-string\">'rate_limit'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$rate_limit<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token string single-quoted-string\">'created_at'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token function\">time<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token string single-quoted-string\">'last_request'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token number\">0<\/span>\n        <span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token comment\">\/\/ \u4fdd\u5b58\u5230\u6570\u636e\u5e93\u6216\u6587\u4ef6<\/span>\n        <span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">save_api_keys<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token keyword\">return<\/span> <span class=\"token variable\">$key<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n<span class=\"token punctuation\">}<\/span>\n<span class=\"token delimiter important\">?&gt;<\/span><\/span><\/pre>\n<\/div>\n<h4>\u8bf7\u6c42\u7b7e\u540d\u9a8c\u8bc1<\/h4>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">javascript<\/span><\/div>\n<div class=\"d2a24f03 _246a029\">\n<div class=\"efa13877\">\n<div class=\"ds-focus-ring\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre><span class=\"token comment\">\/\/ \u8bf7\u6c42\u7b7e\u540d\u9a8c\u8bc1<\/span>\n<span class=\"token keyword\">const<\/span> crypto <span class=\"token operator\">=<\/span> <span class=\"token function\">require<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'crypto'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name\">RequestSigner<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token function\">constructor<\/span><span class=\"token punctuation\">(<\/span><span class=\"token parameter\">secretKey<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>secretKey <span class=\"token operator\">=<\/span> secretKey<span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n    \n    <span class=\"token function\">generateSignature<\/span><span class=\"token punctuation\">(<\/span><span class=\"token parameter\">params<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token comment\">\/\/ \u6392\u5e8f\u53c2\u6570<\/span>\n        <span class=\"token keyword\">const<\/span> sortedParams <span class=\"token operator\">=<\/span> Object<span class=\"token punctuation\">.<\/span><span class=\"token function\">keys<\/span><span class=\"token punctuation\">(<\/span>params<span class=\"token punctuation\">)<\/span>\n            <span class=\"token punctuation\">.<\/span><span class=\"token function\">sort<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n            <span class=\"token punctuation\">.<\/span><span class=\"token function\">map<\/span><span class=\"token punctuation\">(<\/span><span class=\"token parameter\">key<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token template-string\"><span class=\"token template-punctuation string\">`<\/span><span class=\"token interpolation\"><span class=\"token interpolation-punctuation punctuation\">${<\/span>key<span class=\"token interpolation-punctuation punctuation\">}<\/span><\/span><span class=\"token string\">=<\/span><span class=\"token interpolation\"><span class=\"token interpolation-punctuation punctuation\">${<\/span>params<span class=\"token punctuation\">[<\/span>key<span class=\"token punctuation\">]<\/span><span class=\"token interpolation-punctuation punctuation\">}<\/span><\/span><span class=\"token template-punctuation string\">`<\/span><\/span><span class=\"token punctuation\">)<\/span>\n            <span class=\"token punctuation\">.<\/span><span class=\"token function\">join<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'&amp;'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token comment\">\/\/ \u751f\u6210\u7b7e\u540d<\/span>\n        <span class=\"token keyword\">return<\/span> crypto\n            <span class=\"token punctuation\">.<\/span><span class=\"token function\">createHmac<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'sha256'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span>secretKey<span class=\"token punctuation\">)<\/span>\n            <span class=\"token punctuation\">.<\/span><span class=\"token function\">update<\/span><span class=\"token punctuation\">(<\/span>sortedParams<span class=\"token punctuation\">)<\/span>\n            <span class=\"token punctuation\">.<\/span><span class=\"token function\">digest<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'hex'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n    \n    <span class=\"token function\">verifyRequest<\/span><span class=\"token punctuation\">(<\/span><span class=\"token parameter\">req<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token keyword\">const<\/span> params <span class=\"token operator\">=<\/span> <span class=\"token punctuation\">{<\/span> <span class=\"token operator\">...<\/span>req<span class=\"token punctuation\">.<\/span>query <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token keyword\">const<\/span> clientSign <span class=\"token operator\">=<\/span> params<span class=\"token punctuation\">.<\/span>sign<span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token comment\">\/\/ \u79fb\u9664\u7b7e\u540d\u53c2\u6570<\/span>\n        <span class=\"token keyword\">delete<\/span> params<span class=\"token punctuation\">.<\/span>sign<span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token comment\">\/\/ \u8ba1\u7b97\u670d\u52a1\u5668\u7b7e\u540d<\/span>\n        <span class=\"token keyword\">const<\/span> serverSign <span class=\"token operator\">=<\/span> <span class=\"token keyword\">this<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">generateSignature<\/span><span class=\"token punctuation\">(<\/span>params<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token comment\">\/\/ \u6bd4\u8f83\u7b7e\u540d<\/span>\n        <span class=\"token keyword\">return<\/span> crypto<span class=\"token punctuation\">.<\/span><span class=\"token function\">timingSafeEqual<\/span><span class=\"token punctuation\">(<\/span>\n            Buffer<span class=\"token punctuation\">.<\/span><span class=\"token function\">from<\/span><span class=\"token punctuation\">(<\/span>clientSign<span class=\"token punctuation\">,<\/span> <span class=\"token string\">'hex'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span>\n            Buffer<span class=\"token punctuation\">.<\/span><span class=\"token function\">from<\/span><span class=\"token punctuation\">(<\/span>serverSign<span class=\"token punctuation\">,<\/span> <span class=\"token string\">'hex'<\/span><span class=\"token punctuation\">)<\/span>\n        <span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n<span class=\"token punctuation\">}<\/span>\n\n<span class=\"token comment\">\/\/ \u4f7f\u7528\u793a\u4f8b<\/span>\n<span class=\"token keyword\">const<\/span> signer <span class=\"token operator\">=<\/span> <span class=\"token keyword\">new<\/span> <span class=\"token class-name\">RequestSigner<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'your-secret-key'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n\napp<span class=\"token punctuation\">.<\/span><span class=\"token function\">get<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">'\/api\/secure\/videos'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token parameter\">req<span class=\"token punctuation\">,<\/span> res<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token operator\">!<\/span>signer<span class=\"token punctuation\">.<\/span><span class=\"token function\">verifyRequest<\/span><span class=\"token punctuation\">(<\/span>req<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token keyword\">return<\/span> res<span class=\"token punctuation\">.<\/span><span class=\"token function\">status<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">403<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">json<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">{<\/span> <span class=\"token literal-property property\">error<\/span><span class=\"token operator\">:<\/span> <span class=\"token string\">'\u7b7e\u540d\u9a8c\u8bc1\u5931\u8d25'<\/span> <span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n    \n    <span class=\"token comment\">\/\/ \u5904\u7406\u8bf7\u6c42...<\/span>\n<span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/pre>\n<\/div>\n<h2>\u6545\u969c\u6392\u67e5\u4e0e\u8c03\u8bd5<\/h2>\n<h3>\u5e38\u89c1\u95ee\u9898\u89e3\u51b3\u65b9\u6848<\/h3>\n<h4>\u95ee\u9898\u4e00\uff1a\u91c7\u96c6\u65e0\u6570\u636e<\/h4>\n<p class=\"ds-markdown-paragraph\"><strong>\u6392\u67e5\u6b65\u9aa4\uff1a<\/strong><\/p>\n<ol start=\"1\">\n<li>\n<p class=\"ds-markdown-paragraph\">\u68c0\u67e5\u63a5\u53e3\u5730\u5740\u662f\u5426\u6b63\u786e<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u624b\u52a8\u8bbf\u95ee\u63a5\u53e3URL\u6d4b\u8bd5<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u67e5\u770b\u82f9\u679cCMS\u91c7\u96c6\u65e5\u5fd7<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u68c0\u67e5\u5206\u7c7b\u7ed1\u5b9a\u662f\u5426\u6b63\u786e<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u9a8c\u8bc1\u63a5\u53e3\u8fd4\u56de\u6570\u636e\u683c\u5f0f<\/p>\n<\/li>\n<\/ol>\n<h4>\u95ee\u9898\u4e8c\uff1a\u91c7\u96c6\u901f\u5ea6\u6162<\/h4>\n<p class=\"ds-markdown-paragraph\"><strong>\u4f18\u5316\u65b9\u6848\uff1a<\/strong><\/p>\n<ol start=\"1\">\n<li>\n<p class=\"ds-markdown-paragraph\">\u51cf\u5c11\u5355\u6b21\u91c7\u96c6\u6570\u91cf<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u589e\u52a0\u91c7\u96c6\u95f4\u9694\u65f6\u95f4<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u4f18\u5316\u670d\u52a1\u5668\u7f51\u7edc\u8fde\u63a5<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u4f7f\u7528CDN\u52a0\u901f\u63a5\u53e3\u8bbf\u95ee<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u5347\u7ea7\u670d\u52a1\u5668\u914d\u7f6e<\/p>\n<\/li>\n<\/ol>\n<h4>\u95ee\u9898\u4e09\uff1a\u6570\u636e\u4e0d\u5b8c\u6574<\/h4>\n<p class=\"ds-markdown-paragraph\"><strong>\u89e3\u51b3\u65b9\u6cd5\uff1a<\/strong><\/p>\n<ol start=\"1\">\n<li>\n<p class=\"ds-markdown-paragraph\">\u68c0\u67e5\u63a5\u53e3\u6570\u636e\u5b57\u6bb5\u6620\u5c04<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u9a8c\u8bc1\u6570\u636e\u6e05\u6d17\u89c4\u5219<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u67e5\u770b\u6570\u636e\u5e93\u5b57\u7b26\u96c6\u8bbe\u7f6e<\/p>\n<\/li>\n<li>\n<p class=\"ds-markdown-paragraph\">\u8c03\u8bd5\u6570\u636e\u5904\u7406\u903b\u8f91<\/p>\n<\/li>\n<\/ol>\n<h3>\u8c03\u8bd5\u5de5\u5177\u4e0e\u6280\u5de7<\/h3>\n<h4>\u65e5\u5fd7\u8bb0\u5f55\u7cfb\u7edf<\/h4>\n<div class=\"md-code-block md-code-block-light\">\n<div class=\"md-code-block-banner-wrap\">\n<div class=\"md-code-block-banner md-code-block-banner-lite\">\n<div class=\"_121d384\">\n<div class=\"d2a24f03\"><span class=\"d813de27\">php<\/span><\/div>\n<\/div>\n<\/div>\n<\/div>\n<pre><span class=\"token php language-php\"><span class=\"token delimiter important\">&lt;?php<\/span>\n<span class=\"token keyword\">class<\/span> <span class=\"token class-name-definition class-name\">CollectionLogger<\/span> <span class=\"token punctuation\">{<\/span>\n    <span class=\"token keyword\">private<\/span> <span class=\"token variable\">$log_file<\/span><span class=\"token punctuation\">;<\/span>\n    \n    <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">__construct<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$log_file<\/span> <span class=\"token operator\">=<\/span> <span class=\"token string single-quoted-string\">'collection.log'<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token property\">log_file<\/span> <span class=\"token operator\">=<\/span> <span class=\"token constant\">__DIR__<\/span> <span class=\"token operator\">.<\/span> <span class=\"token string single-quoted-string\">'\/logs\/'<\/span> <span class=\"token operator\">.<\/span> <span class=\"token variable\">$log_file<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">ensure_log_dir<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n    \n    <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">log<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$message<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$level<\/span> <span class=\"token operator\">=<\/span> <span class=\"token string single-quoted-string\">'INFO'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$data<\/span> <span class=\"token operator\">=<\/span> <span class=\"token constant\">null<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token variable\">$timestamp<\/span> <span class=\"token operator\">=<\/span> <span class=\"token function\">date<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'Y-m-d H:i:s'<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token variable\">$log_entry<\/span> <span class=\"token operator\">=<\/span> <span class=\"token string double-quoted-string\">\"[<span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token variable\">$timestamp<\/span><span class=\"token punctuation\">}<\/span><\/span>] [<span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token variable\">$level<\/span><span class=\"token punctuation\">}<\/span><\/span>] <span class=\"token interpolation\"><span class=\"token punctuation\">{<\/span><span class=\"token variable\">$message<\/span><span class=\"token punctuation\">}<\/span><\/span>\"<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token keyword\">if<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token variable\">$data<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n            <span class=\"token variable\">$log_entry<\/span> <span class=\"token operator\">.=<\/span> <span class=\"token constant\">PHP_EOL<\/span> <span class=\"token operator\">.<\/span> <span class=\"token function\">json_encode<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$data<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token class-name\">JSON_PRETTY_PRINT<\/span> <span class=\"token operator\">|<\/span> <span class=\"token class-name\">JSON_UNESCAPED_UNICODE<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n        <span class=\"token punctuation\">}<\/span>\n        \n        <span class=\"token variable\">$log_entry<\/span> <span class=\"token operator\">.=<\/span> <span class=\"token constant\">PHP_EOL<\/span> <span class=\"token operator\">.<\/span> <span class=\"token function\">str_repeat<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string single-quoted-string\">'-'<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">80<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token operator\">.<\/span> <span class=\"token constant\">PHP_EOL<\/span><span class=\"token punctuation\">;<\/span>\n        \n        <span class=\"token function\">file_put_contents<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token property\">log_file<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$log_entry<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token constant\">FILE_APPEND<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span>\n    <span class=\"token punctuation\">}<\/span>\n    \n    <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">function<\/span> <span class=\"token function-definition function\">log_request<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$url<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$params<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$response<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token variable\">$status<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span>\n        <span class=\"token variable\">$this<\/span><span class=\"token operator\">-&gt;<\/span><span class=\"token function\">log<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string double-quoted-string\">\"\u63a5\u53e3\u8bf7\u6c42\"<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string double-quoted-string\">\"REQUEST\"<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token punctuation\">[<\/span>\n            <span class=\"token string single-quoted-string\">'url'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$url<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token string single-quoted-string\">'params'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$params<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token string single-quoted-string\">'status'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token variable\">$status<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token string single-quoted-string\">'response_length'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token function\">strlen<\/span><span class=\"token punctuation\">(<\/span><span class=\"token variable\">$response<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span>\n            <span class=\"token string single-quoted-string\">'timestamp'<\/span> <span class=\"token operator\">=&gt;<\/span> <span class=\"token function\">time<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span>\n        <span class=\"token punctuation\">]<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;\n\n\n\n<\/span><\/span><\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u5f71\u89c6\u91c7\u96c6\u63a5\u53e3\u662f\u82f9\u679cCMS\u81ea\u52a8\u91c7\u96c6\u529f\u80fd\u7684\u6838\u5fc3\uff0c\u6b63\u786e\u83b7\u53d6\u548c\u914d\u7f6e\u63a5\u53e3\u76f4\u63a5\u5173\u7cfb\u5230\u91c7\u96c6\u6548\u679c\u3002\u672c\u6587\u5c06\u4ece\u63a5\u53e3\u83b7\u53d6\u3001\u914d\u7f6e\u5230\u4f18\u5316\uff0c\u63d0\u4f9b\u5b8c\u6574\u7684\u82f9\u679cCMS\u5f71\u89c6\u91c7\u96c6\u5bf9\u63a5\u5b9e\u64cd\u6559\u7a0b\uff0c\u5e2e\u52a9\u60a8\u5efa\u7acb\u7a33\u5b9a\u9ad8\u6548\u7684\u91c7\u96c6\u7cfb\u7edf\u3002 \u5f71\u89c6\u91c7\u96c6\u63a5\u53e3\u57fa\u7840\u8ba4\u77e5 \u63a5\u53e3\u7c7b\u578b\u4e0e\u5de5\u4f5c\u539f\u7406 \u4e3b\u8981\u63a5\u53e3\u683c\u5f0f XML\u63a5\u53e3\uff1a\u4f20\u7edf\u683c\u5f0f\uff0c\u7ed3\u6784\u6e05\u6670\uff0c\u517c\u5bb9\u6027\u597d xml &lt;video&gt; &lt;id&gt;12345&lt;\/id&gt; &lt;name&gt;\u7535\u5f71\u540d\u79f0&lt;\/name&gt; &lt;pic&gt;\u5c01\u9762\u5730\u5740&lt;\/pic&gt; &lt;url&gt;\u64ad\u653e\u5730\u5740<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[],"collection":[],"class_list":["post-5376","post","type-post","status-publish","format-standard","hentry","category-qtjc"],"_links":{"self":[{"href":"https:\/\/www.qqjishu.com\/index.php\/wp-json\/wp\/v2\/posts\/5376","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qqjishu.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qqjishu.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qqjishu.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qqjishu.com\/index.php\/wp-json\/wp\/v2\/comments?post=5376"}],"version-history":[{"count":0,"href":"https:\/\/www.qqjishu.com\/index.php\/wp-json\/wp\/v2\/posts\/5376\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.qqjishu.com\/index.php\/wp-json\/wp\/v2\/media?parent=5376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qqjishu.com\/index.php\/wp-json\/wp\/v2\/categories?post=5376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qqjishu.com\/index.php\/wp-json\/wp\/v2\/tags?post=5376"},{"taxonomy":"collection","embeddable":true,"href":"https:\/\/www.qqjishu.com\/index.php\/wp-json\/wp\/v2\/collection?post=5376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}