{"id":30759,"date":"2024-11-25T08:39:00","date_gmt":"2024-11-25T00:39:00","guid":{"rendered":"https:\/\/fwq.ai\/blog\/30759\/"},"modified":"2024-11-25T08:39:00","modified_gmt":"2024-11-25T00:39:00","slug":"%e5%a6%82%e4%bd%95%e4%bd%bf%e7%94%a8wordpress%e9%92%a9%e5%ad%90%e5%87%bd%e6%95%b0%e5%9c%a8%e5%8f%91%e8%a1%a8%e6%96%87%e7%ab%a0%e7%9a%84%e5%90%8c%e6%97%b6%e6%b7%bb%e5%8a%a0%e4%b8%80%e6%9d%a1%e8%ae%b0","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/30759\/","title":{"rendered":"\u5982\u4f55\u4f7f\u7528wordpress\u94a9\u5b50\u51fd\u6570\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55"},"content":{"rendered":"

\"\u5982\u4f55\u4f7f\u7528wordpress\u94a9\u5b50\u51fd\u6570\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55\u63d2\u56fe\"<\/p>\n

\u5982\u4f55\u4f7f\u7528\u94a9\u5b50\u51fd\u6570\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55\uff1f<\/strong><\/p>\n

\u672c\u6587\u4e3a\u5927\u5bb6\u4ecb\u7ecd\u4e0b\u5982\u4f55\u4f7f\u7528wordpress\u7684\u94a9\u5b50\u51fd\u6570\uff0c\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55\u5230\u6295\u7968\u8868\uff0c\u4e0b\u9762\u662f\u5177\u4f53\u7684\u5b9e\u73b0\uff0c\u5927\u5bb6\u4e0d\u8981\u9519\u8fc7<\/p>\n

  \u63a8\u8350\uff1a\u300a\u300b<\/p>\n

\u6211\u8981\u5bf9\u6587\u7ae0\u8fdb\u884c\u6392\u5e8f\uff0c\u6309\u7167\u6295\u7968\u6570\u7684\u591a\u5c11\u6392\uff0c\u5df2\u7ecf\u6295\u7968\u7684\u90fd\u4f1a\u8bb0\u5f55\u6295\u7968\u6570\uff0c\u800c\u6ca1\u6709\u6295\u7968\u7684\u6587\u7ae0\u6ca1\u6709\u8bb0\u5f55\uff0c\u9ed8\u8ba4\u6295\u7968\u4e3a0\uff0c\u8fd9\u65f6\u6392\u5e8f\u5c31\u6709\u95ee\u9898\u4e86\uff0c\u5b83\u5148\u628a\u6709\u8bb0\u5f55\u7684\u6587\u7ae0\u8fdb\u884c\u6392\u5e8f\uff0c\u56e0\u4e3a\u6295\u7968\u53ef\u80fd\u662f\u8d1f\u6570\uff0c\u6392\u5b8c\u4e86\u8d1f\u6570\u518d\u6392\u5217\u6ca1\u6709\u6295\u7968\u8bb0\u5f55\u7684\u6587\u7ae0\uff0c\u8fd9\u4e2a\u65f6\u5019\u5c31\u4f1a\u51fa\u73b0\u6ca1\u6709\u6295\u7968\u7684\u6587\u7ae0\u4e5f\u5c31\u662f\u6295\u7968\u6570\u4e3a0\u7684\u6392\u5728\u8d1f\u6570\u7684\u540e\u9762\uff0c\u5982\u56fe\uff1a <\/p>\n

\"\u5982\u4f55\u4f7f\u7528wordpress\u94a9\u5b50\u51fd\u6570\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55\u63d2\u56fe1\"<\/p>\n

 \"\u5982\u4f55\u4f7f\u7528wordpress\u94a9\u5b50\u51fd\u6570\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55\u63d2\u56fe2\"<\/p>\n

 <\/p>\n

\u6295\u7968\u8bb0\u5f55\u8868 <\/p>\n

\u751f\u6210\u7684sql\u8bed\u53e5\uff1a<\/p>\n

SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_wti_like_post on wp_wti_like_post.post_id=wp_posts.ID WHERE 1=1 AND ( ( post_date_gmt &gt; \u20192013-11-16 12:17:03\u2032 ) ) AND wp_posts.post_type = \u2018post\u2019 AND (wp_posts.post_status = \u2018publish\u2019 OR wp_posts.post_status = \u2018private\u2019) ORDER BY wp_wti_like_post.value DESC,wp_posts.post_date DESC LIMIT 5, 5<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
sql\u8bed\u53e5\u5e94\u8be5\u600e\u6837\u5199\u5462\uff1f <\/p>\n
\u89e3\u51b3\u529e\u6cd5\uff1a <\/p>\n
\u4f7f\u7528wordpress\u7684\u94a9\u5b50\u51fd\u6570\uff0c\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55\u5230\u6295\u7968\u8868\u4e0d\u5c31\u53ef\u4ee5\u4e86\uff1f <\/p>\n
\u76f4\u63a5\u4e0a\u4ee3\u7801\uff1a <\/p>\n
\u4ee3\u7801\u5982\u4e0b:<\/p>\n
\/\/\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u63d2\u5165\u6570\u636e\u5230\u559c\u6b22\u8868\nfunction new_article($post_ID){ global $wpdb; $ip = WtiGetRealIpAddress(); $query = \"INSERT INTO {$wpdb-&gt;prefix}wti_like_post SET \"; $query .= \"post_id = '\" . $post_ID . \"', \"; $query .= \"value = '0', \"; $query .= \"date_time = '\" . date('Y-m-d H:i:s') . \"', \"; $query .= \"ip = '$ip'\"; $success = $wpdb-&gt;query($query); if($success){ return $post_ID; }}add_action('publish_post', 'new_article');<\/pre>\n
 \u767b\u5f55\u540e\u590d\u5236 <\/p>\n
\u628a\u8fd9\u6bb5\u4ee3\u7801\u653e\u5230\u4e3b\u9898function.php\u91cc\u9762\u3002<\/p>\n
\u4ee5\u4e0a\u5c31\u662f\u5982\u4f55\u4f7f\u7528\u94a9\u5b50\u51fd\u6570\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5982\u4f55\u4f7f\u7528\u94a9\u5b50\u51fd\u6570\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55\uff1f \u672c\u6587\u4e3a\u5927\u5bb6\u4ecb\u7ecd\u4e0b\u5982\u4f55\u4f7f\u7528wordpress\u7684\u94a9\u5b50\u51fd\u6570\uff0c\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55\u5230\u6295\u7968\u8868\uff0c\u4e0b\u9762\u662f\u5177\u4f53\u7684\u5b9e\u73b0\uff0c\u5927\u5bb6\u4e0d\u8981\u9519\u8fc7   \u63a8\u8350\uff1a\u300a\u300b \u6211\u8981\u5bf9\u6587\u7ae0\u8fdb\u884c\u6392\u5e8f\uff0c\u6309\u7167\u6295\u7968\u6570\u7684\u591a\u5c11\u6392\uff0c\u5df2\u7ecf\u6295\u7968\u7684\u90fd\u4f1a\u8bb0\u5f55\u6295\u7968\u6570\uff0c\u800c\u6ca1\u6709\u6295\u7968\u7684\u6587\u7ae0\u6ca1\u6709\u8bb0\u5f55\uff0c\u9ed8\u8ba4\u6295\u7968\u4e3a0\uff0c\u8fd9\u65f6\u6392\u5e8f\u5c31\u6709\u95ee\u9898\u4e86\uff0c\u5b83\u5148\u628a\u6709\u8bb0\u5f55\u7684\u6587\u7ae0\u8fdb\u884c\u6392\u5e8f\uff0c\u56e0\u4e3a\u6295\u7968\u53ef\u80fd\u662f\u8d1f\u6570\uff0c\u6392\u5b8c\u4e86\u8d1f\u6570\u518d\u6392\u5217\u6ca1\u6709\u6295\u7968\u8bb0\u5f55\u7684\u6587\u7ae0\uff0c\u8fd9\u4e2a\u65f6\u5019\u5c31\u4f1a\u51fa\u73b0\u6ca1\u6709\u6295\u7968\u7684\u6587\u7ae0\u4e5f\u5c31\u662f\u6295\u7968\u6570\u4e3a0\u7684\u6392\u5728\u8d1f\u6570\u7684\u540e\u9762\uff0c\u5982\u56fe\uff1a      \u6295\u7968\u8bb0\u5f55\u8868  \u751f\u6210\u7684sql\u8bed\u53e5\uff1a SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_wti_like_post on wp_wti_like_post.post_id=wp_posts.ID WHERE 1=1 AND ( ( post_date_gmt &gt; \u20192013-11-16 12:17:03\u2032 ) ) AND wp_posts.post_type = \u2018post\u2019 AND (wp_posts.post_status = \u2018publish\u2019 OR wp_posts.post_status = \u2018private\u2019) ORDER BY wp_wti_like_post.value DESC,wp_posts.post_date DESC LIMIT 5, 5 \u767b\u5f55\u540e\u590d\u5236 sql\u8bed\u53e5\u5e94\u8be5\u600e\u6837\u5199\u5462\uff1f  \u89e3\u51b3\u529e\u6cd5\uff1a  \u4f7f\u7528wordpress\u7684\u94a9\u5b50\u51fd\u6570\uff0c\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55\u5230\u6295\u7968\u8868\u4e0d\u5c31\u53ef\u4ee5\u4e86\uff1f  \u76f4\u63a5\u4e0a\u4ee3\u7801\uff1a  \u4ee3\u7801\u5982\u4e0b: \/\/\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u63d2\u5165\u6570\u636e\u5230\u559c\u6b22\u8868 function new_article($post_ID){ global $wpdb; $ip = WtiGetRealIpAddress(); $query = “INSERT INTO {$wpdb-&gt;prefix}wti_like_post SET “; $query .= “post_id = ‘” . $post_ID . “‘, “; $query .= “value = ‘0’, “; $query .= “date_time = ‘” . date(‘Y-m-d H:i:s’) . “‘, “; $query .= “ip = ‘$ip'”; $success = $wpdb-&gt;query($query); if($success){ return $post_ID; }}add_action(‘publish_post’, ‘new_article’); \u767b\u5f55\u540e\u590d\u5236 \u628a\u8fd9\u6bb5\u4ee3\u7801\u653e\u5230\u4e3b\u9898function.php\u91cc\u9762\u3002 \u4ee5\u4e0a\u5c31\u662f\u5982\u4f55\u4f7f\u7528\u94a9\u5b50\u51fd\u6570\u5728\u53d1\u8868\u6587\u7ae0\u7684\u540c\u65f6\u6dfb\u52a0\u4e00\u6761\u8bb0\u5f55\u7684\u8be6\u7ec6\u5185\u5bb9\uff0c\u66f4\u591a\u8bf7\u5173\u6ce8\u7c73\u4e91\u5176\u5b83\u76f8\u5173\u6587\u7ae0\uff01<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-30759","post","type-post","status-publish","format-standard","hentry","category-cms"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/30759","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=30759"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/30759\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=30759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=30759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=30759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}