{"id":60089,"date":"2025-04-24T11:39:08","date_gmt":"2025-04-24T03:39:08","guid":{"rendered":"https:\/\/fwq.ai\/blog\/60089\/"},"modified":"2025-04-24T11:39:08","modified_gmt":"2025-04-24T03:39:08","slug":"%e5%a6%82%e4%bd%95%e5%9c%a8ecshop%e9%a6%96%e9%a1%b5%e8%b0%83%e7%94%a8%e6%8c%87%e5%ae%9a%e5%88%86%e7%b1%bb%e7%9a%84%e7%83%ad%e9%94%80%e3%80%81%e6%8e%a8%e8%8d%90%e3%80%81%e6%96%b0-2","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/60089\/","title":{"rendered":"\u5982\u4f55\u5728ecshop\u9996\u9875\u8c03\u7528\u6307\u5b9a\u5206\u7c7b\u7684\u70ed\u9500\u3001\u63a8\u8350\u3001\u65b0"},"content":{"rendered":"

 \u627e\u5230ecshop\u7684includes\/lib_goods.php\uff0c\u4fee\u6539\u65b9\u6cd5\u5982\u4e0b<\/span><\/p>\n

\u4ee5\u628aSQL\u8bed\u53e5\u6539\u4e00\u4e0b\uff0c\u4e0ecategory\u8868\u5173\u8054\u5373\u53ef\u5c06 <\/span><\/p>\n

    \n
  1. $sql =  ‘SELECT g.goods_id,g.goods_name, g.goods_name_style,<\/li>\n
  2. g.market_price, g.shop_price AS org_price, g.promote_price, ‘ .<\/li>\n<\/ol>\n

    \u590d\u5236\u4ee3\u7801<\/em> \u6539\u4e3a <\/p>\n

      \n
    1.   $sql =  ‘SELECT g.goods_id,g.cat_id,c.parent_id,g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, ‘ .<\/li>\n<\/ol>\n

      \u590d\u5236\u4ee3\u7801<\/em> \u518d\u5728 <\/p>\n

        \n
      1. ‘LEFT JOIN ‘ . $GLOBALS[‘ecs’]->table(‘brand’) . ‘ AS b ON b.brand_id = g.brand_id ‘ .<\/li>\n<\/ol>\n

        \u590d\u5236\u4ee3\u7801<\/em> \u4e0b\u52a0\u4e00\u53e5 <\/p>\n

          \n
        1. ‘LEFT JOIN ‘ . $GLOBALS[‘ecs’]->table(‘category’) . ‘ AS c ON c.cat_id = g.cat_id ‘ .<\/li>\n<\/ol>\n

          \u590d\u5236\u4ee3\u7801<\/em> \u7136\u540e\u5c06 <\/p>\n

            \n
          1. if (!empty($cats))<\/li>\n
          2.     {<\/li>\n
          3.         $sql .= ” AND (” . $cats . ” OR ” . get_extension_goods($cats) .”)”;<\/li>\n
          4.     }<\/li>\n<\/ol>\n

            \u590d\u5236\u4ee3\u7801<\/em> \u6539\u4e3a <\/p>\n

              \n
            1. if (!empty($cats))<\/li>\n
            2.     {<\/li>\n
            3.         $sql .= ” AND (c.parent_id =” . $cats. ” OR ” . get_extension_goods($cats) .”)”;<\/li>\n
            4.     }<\/li>\n<\/ol>\n

              \u590d\u5236\u4ee3\u7801<\/em> \u8fd9\u4e2a\u662f\u548c\u5206\u7c7b\u8868\u5efa\u7acb\u5173\u8054\uff0c\u8c03\u51fa\u5546\u54c1\u6240\u5728\u5206\u7c7b\u7684\u4e0a\u7ea7\u5206\u7c7b
              \n
              \u7136\u540e\u5728index.php\u4e2d smarty <\/p>\n

                \n
              1. $smarty->assign(‘chot<\/font><\/strong>_goods_35′,   get_category_recommend_goods(‘hot’,’35’));     \/\/\u6307\u5b9a\u5206\u7c7b\u4e0b\u7684\u70ed\u9500\u5546\u54c1<\/li>\n<\/ol>\n

                \u590d\u5236\u4ee3\u7801<\/em> \u6ce8\u610f\u8fd9\u4e2a35\u662f\u4e00\u7ea7\u5206\u7c7b\u7684ID\uff0c\u7136\u540e\u5728\u6a21\u677f\u4e2d\u8c03\u7528\u5373\u53ef
                \n
                <!–{foreach from=$
                \nchot<\/font><\/strong>_goods_35 item=goods}–>
                \n
                         <div style=”padding-top: 8px;” class=”new-tr”>
                \n
                           <a target=”_blank” href=”{$goods.url}”><img width=”116″ height=”130″ border=”0″ alt=”{$goods.name|escape:html}” src=”{$goods.thumb}”><\/a>
                \n
                          <div class=”right”>
                \n
                          <a target=”_blank” href=”{$goods.url}”>{$goods.name|escape:html}<\/a><br>
                \n
                          <span style=”color: rgb(102, 102, 102); text-decoration: line-through;”>\u5e02\u573a\u4ef7\uff1a{$goods.market_price}<\/span><br>
                \n
                          \u7279\u5356\u4ef7\uff1a<span style=”color: rgb(255, 0, 0);”>{$goods.shop_price}<\/span><br>
                \n
                          <span class=”font-gmm”><a  href=”javascript:addToCart({$goods.id})”>\u7acb\u5373\u62a2\u8d2d<\/a><\/span>
                \n
                          <\/div>
                \n
                          <span class=”new-line”><\/span>
                \n
                          <\/div>
                \n
                           <!–{\/foreach}–>
                \n
                \u540c\u7406\uff0c\u65b0\u54c1\uff0c\u63a8\u8350\u90fd\u53ef\u4ee5\u8c03\uff0c\u53ea\u8981\u628ahot\u6539\u4e3anew \u6216\u8005best\u5c31\u53ef\u4ee5\u4e86<\/p>\n","protected":false},"excerpt":{"rendered":"

                 \u627e\u5230ecshop\u7684includes\/lib_goods.php\uff0c\u4fee\u6539\u65b9\u6cd5\u5982\u4e0b \u4ee5\u628aSQL\u8bed\u53e5\u6539\u4e00\u4e0b\uff0c\u4e0ecategory\u8868\u5173\u8054\u5373\u53ef\u5c06 $sql =  ‘SELECT g.goods_id,g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, ‘ . \u590d\u5236\u4ee3\u7801 \u6539\u4e3a   $sql =  ‘SELECT g.goods_id,g.cat_id,c.parent_id,g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, ‘ . \u590d\u5236\u4ee3\u7801 \u518d\u5728 ‘LEFT JOIN ‘ . $GLOBALS[‘ecs’]->table(‘brand’) . ‘ AS b ON b.brand_id = g.brand_id ‘ . \u590d\u5236\u4ee3\u7801 \u4e0b\u52a0\u4e00\u53e5 ‘LEFT JOIN ‘ . $GLOBALS[‘ecs’]->table(‘category’) . ‘ AS c ON […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-60089","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/60089","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=60089"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/60089\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=60089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=60089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=60089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}