{"id":59945,"date":"2025-04-24T10:23:28","date_gmt":"2025-04-24T02:23:28","guid":{"rendered":"https:\/\/fwq.ai\/blog\/59945\/"},"modified":"2025-04-24T10:23:28","modified_gmt":"2025-04-24T02:23:28","slug":"%e5%9c%a8ecshop%e9%a6%96%e9%a1%b5%e6%98%be%e7%a4%ba%e5%90%84%e7%ad%89%e7%ba%a7%e4%bc%9a%e5%91%98%e4%bb%b7%e6%a0%bc%e7%9a%84%e6%96%b9%e6%b3%95-2","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/59945\/","title":{"rendered":"\u5728ECSHOP\u9996\u9875\u663e\u793a\u5404\u7b49\u7ea7\u4f1a\u5458\u4ef7\u683c\u7684\u65b9\u6cd5"},"content":{"rendered":"<p>\u5728ECSHOP<span>\u9996\u9875<\/span>\u663e\u793a\u5404<span>\u7b49\u7ea7<\/span><span>\u4f1a\u5458<\/span><span>\u4ef7\u683c<\/span><br \/> \u6ce8\u610f\uff1a\u4ee5\u4e0b\u64cd\u4f5c\u5c3d\u91cf\u4e0d\u8981\u4f7f\u7528\u8bb0\u4e8b\u672c\u6765\u7f16\u8f91\uff0c\u5c24\u5176\u662f\u4f7f\u7528UTF-8\u7f16\u7801\u7684\u670b\u53cb\u4eec\u3002<br \/> \u4ee5\u4e0b\u4fee\u6539\u4ee5<span>\u5b98\u65b9<\/span>\u9ed8\u8ba4<span>\u6a21\u677f<\/span>\u4e3a\u4f8b\uff1a<br \/> 1\u3001<br \/> \u6253\u5f00includes\/lib_goods.php <br \/> <span>\u641c\u7d22<\/span><br \/> $goods[$idx][&#8216;url&#8217;]&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; = build_uri(&#8216;goods&#8217;, array(&#8216;gid&#8217; =&gt; $row[&#8216;goods_id&#8217;]), $row[&#8216;goods_name&#8217;]);<br \/> \u4e00\u5171\u80fd\u641c\u7d22\u5230\u56db\u5904\uff0c\u5728\u6bcf\u4e00\u5904\u7684\u540e\u9762\u90fd\u52a0\u4e0a\u4e0b\u9762<span>\u4ee3\u7801<\/span>\uff08\u6ce8\u610f\u662f\u6bcf\u4e00\u5904\u54e6\uff0c\u8fd9\u6837\u5199\u5bf9<span>\u65b0\u624b<\/span>\u670b\u53cb\u6765\u8bf4\u6bd4\u8f83\u5bb9\u6613\u64cd\u4f5c\uff09<\/p>\n<p>&nbsp;<\/p>\n<p>\/* \u4f1a\u5458\u7b49\u7ea7\u4ef7\u683c *\/<br \/> &nbsp;&nbsp; $sql = &#8220;SELECT rank_id, IFNULL(mp.user_price, r.discount * $row[shop_price] \/ 100) AS price, r.rank_name, r.discount &#8221; .<br \/> &nbsp;&nbsp;&nbsp; &#8216;FROM &#8216; . $GLOBALS[&#8216;ecs&#8217;]-&gt;table(&#8216;user_rank&#8217;) . &#8216; AS r &#8216; .<br \/> &nbsp;&nbsp;&nbsp; &#8216;LEFT JOIN &#8216; . $GLOBALS[&#8216;ecs&#8217;]-&gt;table(&#8216;member_price&#8217;) . &#8221; AS mp &#8220;.<br \/> &nbsp;&nbsp;&nbsp; &#8220;ON mp.goods_id = &#8216;$row[goods_id]&#8217; AND mp.user_rank = r.rank_id &#8221; .<br \/> &nbsp;&nbsp;&nbsp; &#8220;WHERE r.show_price = 1 OR r.rank_id = &#8216;$_SESSION[user_rank]'&#8221;;<br \/> &nbsp;&nbsp; $res_up = $GLOBALS[&#8216;db&#8217;]-&gt;query($sql);<br \/> &nbsp;&nbsp; while ($row_up = $GLOBALS[&#8216;db&#8217;]-&gt;fetchRow($res_up))<br \/> &nbsp;&nbsp;&nbsp; {<br \/> &nbsp;&nbsp;&nbsp; $goods[$idx][&#8216;user_price&#8217;][$row_up[&#8216;rank_id&#8217;]] = array(<br \/> &nbsp;&nbsp;&nbsp;&nbsp; &#8216;rank_name&#8217; =&gt; htmlspecialchars($row_up[&#8216;rank_name&#8217;]),<br \/> &nbsp;&nbsp;&nbsp;&nbsp; &#8216;price&#8217; =&gt; price_format($row_up[&#8216;price&#8217;]));<br \/> &nbsp;&nbsp;&nbsp; }<\/p>\n<p>&nbsp;<\/p>\n<p>2\u3001<br \/> \u4f9d\u6b21\u6253\u5f00 library\/recommend_hot.lbi&nbsp;&nbsp;,&nbsp;&nbsp;library\/recommend_best.lbi , library\/recommend_new.lbi \uff0c library\/recommend_promotion.lbi <span>\u6587\u4ef6<\/span><\/p>\n<p> \u5728<br \/> &lt;\/font&gt;<br \/> \u540e\u9762\u589e\u52a0<\/p>\n<p>&nbsp;<\/p>\n<p>&lt;p style=&#8221;background:#eee;&#8221;&gt;<br \/> {if $goods.user_price}<br \/> {foreach from=$goods.user_price item=user_price }<br \/> &lt;br&gt;<br \/> {$user_price.rank_name}\uff1a{$user_price.price}<br \/> {\/foreach}<br \/> {\/if}<br \/> &lt;\/p&gt;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728ECSHOP\u9996\u9875\u663e\u793a\u5404\u7b49\u7ea7\u4f1a\u5458\u4ef7\u683c \u6ce8\u610f\uff1a\u4ee5\u4e0b\u64cd\u4f5c\u5c3d\u91cf\u4e0d\u8981\u4f7f\u7528\u8bb0\u4e8b\u672c\u6765\u7f16\u8f91\uff0c\u5c24\u5176\u662f\u4f7f\u7528UTF-8\u7f16\u7801\u7684\u670b\u53cb\u4eec\u3002 \u4ee5\u4e0b\u4fee\u6539\u4ee5\u5b98\u65b9\u9ed8\u8ba4\u6a21\u677f\u4e3a\u4f8b\uff1a 1\u3001 \u6253\u5f00includes\/lib_goods.php \u641c\u7d22 $goods[$idx][&#8216;url&#8217;]&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp; = build_uri(&#8216;goods&#8217;, array(&#8216;gid&#8217; =&gt; $row[&#8216;goods_id&#8217;]), $row[&#8216;goods_name&#8217;]); \u4e00\u5171\u80fd\u641c\u7d22\u5230\u56db\u5904\uff0c\u5728\u6bcf\u4e00\u5904\u7684\u540e\u9762\u90fd\u52a0\u4e0a\u4e0b\u9762\u4ee3\u7801\uff08\u6ce8\u610f\u662f\u6bcf\u4e00\u5904\u54e6\uff0c\u8fd9\u6837\u5199\u5bf9\u65b0\u624b\u670b\u53cb\u6765\u8bf4\u6bd4\u8f83\u5bb9\u6613\u64cd\u4f5c\uff09 &nbsp; \/* \u4f1a\u5458\u7b49\u7ea7\u4ef7\u683c *\/ &nbsp;&nbsp; $sql = &#8220;SELECT rank_id, IFNULL(mp.user_price, r.discount * $row[shop_price] \/ 100) AS price, r.rank_name, r.discount &#8221; . &nbsp;&nbsp;&nbsp; &#8216;FROM &#8216; . $GLOBALS[&#8216;ecs&#8217;]-&gt;table(&#8216;user_rank&#8217;) . &#8216; AS r &#8216; . &nbsp;&nbsp;&nbsp; &#8216;LEFT JOIN &#8216; . $GLOBALS[&#8216;ecs&#8217;]-&gt;table(&#8216;member_price&#8217;) [&hellip;]<\/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-59945","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59945","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=59945"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/59945\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=59945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=59945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=59945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}