{"id":199296,"date":"2025-05-03T12:51:16","date_gmt":"2025-05-03T04:51:16","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199296\/"},"modified":"2025-05-03T12:51:16","modified_gmt":"2025-05-03T04:51:16","slug":"ecshop%e6%8c%89%e5%b1%9e%e6%80%a7%e8%b4%a7%e5%8f%b7%e6%90%9c%e7%b4%a2","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199296\/","title":{"rendered":"ECSHOP\u6309\u5c5e\u6027\u8d27\u53f7\u641c\u7d22"},"content":{"rendered":"

 ECSHOP\u524d\u53f0\u53ef\u6309\u5546\u54c1\u540d\u79f0\u5173\u952e\u5b57\u3001\u5546\u54c1\u8d27\u53f7\u5173\u952e\u5b57\u7b49\u641c\u7d22\u5546\u54c1\uff0c\u4f46\u4e0d\u80fd\u6309\u5c5e\u6027\u8d27\u53f7\u641c\u7d22\u3002\u5c5e\u6027\u8d27\u53f7\u662fECSHOP\u5c5e\u6027\u5e93\u5b58\u7684\u552f\u4e00\u8bc6\u522b\u53f7\uff0c\u5efa\u7acb\u5c5e\u6027\u5e93\u5b58\u540e\uff0c\u5c5e\u6027\u8d27\u53f7\u4fdd\u5b58\u5728products\u8868\u4e2d\uff0c\u4e0b\u9762\u4ecb\u7ecd\u5982\u4f55\u5f00\u53d1\u6309\u5c5e\u6027\u8d27\u53f7\u5173\u952e\u5b57\u641c\u7d22\u3002<\/span><\/p>\n

\u7f16\u8f91\/search.php<\/p>\n

\u4e00\u3001\u4fee\u6539\u641c\u7d22\u5173\u952e\u5b57\u53d8\u91cf\uff0c\u6dfb\u52a0\u5c5e\u6027\u8d27\u53f7\u5173\u952e\u5b57product_sn\u3002<\/p>\n

\n \n 
    \n  \n  
  1. $keywords  <\/span>.<\/span>= <\/span>\"(goods_name LIKE '%$val%' OR goods_sn LIKE '%$val%' OR keywords LIKE '%$val%' $sc_dsad)\"<\/span>; <\/span><\/span><\/li>\n \n <\/ol><\/pre>\n
    \u4fee\u6539\u4e3a<\/p>\n
    \n \n 
      \n  \n  
    1. $keywords  <\/span>.<\/span>= <\/span>\"(goods_name LIKE '%$val%' OR goods_sn LIKE '%$val%' OR product_sn LIKE '%$val%' OR keywords LIKE '%$val%' $sc_dsad)\"<\/span>; <\/span><\/span><\/li>\n  \n  
    2. \/\/\u6dfb\u52a0\u6309\u5c5e\u6027\u8d27\u53f7product_sn\u67e5\u8be2 <\/span><\/span><\/li>\n \n <\/ol><\/pre>\n
      \u4e8c\u3001\u4fee\u6539\u5546\u54c1\u603b\u6570SQL\u8bed\u53e5\uff0c\u6dfb\u52a0goods\u8868\u4e0eproducts\u8868\u8fde\u63a5\u67e5\u8be2\u3002<\/span><\/p>\n
      \n \n 
        \n  \n  
      1. \/* \u83b7\u5f97\u7b26\u5408\u6761\u4ef6\u7684\u5546\u54c1\u603b\u6570 *\/ <\/span><\/span><\/li>\n  \n  
      2. $sql<\/span>   = <\/span>\"SELECT COUNT(*) FROM \"<\/span> .$ecs-<\/span>><\/span>table('goods'). \" AS g \". <\/span><\/span><\/li>\n  \n  
      3.     \"WHERE g.is_delete<\/span> = <\/span>0<\/span> AND <\/span>g.is_on_sale<\/span> = <\/span>1<\/span> AND <\/span>g.is_alone_sale<\/span> = <\/span>1<\/span> $attr_in \". <\/span><\/span><\/li>\n  \n  
      4.     \"AND (( 1 \" . $categories . $keywords . $brand . $min_price . $max_price . $intro . $outstock .\" ) \".$tag_where.\" )\"; <\/span><\/li>\n \n <\/ol><\/pre>\n
        \u4fee\u6539\u4e3a\uff1a<\/p>\n
        \n \n 
          \n  \n  
        1. \/* \u83b7\u5f97\u7b26\u5408\u6761\u4ef6\u7684\u5546\u54c1\u603b\u6570 *\/ <\/span><\/span><\/li>\n  \n  
        2. $sql<\/span>   = <\/span>\"SELECT COUNT(*) FROM \"<\/span> .$ecs-<\/span>><\/span>table('goods'). \" AS g \". <\/span><\/span><\/li>\n  \n  
        3.     \"LEFT JOIN \" . $GLOBALS['ecs']-><\/span>table('products') . \" AS p \". <\/span><\/span><\/li>\n  \n  
        4.         \"ON g.goods_id<\/span> = <\/span>p<\/span>.goods_id \". <\/span><\/span><\/li>\n  \n  
        5.     \"WHERE g.is_delete<\/span> = <\/span>0<\/span> AND <\/span>g.is_on_sale<\/span> = <\/span>1<\/span> AND <\/span>g.is_alone_sale<\/span> = <\/span>1<\/span> $attr_in \". <\/span><\/span><\/li>\n  \n  
        6.     \"AND (( 1 \" . $categories . $keywords . $brand . $min_price . $max_price . $intro . $outstock .\" ) \".$tag_where.\" )\"; <\/span><\/li>\n \n <\/ol><\/pre>\n
          \u4e09\u3001\u4fee\u6539\u5546\u54c1\u67e5\u8be2SQL\u8bed\u53e5\uff0c\u6dfb\u52a0goods\u8868\u4e0eproducts\u8868\u8fde\u63a5\u67e5\u8be2\u3002<\/span><\/p>\n
          \n \n 
            \n  \n  

          1. <\/font><\/li>\n  \n  
          2. \/* \u67e5\u8be2\u5546\u54c1 *\/ <\/span><\/li>\n  \n  
          3. $sql<\/span> = <\/span>\"SELECT g.goods_id, g.goods_name, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, \"<\/span>. <\/span><\/span><\/li>\n  \n  
          4.             \"IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, \". <\/span><\/li>\n  \n  
          5.             \"g.promote_price, g.promote_start_date, g.promote_end_date, g.goods_thumb, g.goods_img, g.goods_brief, g.goods_type \". <\/span><\/li>\n  \n  
          6.         \"FROM \" .$ecs-><\/span>table('goods'). \" AS g \". <\/span><\/span><\/li>\n  \n  
          7.         \"LEFT JOIN \" . $GLOBALS['ecs']-><\/span>table('member_price') . \" AS mp \". <\/span><\/span><\/li>\n  \n  
          8.                 \"ON mp.goods_id<\/span> = g.goods_id AND <\/span>mp.user_rank<\/span> = <\/span>'$_SESSION[user_rank]'<\/span> \". <\/span><\/span><\/li>\n  \n  
          9.         \"WHERE g.is_delete<\/span> = <\/span>0<\/span> AND <\/span>g.is_on_sale<\/span> = <\/span>1<\/span> AND <\/span>g.is_alone_sale<\/span> = <\/span>1<\/span> $attr_in \". <\/span><\/span><\/li>\n  \n  
          10.             \"AND (( 1 \" . $categories . $keywords . $brand . $min_price . $max_price . $intro . $outstock . \" ) \".$tag_where.\" ) \" . <\/span><\/li>\n  \n  
          11.         \"ORDER BY $sort $order\"; <\/span><\/li>\n \n <\/ol><\/pre>\n
            \u4fee\u6539\u4e3a\uff1a<\/p>\n
            \n \n 
              \n  \n  
            1. \/* \u67e5\u8be2\u5546\u54c1 *\/ <\/span><\/span><\/li>\n  \n  
            2. $sql<\/span> = <\/span>\"SELECT g.goods_id, g.goods_name, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, \"<\/span>. <\/span><\/span><\/li>\n  \n  
            3.             \"IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, \". <\/span><\/li>\n  \n  
            4.             \"g.promote_price, g.promote_start_date, g.promote_end_date, g.goods_thumb, g.goods_img, g.goods_brief, g.goods_type \". <\/span><\/li>\n  \n  
            5.         \"FROM \" .$ecs-><\/span>table('goods'). \" AS g \". <\/span><\/span><\/li>\n  \n  
            6.         \"LEFT JOIN \" . $GLOBALS['ecs']-><\/span>table('member_price') . \" AS mp \". <\/span><\/span><\/li>\n  \n  
            7.                 \"ON mp.goods_id<\/span> = g.goods_id AND <\/span>mp.user_rank<\/span> = <\/span>'$_SESSION[user_rank]'<\/span> \". <\/span><\/span><\/li>\n  \n  
            8.         \"LEFT JOIN \" . $GLOBALS['ecs']-><\/span>table('products') . \" AS p \". <\/span><\/span><\/li>\n  \n  
            9.                 \"ON g.goods_id<\/span> = <\/span>p<\/span>.goods_id \". <\/span><\/span><\/li>\n  \n  
            10.         \"WHERE g.is_delete<\/span> = <\/span>0<\/span> AND <\/span>g.is_on_sale<\/span> = <\/span>1<\/span> AND <\/span>g.is_alone_sale<\/span> = <\/span>1<\/span> $attr_in \". <\/span><\/span><\/li>\n  \n  
            11.             \"AND (( 1 \" . $categories . $keywords . $brand . $min_price . $max_price . $intro . $outstock . \" ) \".$tag_where.\" ) \" . <\/span><\/li>\n  \n  
            12.         \"ORDER BY $sort $order\"; <\/span><\/li>\n \n <\/ol><\/pre>\n
               <\/p>\n","protected":false},"excerpt":{"rendered":"
               ECSHOP\u524d\u53f0\u53ef\u6309...<\/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-199296","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199296","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=199296"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199296\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}