{"id":54,"date":"2024-04-21T01:12:21","date_gmt":"2024-04-20T17:12:21","guid":{"rendered":"https:\/\/www.weigot.com\/?p=54"},"modified":"2024-04-21T01:12:21","modified_gmt":"2024-04-20T17:12:21","slug":"%e5%b9%bf%e5%91%8a%e5%86%85%e5%ae%b9%e5%ad%98%e5%82%a8%e5%9c%a8%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/www.weigot.com\/index.php\/2024\/04\/21\/%e5%b9%bf%e5%91%8a%e5%86%85%e5%ae%b9%e5%ad%98%e5%82%a8%e5%9c%a8%e6%95%b0%e6%8d%ae%e5%ba%93\/","title":{"rendered":"\u5e7f\u544a\u5185\u5bb9\u5b58\u50a8\u5728\u6570\u636e\u5e93"},"content":{"rendered":"\n

\u5982\u679c\u60a8\u5e0c\u671b\u5c06\u5e7f\u544a\u5185\u5bb9\u5b58\u50a8\u5728\u6570\u636e\u5e93\u4e2d,\u5e76\u81ea\u5df1\u5efa\u7acb\u8868\u548c\u5217,\u90a3\u4e48\u53ef\u4ee5\u91c7\u7528\u4ee5\u4e0b\u65b9\u6cd5:<\/p>\n\n\n\n

    \n
  1. \u521b\u5efa\u81ea\u5b9a\u4e49\u6570\u636e\u8868
    \u5728\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u4e00\u4e2a\u81ea\u5b9a\u4e49\u7684\u6570\u636e\u8868,\u7528\u4e8e\u5b58\u50a8\u624b\u673a\u7248\u548cPC\u7248\u7684\u5e7f\u544a\u5185\u5bb9\u3002\u4f8b\u5982:<\/li>\n<\/ol>\n\n\n\n
    CREATE TABLE `wp_ads` (\n  `id` int(11) NOT NULL AUTO_INCREMENT,\n  `mobile_ad` text DEFAULT NULL,\n  `pc_ad` text DEFAULT NULL,\n  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\n  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;<\/code><\/pre>\n\n\n\n
      \n
    1. \u5728\u4e3b\u9898\u7684 functions.php<\/code> \u6587\u4ef6\u4e2d,\u6dfb\u52a0\u4ee5\u4e0b\u4ee3\u7801\u6765\u521b\u5efa\u7ba1\u7406\u9875\u9762:<\/li>\n<\/ol>\n\n\n\n
      \/\/ \u521b\u5efa\u81ea\u5b9a\u4e49\u9875\u9762\nadd_action('admin_menu', 'add_ads_menu');\nfunction add_ads_menu() {\n    add_menu_page(\n        'Ads Management',\n        'Ads',\n        'manage_options',\n        'ads-management',\n        'ads_management_page',\n        'dashicons-admin-settings',\n        6\n    );\n}\n\nfunction ads_management_page() {\n    global $wpdb;\n    $table_name = $wpdb->prefix . 'ads';\n\n    if ($_SERVER['REQUEST_METHOD'] === 'POST') {\n        $mobile_ad = $_POST['mobile_ad'];\n        $pc_ad = $_POST['pc_ad'];\n        $wpdb->insert($table_name, array(\n            'mobile_ad' => $mobile_ad,\n            'pc_ad' => $pc_ad\n        ));\n    }\n\n    $ads = $wpdb->get_results(\"SELECT * FROM $table_name ORDER BY id DESC\");\n    ?>\n    <div class=\"wrap\">\n        <h1>Ads Management<\/h1>\n        <form method=\"post\" action=\"\">\n            <table class=\"form-table\">\n                <tr>\n                    <th scope=\"row\">Mobile Ad<\/th>\n                    <td><textarea name=\"mobile_ad\" rows=\"5\" class=\"large-text\"><\/textarea><\/td>\n                <\/tr>\n                <tr>\n                    <th scope=\"row\">PC Ad<\/th>\n                    <td><textarea name=\"pc_ad\" rows=\"5\" class=\"large-text\"><\/textarea><\/td>\n                <\/tr>\n            <\/table>\n            <?php submit_button(); ?>\n        <\/form>\n        <h2>Ads History<\/h2>\n        <table class=\"wp-list-table widefat striped\">\n            <thead>\n                <tr>\n                    <th>ID<\/th>\n                    <th>Mobile Ad<\/th>\n                    <th>PC Ad<\/th>\n                    <th>Created At<\/th>\n                    <th>Updated At<\/th>\n                <\/tr>\n            <\/thead>\n            <tbody>\n                <?php foreach ($ads as $ad) { ?>\n                    <tr>\n                        <td><?php echo $ad->id; ?><\/td>\n                        <td><?php echo $ad->mobile_ad; ?><\/td>\n                        <td><?php echo $ad->pc_ad; ?><\/td>\n                        <td><?php echo $ad->created_at; ?><\/td>\n                        <td><?php echo $ad->updated_at; ?><\/td>\n                    <\/tr>\n                <?php } ?>\n            <\/tbody>\n        <\/table>\n    <\/div>\n    <?php\n}<\/code><\/pre>\n\n\n\n
        \n
      1. \u5728\u9996\u9875\u6a21\u677f\u6587\u4ef6(front-page.php<\/code>\u6216home.php<\/code>)\u4e2d,\u6dfb\u52a0\u4ee5\u4e0b\u4ee3\u7801\u6765\u663e\u793a\u5e7f\u544a\u5185\u5bb9:<\/li>\n<\/ol>\n\n\n\n
        <?php\n\/*\nTemplate Name: Home Page\n*\/\n\nget_header(); ?>\n\n<div id=\"primary\" class=\"content-area\">\n    <main id=\"main\" class=\"site-main\">\n        <div class=\"row\">\n            <div class=\"col-md-6\">\n                <?php\n                global $wpdb;\n                $table_name = $wpdb->prefix . 'ads';\n                $latest_ad = $wpdb->get_row(\"SELECT mobile_ad FROM $table_name ORDER BY id DESC LIMIT 1\");\n                if ($latest_ad && $latest_ad->mobile_ad) {\n                    echo $latest_ad->mobile_ad;\n                } else {\n                    echo 'No mobile ad content found.';\n                }\n                ?>\n            <\/div>\n            <div class=\"col-md-6\">\n                <?php\n                $latest_ad = $wpdb->get_row(\"SELECT pc_ad FROM $table_name ORDER BY id DESC LIMIT 1\");\n                if ($latest_ad && $latest_ad->pc_ad) {\n                    echo $latest_ad->pc_ad;\n                } else {\n                    echo 'No PC ad content found.';\n                }\n                ?>\n            <\/div>\n        <\/div>\n    <\/main><!-- #main -->\n<\/div><!-- #primary -->\n\n<?php\nget_sidebar();\nget_footer();\n?><\/code><\/pre>\n\n\n\n
        \u8fd9\u6837,\u60a8\u5c31\u53ef\u4ee5\u5728 WordPress \u540e\u53f0\u7684”Ads”\u83dc\u5355\u4e0b\u7ba1\u7406\u5e7f\u544a\u5185\u5bb9,\u5e76\u5728\u9996\u9875\u6a21\u677f\u4e2d\u663e\u793a\u6700\u65b0\u6dfb\u52a0\u7684\u5e7f\u544a\u3002<\/p>\n\n\n\n
        \u5982\u679c\u60a8\u6709\u4efb\u4f55\u5176\u4ed6\u95ee\u9898,\u6b22\u8fce\u968f\u65f6\u544a\u8bc9\u6211\u3002<\/p>\n\n\n\n
        \u597d\u7684,\u6211\u7406\u89e3\u60a8\u73b0\u5728\u6709\u591a\u4e2a\u5e7f\u544a\u4f4d\u7f6e\u9700\u8981\u7ba1\u7406\u3002\u6211\u53ef\u4ee5\u5e2e\u60a8\u6269\u5c55\u4e4b\u524d\u7684\u4ee3\u7801,\u589e\u52a0\u4e24\u7ec4\u65b0\u7684\u5e7f\u544a\u4f4d\u7f6e\u3002<\/p>\n\n\n\n
          \n
        1. \u9996\u5148,\u6211\u4eec\u9700\u8981\u5728\u6570\u636e\u5e93\u4e2d\u6dfb\u52a0\u4e24\u4e2a\u65b0\u7684\u5217\u6765\u5b58\u50a8\u8fd9\u4e24\u4e2a\u65b0\u7684\u5e7f\u544a\u4f4d\u7f6e:<\/li>\n<\/ol>\n\n\n\n
          ALTER TABLE `wp_ads`\n  ADD `banner_ad` text DEFAULT NULL,\n  ADD `sidebar_ad` text DEFAULT NULL;<\/code><\/pre>\n\n\n\n
            \n
          1. \u7136\u540e,\u5728\u7ba1\u7406\u9875\u9762\u7684\u8868\u5355\u4e2d\u6dfb\u52a0\u8fd9\u4e24\u4e2a\u65b0\u7684\u5b57\u6bb5:<\/li>\n<\/ol>\n\n\n\n
            <table class=\"form-table\">\n    <tr>\n        <th scope=\"row\">Mobile Ad<\/th>\n        <td><textarea name=\"mobile_ad\" rows=\"5\" class=\"large-text\"><\/textarea><\/td>\n    <\/tr>\n    <tr>\n        <th scope=\"row\">PC Ad<\/th>\n        <td><textarea name=\"pc_ad\" rows=\"5\" class=\"large-text\"><\/textarea><\/td>\n    <\/tr>\n    <tr>\n        <th scope=\"row\">Banner Ad<\/th>\n        <td><textarea name=\"banner_ad\" rows=\"5\" class=\"large-text\"><\/textarea><\/td>\n    <\/tr>\n    <tr>\n        <th scope=\"row\">Sidebar Ad<\/th>\n        <td><textarea name=\"sidebar_ad\" rows=\"5\" class=\"large-text\"><\/textarea><\/td>\n    <\/tr>\n<\/table><\/code><\/pre>\n\n\n\n
              \n
            1. \u66f4\u65b0\u63d2\u5165\u6570\u636e\u7684\u4ee3\u7801,\u5305\u62ec\u65b0\u7684\u5b57\u6bb5:<\/li>\n<\/ol>\n\n\n\n
              if ($_SERVER['REQUEST_METHOD'] === 'POST') {\n    $mobile_ad = $_POST['mobile_ad'];\n    $pc_ad = $_POST['pc_ad'];\n    $banner_ad = $_POST['banner_ad'];\n    $sidebar_ad = $_POST['sidebar_ad'];\n    $wpdb->insert($table_name, array(\n        'mobile_ad' => $mobile_ad,\n        'pc_ad' => $pc_ad,\n        'banner_ad' => $banner_ad,\n        'sidebar_ad' => $sidebar_ad\n    ));\n}<\/code><\/pre>\n\n\n\n
                \n
              1. \u5728\u5386\u53f2\u8bb0\u5f55\u8868\u683c\u4e2d\u6dfb\u52a0\u65b0\u7684\u5217:<\/li>\n<\/ol>\n\n\n\n
                <thead>\n    <tr>\n        <th>ID<\/th>\n        <th>Mobile Ad<\/th>\n        <th>PC Ad<\/th>\n        <th>Banner Ad<\/th>\n        <th>Sidebar Ad<\/th>\n        <th>Created At<\/th>\n        <th>Updated At<\/th>\n    <\/tr>\n<\/thead>\n<tbody>\n    <?php foreach ($ads as $ad) { ?>\n        <tr>\n            <td><?php echo $ad->id; ?><\/td>\n            <td><?php echo $ad->mobile_ad; ?><\/td>\n            <td><?php echo $ad->pc_ad; ?><\/td>\n            <td><?php echo $ad->banner_ad; ?><\/td>\n            <td><?php echo $ad->sidebar_ad; ?><\/td>\n            <td><?php echo $ad->created_at; ?><\/td>\n            <td><?php echo $ad->updated_at; ?><\/td>\n        <\/tr>\n    <?php } ?>\n<\/tbody><\/code><\/pre>\n\n\n\n
                  \n
                1. \u6700\u540e,\u5728\u9996\u9875\u6a21\u677f\u4e2d\u6dfb\u52a0\u65b0\u7684\u5e7f\u544a\u4f4d\u7f6e\u4ee3\u7801:<\/li>\n<\/ol>\n\n\n\n
                  <div class=\"row\">\n    <div class=\"col-md-6\">\n        <?php\n        $latest_ad = $wpdb->get_row(\"SELECT mobile_ad FROM $table_name ORDER BY id DESC LIMIT 1\");\n        if ($latest_ad && $latest_ad->mobile_ad) {\n            echo $latest_ad->mobile_ad;\n        } else {\n            echo 'No mobile ad content found.';\n        }\n        ?>\n    <\/div>\n    <div class=\"col-md-6\">\n        <?php\n        $latest_ad = $wpdb->get_row(\"SELECT pc_ad FROM $table_name ORDER BY id DESC LIMIT 1\");\n        if ($latest_ad && $latest_ad->pc_ad) {\n            echo $latest_ad->pc_ad;\n        } else {\n            echo 'No PC ad content found.';\n        }\n        ?>\n    <\/div>\n<\/div>\n<div class=\"row\">\n    <div class=\"col-md-12\">\n        <?php\n        $latest_ad = $wpdb->get_row(\"SELECT banner_ad FROM $table_name ORDER BY id DESC LIMIT 1\");\n        if ($latest_ad && $latest_ad->banner_ad) {\n            echo $latest_ad->banner_ad;\n        } else {\n            echo 'No banner ad content found.';\n        }\n        ?>\n    <\/div>\n<\/div>\n<div class=\"row\">\n    <div class=\"col-md-4\">\n        <?php\n        $latest_ad = $wpdb->get_row(\"SELECT sidebar_ad FROM $table_name ORDER BY id DESC LIMIT 1\");\n        if ($latest_ad && $latest_ad->sidebar_ad) {\n            echo $latest_ad->sidebar_ad;\n        } else {\n            echo 'No sidebar ad content found.';\n        }\n        ?>\n    <\/div>\n<\/div><\/code><\/pre>\n\n\n\n
                  \u73b0\u5728\u60a8\u5c31\u53ef\u4ee5\u5728 WordPress \u540e\u53f0\u7684”Ads”\u83dc\u5355\u4e0b\u7ba1\u74064\u4e2a\u4e0d\u540c\u7684\u5e7f\u544a\u4f4d\u7f6e\u4e86\u3002\u5982\u679c\u60a8\u6709\u4efb\u4f55\u5176\u4ed6\u95ee\u9898,\u968f\u65f6\u544a\u8bc9\u6211\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
                  \u5982\u679c\u60a8\u5e0c\u671b\u5c06\u5e7f\u544a\u5185\u5bb9\u5b58\u50a8\u5728\u6570\u636e\u5e93\u4e2d,\u5e76\u81ea\u5df1\u5efa\u7acb\u8868\u548c\u5217,\u90a3\u4e48\u53ef\u4ee5\u91c7\u7528\u4ee5\u4e0b\u65b9\u6cd5: \u8fd9\u6837,\u60a8\u5c31\u53ef\u4ee5\u5728 WordPre […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-54","post","type-post","status-publish","format-standard","hentry","category-suibianjilu"],"_links":{"self":[{"href":"https:\/\/www.weigot.com\/index.php\/wp-json\/wp\/v2\/posts\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.weigot.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.weigot.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.weigot.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.weigot.com\/index.php\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":1,"href":"https:\/\/www.weigot.com\/index.php\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":55,"href":"https:\/\/www.weigot.com\/index.php\/wp-json\/wp\/v2\/posts\/54\/revisions\/55"}],"wp:attachment":[{"href":"https:\/\/www.weigot.com\/index.php\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.weigot.com\/index.php\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.weigot.com\/index.php\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}