{"id":199226,"date":"2025-05-03T09:30:53","date_gmt":"2025-05-03T01:30:53","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199226\/"},"modified":"2025-05-03T09:30:53","modified_gmt":"2025-05-03T01:30:53","slug":"%e4%bf%ae%e6%94%b9ecshop%e9%9a%8f%e6%9c%ba%e6%98%be%e7%a4%ba%e4%ba%a7%e5%93%81%e5%88%86%e7%b1%bb%e9%a1%b5%e9%9d%a2%e4%b8%8b%e7%9a%84%e4%ba%a7%e5%93%81","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199226\/","title":{"rendered":"\u4fee\u6539ecshop\u968f\u673a\u663e\u793a\u4ea7\u54c1\u5206\u7c7b\u9875\u9762\u4e0b\u7684\u4ea7\u54c1"},"content":{"rendered":"

 \u5b9e\u73b0ecshop\u5206\u7c7b\u4e0b\u968f\u673a\u663e\u793a\u5546\u54c1\uff0c\u6253\u7834\u540e\u53f0\u89c4\u5b9a\u7684\u6309\u7167\u4e0a\u67b6\u65f6\u95f4\uff0c\u4ef7\u683c\u3001\u7b49\u5148\u540e\u987a\u5e8f\u6392\u5e8f\uff0c\u8ba9\u5f88\u591a\u4eba\u4e0a\u4f20<\/p>\n

\u5b8c\u6bd5\u4ea7\u54c1\uff0c\u7b2c\u4e00\u9875\u603b\u662f\u663e\u793a\u540c\u7c7b\u5546\u54c1\uff0c\u5982\u4f55\u4fee\u6539ecshop\u968f\u673a\u663e\u793a\u4ea7\u54c1\u5206\u7c7b\u9875\u9762\u4e0b\u7684\u4ea7\u54c1\uff0c\u597d\u6a21\u677f\u544a\u8bc9\u4f60\u65b9\u6cd5\uff1a<\/p>\n

 <\/p>\n

1\u3001\u4e0b\u8f7decshop\u5e76\u5907\u4efd\u4f60\u7684\u6839\u76ee\u5f55\u4e0b\u7684\u6587\u4ef6category.php\u6587\u4ef6<\/p>\n

2\u3001\u627e\u5230\u5982\u4e0b\u4ee3\u7801\u90e8\u5206\uff0c\u5927\u7ea6\u5728450\u884c\uff1a<\/p>\n

 <\/p>\n

\n \n 
    \n  \n  
  1. \/* \u83b7\u5f97\u5546\u54c1\u5217\u8868 *\/ <\/span><\/span><\/li>\n  \n  
  2.     $sql<\/span> = \u2018SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, \u2018 . <\/span><\/span><\/li>\n  \n  
  3.                 \u201cIFNULL(mp.user_price, g.shop_price * \u2018$_SESSION[discount]\u2018) AS shop_price, g.promote_price, g.goods_type, \u201d . <\/span><\/li>\n  \n  
  4.                 \u2018g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img \u2018 . <\/span><\/li>\n  \n  
  5.             \u2018FROM \u2018 . $GLOBALS['ecs']-><\/span>table(\u2018goods\u2019) . \u2018 AS g \u2018 . <\/span><\/span><\/li>\n  \n  
  6.             \u2018LEFT JOIN \u2018 . $GLOBALS['ecs']-><\/span>table(\u2018member_price\u2019) . \u2018 AS mp \u2018 . <\/span><\/span><\/li>\n  \n  
  7.                 \u201cON mp.goods_id<\/span> = g.goods_id AND <\/span>mp.user_rank<\/span> = \u2018$_SESSION[user_rank]\u2018 \u201d . <\/span><\/span><\/li>\n  \n  
  8.             \u201cWHERE $where $ext ORDER BY $sort $order\u201d; <\/span><\/li>\n \n <\/ol><\/pre>\n
     <\/p>\n
    \u66ff\u6362\u4fee\u6539\u4e3a<\/p>\n
     <\/p>\n
    \n \n 
      \n  \n  
    1. $<\/span>zz<\/span>=<\/span>1<\/span>; <\/span><\/span><\/li>\n  \n  
    2.     $sql<\/span> = \u2018SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, \u2018 . <\/span><\/span><\/li>\n  \n  
    3.                 \u201cIFNULL(mp.user_price, g.shop_price * \u2018$_SESSION[discount]\u2018) AS shop_price, g.promote_price, g.goods_type, \u201d . <\/span><\/li>\n  \n  
    4.                 \u2018g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img \u2018 . <\/span><\/li>\n  \n  
    5.             \u2018FROM \u2018 . $GLOBALS['ecs']-><\/span>table(\u2018goods\u2019) . \u2018 AS g \u2018 . <\/span><\/span><\/li>\n  \n  
    6.             \u2018LEFT JOIN \u2018 . $GLOBALS['ecs']-><\/span>table(\u2018member_price\u2019) . \u2018 AS mp \u2018 . <\/span><\/span><\/li>\n  \n  
    7.                 \u201cON mp.goods_id<\/span> = g.goods_id AND <\/span>mp.user_rank<\/span> = \u2018$_SESSION[user_rank]\u2018 \u201d . <\/span><\/span><\/li>\n  \n  
    8.             \u201cWHERE $where $ext\u201d; <\/span><\/li>\n  \n  
    9. $sql .<\/span>= $<\/span>zz<\/span> == 0 ? \u201d $order\u201d : \u201d ORDER BY RAND()\u201d; <\/span><\/span><\/li>\n \n <\/ol><\/pre>\n
       <\/p>\n
      \u5373\u53ef\u5b9e\u73b0ecshop\u5206\u7c7b\u4e0b\u7684\u4ea7\u54c1\u968f\u673a\u663e\u793a\u4e86\uff0c\u4f46\u662f\u524d\u63d0\u662f\uff0c\u5230\u540e\u53f0\u6e05\u7a7a\u7f13\u5b58\u6765\u5b9e\u73b0\uff0c\u4e0d\u80fd\u6bcf\u6b21\u5237\u65b0\u90fd\u968f\u673a\uff0c\u5426<\/p>\n
      \u5219\u670d\u52a1\u5668\u4f1a\u53d7\u4e0d\u4e86\u7684\uff0c\u8fd9\u6837\u5c31\u5b9e\u73b0\u4e86\u548c\u9996\u9875\u7cbe\u54c1\u3001\u65b0\u54c1\u3001\u4fc3\u9500\u7b49\u680f\u76ee\u540c\u6837\u7684\u529f\u80fd\u3002<\/p>\n
      \u901a\u8fc7ecshop\u6e05\u7a7a\u7f13\u5b58\u6765\u5b9e\u73b0\u4ea7\u54c1\u7684\u968f\u673a\uff0c\u968f\u673a\u663e\u793a\u7adf\u7136\u4f1a\u5360\u7528\u670d\u52a1\u5668\u8fc7\u591a\u8d44\u6e90\u3002\u6240\u4ee5\u4e0d\u5efa\u8bae\u8fd9\u6837\u4f18\u5316\uff01<\/p>\n
       <\/p>\n","protected":false},"excerpt":{"rendered":"
       \u5b9e\u73b0ecshop\u5206\u7c7b...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4925],"tags":[],"class_list":["post-199226","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/comments?post=199226"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199226\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}