{"id":60867,"date":"2025-04-26T09:48:05","date_gmt":"2025-04-26T01:48:05","guid":{"rendered":"https:\/\/fwq.ai\/blog\/60867\/"},"modified":"2025-04-26T09:48:05","modified_gmt":"2025-04-26T01:48:05","slug":"%e4%bf%ae%e6%94%b9zencart%e6%96%b0%e8%bf%9b%e5%95%86%e5%93%81%e9%9a%8f%e6%9c%ba%e6%8e%92%e5%ba%8f%e7%9a%84%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/60867\/","title":{"rendered":"\u4fee\u6539zencart\u65b0\u8fdb\u5546\u54c1\u968f\u673a\u6392\u5e8f\u7684\u65b9\u6cd5"},"content":{"rendered":"

zencart\u65b0\u8fdb\u5546\u54c1\u7684\u968f\u673a\u6392\u5e8f\u4fee\u6539\u65b9\u6cd5\u7b2c\u4e00\u6b65\uff1a\u9996\u5148\uff0c\u65b0\u8fdb\u5546\u54c1\u53ef\u4ee5\u81ea\u5df1\u5b9a\u4e49\u65f6\u95f4\u6bb5\uff1a\u5546\u5e97\u8bbe\u7f6e\uff0d\u6700\u5927\u503c\uff0d\u65b0\u8fdb\u5546\u54c1\u7684\u5b9a\u4e49<\/p>\n

zencart\u65b0\u8fdb\u5546\u54c1\u7684\u968f\u673a\u6392\u5e8f\u4fee\u6539\u65b9\u6cd5\u7b2c\u4e8c\u6b65\uff1a
\u4fee\u6539\u9996\u9875\u4e0a\u65b0\u8fdb\u5546\u54c1\uff1a
\/includes\/modules\/new_products.php<\/p>\n

\u5728$new_products_query\u91cc\u589e\u52a0\u76f8\u5e94ORDER BY xxx<\/p>\n

\u4f8b\uff1aselect distinct p.products_id, p.products_image,p.products_tax_class_id, pd.products_name, p.products_date_added,p.products_price, p.products_type, p.master_categories_id fromzen_products p, zen_products_description pd where p.products_id =pd.products_id and pd.language_id = ‘1’ and p.products_status = 1order by pd.products_name<\/p>\n

zencart\u65b0\u8fdb\u5546\u54c1\u7684\u968f\u673a\u6392\u5e8f\u4fee\u6539\u65b9\u6cd5\u7b2c\u4e09\u6b65\uff1a
\u4fee\u6539\u8fb9\u6846\u4e2d\u65b0\u8fdb\u5546\u54c1\uff1a
\/includes\/modules\/sideboxes\/whats_new.php
\u5c06
$random_whats_new_sidebox_product =zen_random_select($random_whats_new_sidebox_product_query);
\u6539\u4e3a
$random_whats_new_sidebox_product =$db->Execute($random_whats_new_sidebox_product_query);<\/p>\n

zencart\u65b0\u8fdb\u5546\u54c1\u7684\u968f\u673a\u6392\u5e8f\u4fee\u6539\u65b9\u6cd5\u7b2c\u56db\u6b65\uff1a<\/p>\n

\u7136\u540e\u5c06\/includes\/modules \/new_products.php \u6587\u4ef6\u4e2d\u7684\uff1a
$db->ExecuteRandomMulti
\u6539\u4e3a
$db->Execute<\/p>\n

MoveNextRandom()
\u6539 \u4e3a
MoveNext()<\/p>\n","protected":false},"excerpt":{"rendered":"

zencart\u65b0\u8fdb\u5546\u54c1\u7684\u968f\u673a\u6392\u5e8f\u4fee\u6539\u65b9\u6cd5\u7b2c\u4e00\u6b65\uff1a\u9996\u5148\uff0c\u65b0\u8fdb\u5546\u54c1\u53ef\u4ee5\u81ea\u5df1\u5b9a\u4e49\u65f6\u95f4\u6bb5\uff1a\u5546\u5e97\u8bbe\u7f6e\uff0d\u6700\u5927\u503c\uff0d\u65b0\u8fdb\u5546\u54c1\u7684\u5b9a\u4e49 zencart\u65b0\u8fdb\u5546\u54c1\u7684\u968f\u673a\u6392\u5e8f\u4fee\u6539\u65b9\u6cd5\u7b2c\u4e8c\u6b65\uff1a \u4fee\u6539\u9996\u9875\u4e0a\u65b0\u8fdb\u5546\u54c1\uff1a \/includes\/modules\/new_products.php \u5728$new_products_query\u91cc\u589e\u52a0\u76f8\u5e94ORDER BY xxx \u4f8b\uff1aselect distinct p.products_id, p.products_image,p.products_tax_class_id, pd.products_name, p.products_date_added,p.products_price, p.products_type, p.master_categories_id fromzen_products p, zen_products_description pd where p.products_id =pd.products_id and pd.language_id = ‘1’ and p.products_status = 1order by pd.products_name zencart\u65b0\u8fdb\u5546\u54c1\u7684\u968f\u673a\u6392\u5e8f\u4fee\u6539\u65b9\u6cd5\u7b2c\u4e09\u6b65\uff1a \u4fee\u6539\u8fb9\u6846\u4e2d\u65b0\u8fdb\u5546\u54c1\uff1a \/includes\/modules\/sideboxes\/whats_new.php \u5c06 $random_whats_new_sidebox_product =zen_random_select($random_whats_new_sidebox_product_query); \u6539\u4e3a $random_whats_new_sidebox_product =$db->Execute($random_whats_new_sidebox_product_query); zencart\u65b0\u8fdb\u5546\u54c1\u7684\u968f\u673a\u6392\u5e8f\u4fee\u6539\u65b9\u6cd5\u7b2c\u56db\u6b65\uff1a \u7136\u540e\u5c06\/includes\/modules \/new_products.php \u6587\u4ef6\u4e2d\u7684\uff1a $db->ExecuteRandomMulti \u6539\u4e3a $db->Execute MoveNextRandom() \u6539 \u4e3a MoveNext()<\/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-60867","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/60867","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=60867"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/60867\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=60867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=60867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=60867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}